Formula to add 30 days to "Date notified" AND countdown the days until that Date notified + 30 days
I was able to set a formula to add 30 days to Date notified:
=[Date notified]@row + 30
Then set another formula to count down the days from the Date notified + 30 days:
=IF([Date notified + 30 days]@row < TODAY(), "", NETDAYS(TODAY(), [Date notified + 30 days]@row))
The 2nd formula I have also results in a blank result once the Date notified + 30 days has passed.
How can I combine the formulas to 1 formula so that I could get rid of the "Date notified + 30 days" column and only have the countdown of 30 days from the Date notified?
In another formula, how can I change the countdown formula to include negative days if we are past the countdown but the date hasn't been closed yet? But also for it to give a blank result once it's closed?
Below is an example with random dates:
Answers
-
@vivian123 I believe this will do what you want.
=IF(NOT(ISDATE([Date Closed]@row)), [Date Notified]@row + 30 - TODAY(), " ")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!