"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π
Help Article Resources
Categories
Check out the Formula Handbook template!