At Risk Formula Update

Currently using the Onboarding Template Set and in the Sheet Onboarding timeline, I have the Risk flag set, the current formula is to flag if the end date is in the past and the status is not compete (for the row)formula is =IF(AND([End Date]9 < TODAY(), NOT(Status9 = "Complete")), 1, 0) but I need to update it because I want the risk flag to be false if the status is On Hold or Cancelled regardless of what the end date reads? How would I write that in the formula? Any ideas?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!