Help with date calculation formula

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

Hello,

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!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!