Flag as At Risk if Due Date in Past and Complete = X

mmac ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hello, I'm looking for support on what formula to include in the Flag symbol column that would act against the following:

If Due Date is in the past and Complete = X (Visual Symbol), then flag At Risk column with Red flag

Currently, using formula below to flag At Risk column with Red flag based on requested due date column.

=IF([Requested Due Date]1 < TODAY(), 1, 0)




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!