Average if multiple criteria

I am looking to see if there is a way to have multiple average ifs to show a visual for the current working project

So IF status = working, and assigned to Group 4, I am looking to show average # of days:

1.) Submitted to triage

2.) Triage to start

3.) Start to Root cause

4.) Root cause to council approval

5.) Council Approval to Pilot

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!