Calculate Average if another Range meets criteria

Katye Reed
Katye Reed ✭✭✭✭✭
edited 05/11/20 in Formulas and Functions


Any suggestions on the best way to calculate the average days if the item type is equal to quarterly? I have a drop-down menu that categorizes the activities based on frequency, and another column that calculates the days past based on end and start dates.

How could I find the average if the Item type is Quarterly?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!