Need Help with Duration (days)

Options

Hi guys,

I am setting up a dashboard and trying to collect data for it. I would like to show average duration for projects, if possible. For example, I have the columns below. Is it possible to create a formula that will tell me an average length from received to approved? Or do I need to add an actual “Days” column into the data base?

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!