Flagging when deadline is within 14 days

Meagan Tilley

Hello,

To start - I'm not great at formulas, to be honest. I have my SS set up that when the deadline is within 14 days, the date will turn red. When that happens, I'd also like to have my red flag checked.

What is the formula for this? Can anyone help me out?

Thanks!!

Mike Wilday

Put this in your flag column. Written for row 23 revise column title and row number to adjust. 

=IF([Date Column Title]23  - TODAY() <= 14, 1, 0)

Do you have another column marking the task as complete? Like a status column? If so, you can adjust this so that if the task is complete its not red-flagged.

=IF(AND([Status Column]<>"Complete", [Date Column Title]23  - TODAY() <= 14), 1, 0)