Flagging Overdue Tasks

GeorgiaL

Hi

I need help flagging a blank approval if it has not been submitted within 30 days of submission.

I have a Date Submitted Column and an Approval column. I have set up a Flag column and added the below formula which does not seem to be working.

=IF(AND([Date Submitted]@row < TODAY(+30), [Line Manager Approval]@row = ""), 1, "")

Please can someone help identify where i am going wrong here? Thanks!

Paul Newcome

Try changing it to

TODAY(-30)

Paul Newcome

Try changing it to

TODAY(-30)

GeorgiaL

Great! Thank you :)

Paul Newcome

Happy to help. 👍️

VicFar

@Paul Newcome I have a formula i would like to create to showcase the "Due Date" vs. Today() as "Overdue". My current formula is =

=IF(AND([Tactical Due for Approval]@row < TODAY() = "OVERDUE")) but its showing up as incorrect. Can you help?

Paul Newcome

@VicFar You don't need the AND function, and you need to get rid of one of the closing parenthesis at the end of the formula.