edited 11/22/22 in Formulas and Functions


I'm trying to create the following formula for a RAID Log Task@Risk, to display a Red Flag if criteria is met:

If [End Date] is blank, then "Update Date", If the STATUS chosen from the STATUS drop-down is "Not Started" or "In Progress" or "Cancelled" or "On Hold" or "Delayed" & [End Date] has passed Today's date, then "Red Flag"

I've tried this formula, but have not succeeded

=IF(ISBLANK([End Date]@row], "Update Date", IF(AND([Status@row] = “Not Started”, IF[Status@row] = “In Progress”, IF[Status@row] = “Cancelled”, IF[Status@row] = “On Hold”, IF[Status@row] = “Delayed”, IF[End Date]@row >= TODAY()),"Complete",”Red”)))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!