Average duration for a specific type

Options

I am trying to calculate the average time (based on #2) per request type (i.e multiple request types and trying to get the average per type in my Request Metrics form)

Columns:

  1. Request Type
  2. Actual Days to Completion (this is calculated via formula of date ending - date initiated)

I am not really sure where to start with this formula but any advice would be greatly appreciated.

Best,

Jodi

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!