"date created" and use "date closed" to see how many days the case was open?

FGCC Smartsheet

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!

Paul Newcome

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

FGCC Smartsheet

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?

Paul Newcome

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.

FGCC Smartsheet

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?

Paul Newcome

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.

FGCC Smartsheet

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😂

Paul Newcome

Happy to help. 👍️