Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Nesting Formulas excluding future dates
I have a Nested Formula that looks like this.
=IF((Eficiencia19) >= 0.9, "Green", IF((Eficiencia19) <= 0.7, "Red", IF((Eficiencia19) > 0.7, "Yellow")))
What it does , it automatically put a symbol, depending of the value of a cell. It does this independendly of the date.
Green : >=0.90
Yellow: > 0.70 and < 0.90 ( a little tricky)
Red: <= 0.70
How can i add a condition that put the red symbol only on task that meet that criteria (done), but exclude the task that are in the future.