Question on Counting days "If"

Hello,

In my Smartsheet I have a status column that = "RESOLVED" or "IN PROGRESS"

Each row has an "ENTRY" date and sometimes a "RESOLVED" date, if applicable.

If a row is "IN PROGRESS" I want it to count the NETDAYS from today,

but...

If an row is marked "RESOLVED" I would like the NETDAYS function to stop counting.

Ultimately we want to be able to see how many days it takes to resolve a matter. Currently, using the NETDAYS from today, the count continues regardless of whether the matter is "RESOLVED" or "IN PROGRESS."

I am pretty sure there is a nested statement that can accommodate, it's just beyond my skillset.

Thanks,

Donna

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!