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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!