Use a formula to change the row's health


In a schedule, I'm trying to change the row's health to "red" when the current date is past the "Finish" date and the task is less then 100% complete. I can't get the formula to work when I try to make use of the "% Complete" column. Here is what I'm trying:

=IF(AND(Finish@row < TODAY(), [% Complete]@row <> "100"), "Red", "Green")

It accepts the formula, but the status is always Red no matter what value is entered in the "% Complete" cell.

Any thoughts?




Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!