Room Tags with IF/Then Labels

[Anonymous]

Hello Dears,

I have created a shared yes/no parameter for rooms, for "Floor Demolition" . When I create Room Tags with this parameter, I get a simple "Yes" or "No" in the tag, depending on whether I have ticked the option or not. I want the tag to say, "Floor Demolished", in case the Floor demolished options is ticked, and want it to be blank if the option is not ticked. How can I achieve this text swap? Any way to put a formula in the label which says something along the lines of, IF "Yes" then "Floor Demolished", IF "No" then " " ?

[martijn_pater · Accepted solution]

You could do it using a calculated value in the label.
formula: IF(<sharedparameter>, "demolished", "not demolished")

..or vice versa IF (not(<sharedparameter>, "not demolished", "demolished") works too.

edit: just wondering if you wouldn't just need a schedule though?

[ToanDN · Accepted solution]

If (Floor demolition, "Floor Demolished", " ")

[Anonymous]

I did the exact same thing yesterday (although clearly I didn't) and it didn't work. Now it did. Thanks! 

My mistake probably was that I added the Floor Demolished field to the label and then did the formula. This time, I just did the formula, and it worked! Thanks for the screenshot. It helped me identify the apparent mistake.

[martijn_pater · Accepted solution]

Small correction in my previous reply... IF (not(<sharedparameter>), "not demolished", "demolished")

...and you can fill in " " instead of "not demolished" as Toan showed above, to answer the question precisely. edit: althought it is "along the lines"  🙂