30 days past due warning

Kimbh · 05/17/23

Hi, I need to find automation or formula but not sure which. I have a column of due dates, I need a another column to say "30 days" if due date column is over 30 days past due. Any help is appreciated.

Thank you

Kim

Paul Newcome · 05/17/23

Try this:

=IF([Due Date]@row< TODAY(-30), "30 days")

Paul Newcome · 05/17/23

Try this:

=IF([Due Date]@row< TODAY(-30), "30 days")

Kimbh · 05/17/23

https://community.smartsheet.com/discussion/comment/376308#Comment_376308

I have looked at these formulas with today in them all day. I didn't think I could use them because it referred to TODAY as in today's date. Thank you so much

Paul Newcome · 05/17/23

Essentially we are taking today's date and subtracting 30 days from it

TODAY(-30)

Then we say if the Due Date is before that, output "30 days". This will keep it calculating so that as more due dates meet the criteria, they are picked up and flagged each day.

Kimbh · 05/17/23

Thanks so much for explaining it.

Paul Newcome · 05/17/23

Happy to help. 👍️

Kimbh · 05/18/23

Is it possible for the formula to get the date from one column then only show the date if it matches a keyword in about column. Like =IF([Form Date]@row < TODAY(-30), "30 days", {Type Range 3}, "Ready")

Thanks

Paul Newcome · 05/18/23

Are you able to provide a screenshot for context?

Kimbh · 05/19/23

First I need to figure out how to make this =IF([Form Date]@row < TODAY(-30), "30 days") over 30 days and less than 90. I can't get that figured out. Nothing I try works. Thank you so much.

Paul Newcome · 05/19/23

You would need an AND statement.

https://help.smartsheet.com/function/and

30 days past due warning

Best Answer

Answers

Help Article Resources

Categories