MAX and AVG query


Hi, this is linked to a another thread and I am struggling.

Row 1 of my main sheet contains helper fields. On a separate sheet I am developing metrics. I want the metrics to exclude row 1 in its calculations as it's skewing the data. Row 1 contains a Task called D1 - see screenshot.

My metric code is =MAX({Surveys and Works - Runtime}) and then I have similar for AVG.

I have tried using the IF statement based around excluding D1 and/or the date field being blank, but keep getting UNPARSEABLE. I have trawled for a long time on this with no obvious answers. Thanks in advance, Paul 😀

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!