"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
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 445 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!