30 days past due warning

Kimbh

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

Try this:

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

Paul Newcome

Try this:

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

Kimbh

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

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

Thanks so much for explaining it.

Paul Newcome

Happy to help. 👍️

Kimbh

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

Are you able to provide a screenshot for context?

Kimbh

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

You would need an AND statement.

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