Issue with task health formula

DianeO

Hi all,

I'm defining a column that will help PM's easily see which rows in a very large timeline to focus on (Health is the column name).

I typed this directly into SmartSheet to avoid any invisible characters. I've looked at it many times and can't see an issue with the formula. Can anyone else see it?

Based on columns named "Status", "Start Date", End Date"

Status = "Not Started", "In Progress", "Complete" NOTE: this column is a formula based on % complete

=IF(Status@row = "Complete", "🟢", IF([End Date]@row < TODAY, "🔴", IF(AND(Status@row="In Progress", [Start Date]@row < TODAY()), "🟡" , IF(AND(Status@row ="Not Started", [Start Date]@row > TODAY()), "⚪️", "⚪️"))))

Nic Larsen

Looks like you're missing () after the first use of TODAY in the second section.

Nic Larsen

Looks like you're missing () after the first use of TODAY in the second section.

DianeO

That was the answer! I had only looked at it 32 times and missed that detail. Thank you @Nic Larsen !