Average Formula Issue

Welcome to the New Smartsheet Online Community

You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

Average Formula Issue

Hi there, i am trying to average cells that were built up by formulas.

So basically the Column 1-7 are the scores when the task is done , it will turns into 100 when the task is complete, and where the right handside column would need to average the score of column 1-7.

When I tried to average , it turns out "UNPARSEABLE" ; Below is the formula I tried to create.

(I also tried Average ISERROR, if also didn't work)


Sign In or Register to comment.