Clarification regarding Average(collect)?

Logan Hubbard

I'm trying to calculate the average lifespan for a specific machine in a specific area, but am running into an issue with my average(collect) formula.

Here's the formula I have right now, and it only returns as unparseable.
=AVERAGE(COLLECT({Lifespan},{Machine},"1",{Row},"1",{Position},"1"))

In this instance, its to average the lifespan data of Machine 1, Row 1, Position 1. Theres 191 other unique positions I'll need this for as well.
I've double checked the syntax and from what I can see it looks good, any clue where I've gone wrong?

bisaacs

Hey @Logan Hubbard,

The average function in Smartsheet is spelled AVG, rather than spelled out. Does that fix the issue?

bisaacs

Hey @Logan Hubbard,

The average function in Smartsheet is spelled AVG, rather than spelled out. Does that fix the issue?

Logan Hubbard

https://community.smartsheet.com/discussion/comment/436348#Comment_436348

I've spent so much time with AVERAGEIF this morning that I must've gotten the syntax mixed up, thank you for the help!