RYG-ball with nested IF statement (combined with AND)

Options

Hello community,

I simply want to change the status of a RYG-ball by comparing two conditions.

If Condition1 AND Condition2 are FALSE than the ball should be RED.

If Condition1 AND Condition2 are TRUE than the ball should be GREEN.

In any other case the ball should be YELLOW.

When building the formula, this worked as an intermediate result

=IF(AND(Condition1 = 0; Condition2 = 0);"Red";"Green")

but adding an additional condition ended up with UNPARSABLE:

=IF(AND(Condition1 = 0; Condition2 = 0); "Red";IF(AND(Condition1 = 1;Condition2 = 1); "Green; "Yellow"))

I know this is not rocket science, but I am stuck. Help articles did not really help me. I guess it's the syntax or brackets.

Can someone have a quick look on my problem?

Thank you in advance.

Best regards,

Holger

Tags:

Best Answer

Answers

  • L_123
    L_123 ✭✭✭✭✭✭
    Options

    You are missing a quote on green in your second formula.

  • True - but formula still refuses to work and replies with #UNPARSEABLE.

    Any further ideas?

    Holger

  • At least I am happy, that the Syntax was correct.

    After re-typing the formula with commas instead of semi-colons I noticed, that Smartsheet changed the commas back to semi-colons after hitting RETURN. Now the formula was working as expected.

    Is it possible that there is any hidden localization topic? I am working with settings set to German. So "Yellow" would be "Gelb". I am not really convinced that commas are translated to semi-colons the same way, or does it?

    Nevertheless this statement made it (for row 595):

    =IF(AND(ColPri595 = 0; ColFo595 = 0); "Rot"; IF(AND(ColPri595 = 1; ColFo595 = 1); "Grün"; "Gelb"))

    Thank you for your quick and helpful support.👍️

    Holger😀

  • L_123
    L_123 ✭✭✭✭✭✭
    Options

    Commas and semi-colons are the same thing in smartsheet, if you are in europe smartsheet expects you to use semi-colons, elsewhere commas. It is surprising to me that switching to commas fixed it, I would have expected smartsheet to not even try to read it. There must have been some kind of smartsheet side error. Glad you got it sorted :)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!