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.
IF AND formula for RGY
I am working on a project plan that needs to show the "health" of each task based on the finish date and the status. I've been able to do a formula that checks the status and then selects the correct RGY and I've been able to do a formula that checks the finish and selects the correct RGY but I've been unsuccessful with combining the two in a nested formula. Here is what I've tried so far:
=IF(TODAY() > Finish6, IF(Status6 = "Not Started", "Red", IF(Status6 = "Completed", "Green", IF(Status6 = "In Progress", "Yellow"))))