Flagging Overdue Tasks


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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!