Days to Launch, stop at Zero

I have created a formula to countdown the days to launch and converted it to a Column forumula so it is automatic for any project. However, we don't need to know the negative numbers or day past launch in this column. I tried nesting an IF function to return a blank cell for anything less than zero but I the dreaded unparseable error. What am I missing?
=[Go Live/Close Date]@row - TODAY(), IF([Days to Go Live]@row, <0, "")
Answers
-
Hey @Tina Rustvold
Here's one approach to your problem
=IF([Go Live/Close Date]@row>=TODAY(), [Go Live/Close Date]@row - TODAY())
This checks to see if Go Live Date is greater than today's date. If yes, the calculation occurs. If not, a blank will be returned.
Is the Status ever 'Closed' when the Go Live date is still in the future? If yes, you could instead use Status not equaling Closed to drive the calculation: =IF(Status@row<>"Closed", [Go Live/Close Date]@row - TODAY())
cheers
-
Thanks for that suggestion Kelly; that might actually work better. However, we have Done checkbox that would be the most reliable criteria so I tried the following and got an Incorrect Arguement Set--closer than Unparseable but not sure what the system doesn't like about it.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!