Health Status Formula

lukas.johnson

Hi!

Currently, I have a formula in place to indicate R,Y,G Health based on the Start/Due Date. Is it possible to add an =OR function so that if "Status" column is switched to complete the Health will indicate green.

Sorry .. very new to this.

ker9

You are missing the 2nd "If" in bold:

=If(Status@row="Complete", "Green", IF([Due

ker9

Adding an additional IF statement to the beginning of your formula should work.

You will also need to add an additional closing parenthesis at the end of the formula.

IF(Status@row = "Complete", "Green", + existing formula + additional )

Hope this helps!

lukas.johnson

https://community.smartsheet.com/discussion/comment/374591#Comment_374591

Thanks for your reply! Is this the way it should be written? If so I get a unparseable error. Thoughts?

ker9

You are missing the 2nd "If" in bold:

=If(Status@row="Complete", "Green", IF([Due

lukas.johnson

@ker9 There it is. Thank you so much!