Parent Row Schedule Health functionality

Hello,

I have a column formula that is returning random results, mostly on parent rows. The formula is:

=IF(Status@row = "Complete", "Green", IF(OR(Status@row = "In Progress", Status@row = "Not Started", Status@row = "On Hold"), IF(ISBLANK([Target End Date]@row), "Red", IF([Target End Date]@row < TODAY(), "Red", IF([Target End Date]@row <= TODAY() + 7, "Yellow", "Target End Date"))), ""))

Here is the screenshot of the results it is returning, with the rows in question highlighted. What am I missing? Thank you in advance @Paul Newcome @Andrée Starå



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!