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)

Find more posts tagged with

Formulas

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

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

Thank you! That worked perfectly.

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

Sheet Countdown Timer
Happy Thursday. I know many have asked this question before, but does anyone know of a way to have a column actively countdown time? Even if a plugin is needed, it will be considered. Here is what I'm looking to do. When a form is filled out and a new line is added to the sheet, I'd like the "Countdown Timer" column to…
INCORRECT ARGUMENT SET on an =IF function
I'm trying to pull in the contact information of a second HR Business Partner, contingent on the department of the individual, from a separate reference sheet. However, not all departments have a second HRBP— so if the column of "second HRBP contact info" is blank, I don't want anything to be pulled into the new sheet's…
Automation not triggering when % Complete shows '100% instead of 100%
I have an automation set up so that when the Status column changes to Complete, Canceled, or Not Needed, Smartsheet automatically updates the % Complete column to 100% (Text/Number column type). After that, another workflow should trigger to alert the next person that their task is ready. This worked fine before, but…