Clarification regarding Average(collect)?

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?

Find more posts tagged with

Formulas

Accepted answers

bisaacs

Hey @Logan Hubbard,

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

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.