"date created" and use "date closed" to see how many days the case was open?
Hellow
I'm asking for help with a Smartsheet's formula. I want to take "date created" and use "date closed" to see how many days a case is open. How do I write the formula for that? I'm placing this formula in a calc sheet thats pulling data from the data sheet. I appreciate any assistance you can provide.
Have a great day!
Answers

Are you trying to get a grand total of all rows combined?

I have thousands of cases, and I want to know the average time it takes to close a case. Does that help you understand my objective better?

You will need to calculate this on a row by row basis in the source sheet and then reference this calculation column in your metrics sheet.

I need to learn formulas. It will be two formulas, one row by row down the spreadsheet doing the calculation for each row and placing that in a column. Another to average the sum of that column? Where do I begin?

That is correct.
The column formula on each row would be a basic cell minus cell assuming you have date formats for both date columns.
=[End Date]@row  [Start Date]@row
The second would be a standard AVG function on the entire column.

I really appreciate your guidance. Thank you so much. Hopefully I'll get this. I'm new to SmartSheets. I've spent the last few years in PowerApps. LOL😂

Happy to help. 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!