Kenny T.
Kenny T. ✭✭
edited 03/31/23 in Formulas and Functions

Hi all,

Looking for some help on a formula that I keep getting an error.

I am looking to populate the average % into a breakout summary sheet by referencing multiple columns from the master sheet, but only if the Master QTR column contains a specific quarter (i.e. Q1).

I was able to figure out how to populate the average using =IFERROR(AVG({Front End}), "Compliant"), but cannot figure out how to add the QTR portion in without getting #unparseable.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!