Question on Counting days "If"



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,


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.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!