Average formula for text field

Hi I’m new to smartsheet

I am trying to input a formula into the sheet summary field that will average “closed complete” and “closed cancelled” for a column labeled “status”

I was able to count the two fields for both but not average them with the proper formula

thank you

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!