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

mmac

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)

Mike Wilday

Try this - assuming X is the indicator you are using. 

=IF(AND([Requested Due Date]@row < TODAY(),Complete@row = "X"), 1, 0)

mmac

Thank you! That worked perfectly.

Mike Wilday

Great! You're welcome. Glad I could be of assistance.