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)