If Status = Resolved, can a field be blank, else display a calculated number of days?
I want to track "# Days from Submission, but still Open", and also track "# of Days from Submission to Resolved". Currently the formula I have listed in "# Days from Submission" allows the number to get larger every day, even once the "Status" is "Resolved". Looking for advice on how best to handle this; at a minimum, can the formula in the "# Days from Submission" be edited to say..., "If Status = Resolved, make this field blank, and if not "Resolved" then display the # of Days that have transpired from Submission date? Thanks in advance.
Best Answer
-
Try: =IF(Status@row = "Resolved", "", then insert your formula here
Answers
-
Try: =IF(Status@row = "Resolved", "", then insert your formula here
-
@Nic Larsen - Thanks! Worked great.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!