Flagging when deadline is within 14 days



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?




  • Mike Wilday
    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) 

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!