And If formulas with date ranges
Hello, I am reaching out to the community for assistance.
I am trying to do a date range formula.
This following works:
=IF(ISBLANK([74. Discharge date]@row), "No Discharge",
IF([CRM 30 Day Done]@row = 1, "OK",
IF([74. Discharge date]@row > TODAY(+15), "", IF([74. Discharge date]@row < TODAY(+31),
"Past Due"))))
This is where I am trying to get now:
=IF(ISBLANK([74. Discharge date]@row), "No Discharge",
IF([CRM 30 Day Done]@row = 1, "OK",
IF(AND([74. Discharge date]@row > TODAY(+15), IF([74. Discharge date]@row < TODAY(+31)), “”,
IF(And[74. Discharge date]@row > Today(+32), "Past Due", IF([74. Discharge
date]@row < TODAY(+89)), “Past Due”,
“”)))))
Thank you for whoever takes the to share your thoughts!!!!
Answers
-
I am going to need a little clarification.
You list TODAY() with several positive numbers but have past dates in your screenshot. Are you wanting to show how far into the past or how far into the future the discharge dates are? Your screenshot would suggest past, but the formulas suggest future.
In the event the checkbox is not checked, I see results listed for:
Between 15 and 31 days = Past Due
Between 32 and 89 days = Past Due
What should the results be for less than 15 days and for more than 89 days?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives