Average of one column if criteria is met in two other columns

Curious Georgia
edited 07/08/22 in Formulas and Functions

I am trying to get the average number of days an item is open, if it is within a certain region and if the closure date is blank. What would be the best formula to use for this?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!