Flag as At Risk if Due Date in Past and Complete = X
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
Check out the Formula Handbook template!