Help with date calculation formula

Nwest ✭✭
edited 08/25/23 in Formulas and Functions


I'm trying to find a formula that will help me calculate how long an intake took to resolve.

The rows I need to be calculated are Date Reported & Resolution Date. If the resolution date is blank I want it to use the current date in the calculation to see how long this issue has gone unresolved.

Any help is much appreciated!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!