30 days past due warning
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
Best Answer
-
Try this:
=IF([Due Date]@row< TODAY(-30), "30 days")
Answers
-
Try this:
=IF([Due Date]@row< TODAY(-30), "30 days")
-
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
-
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.
-
Thanks so much for explaining it.
-
Happy to help. 👍️
-
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
-
Are you able to provide a screenshot for context?
-
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.
-
You would need an AND statement.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!