How do I write in:
=IF(A has any value at all meaning characters or numbers,make it this?
Big thanks mate! I just can’t get this string to work! 
This is what I’m trying to do:
If A & B have no values: display as Red
If A & B both have values: display as Red
If A only has a value display as Green
If B only has a value display as Grey
I’ve been trying for hours and can’t get the required results!
Have you tried stichting multiple IF statements together by ; in one sentence.
IF … ; IF …
1 Like
logic test.skp (23.1 KB)
is display the object material or an option attribute color?
@Wo3Dan answer inspired the add up after checking if his suggestion would work.
1 Like
Seems Sketchup reads a blank cell as an error. You need to start with a zero or some other value in the attributes box to get it to work. Try this one.Like This?.skp (19.3 KB)
1 Like
Yes, trying that now, but its a bit of an issue as Ryan points out Sketchup returns an error if the cell is empty!
Yeah, I did trial this idea, though the issue is that if there is a number already in the dialogue it overcomes the need to have the red alert! The alert was to say the component has no yet been numbered.
Yeah, that was obviously what I was getting yesterday! However, in regards to your solution, the red was to alert that the component hadn’t been numbered, or had been numbered when the component had already responded as being standard.
We have around 200 of the same component in a home with varied modifications, and they need to be numbered sequentially (excepting where one of four standards). If a panel is skipped during the numbering all hell can break loose!
Big thanks for help though!
With the DCs should you not use the instance name as the labeling? then you can see in outliner (any out of order or missed) and the option dialog if “Name” attribute not used, or connection broken) or in the report any discrepancies.
Further to this you could create a ruby script to go through a selection and highlight any faults
I suggest you change the title of your post to something more on topic, its certainly not silly!
2 Likes
Thanks mate, that’s not a bad option!!!
Though it does become problematic unless the instance name can be generated by the DC!
In the case below, STANDARD HEIGHT PANEL resolves to (in this case) E27 only when all parameters are consistent with a standard panel (for your info these are just pressed and require no further mods). As soon as a panel is modified in any way to make it non-standard only then the panel requires numbering
If you have an attribute that generates the standard notation, then a script can read and place it in the instance name. For other notation it may add a number/code to suit, If you private message your DC (as likely its confidential) I can look at it and see if I can create a work flow and script to suit.
1 Like