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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!