If Status = Resolved, can a field be blank, else display a calculated number of days?

Mary Farmer

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.

Nic Larsen

Try: =IF(Status@row = "Resolved", "", then insert your formula here

Nic Larsen

Try: =IF(Status@row = "Resolved", "", then insert your formula here

Mary Farmer

@Nic Larsen - Thanks! Worked great.