Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Embed hierarchy function as the range within the COLLECTION function

Diaz

Diaz ✭

09/14/17 in Archived 2017 Posts

I amy trying to execute the following function. Does anyone know if it, or something like it, is possible:

= AVG(COLLECT(CHILDREN(), CHILDREN(), ISNUMBER()))

Tags:

Formulas

0 ·

Comments

SmSulli ✭

09/15/17

Diaz,

I believe if you throw an @cell in the ISNUMBER function, you'll be good to go.

= AVG(COLLECT(CHILDREN(), CHILDREN(), ISNUMBER(@cell)))

Shawn

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Date format Formula
Hi All My Date column is formatted to YY/MM/DD - 2024-11-08 I have a week-ending column with the following formula. Returning the End day of the week that the Date column falls into =IF(OR(ISBLANK([Date]@row), [Date]@row = "N/A"), "", "WE- " + ([Date]@row + (6 - WEEKDAY([Date]@row)))) BUT the return looks like this WE-…
No Match...but the formula works
Can someone help me with this? I have a formula which works but it's finding NO MATCH for two lines but I don't know why as the formula has no problem finding a different line on the same sheet… This is the formula: =IFERROR(IFERROR(IFERROR(INDEX({IQA Log Record Closed?}, MATCH([Primary Column - IQA Ref]@row, {IQA Log IQA…
How Do I Illustrate Checklist Data in a Dashboard?
I am making a dashboard widget to show how many items in the implemented mitigations column are checked and how many are not. I understand that I may need to make a report or a sheet summary to do so first. How can I make this happen? Also, at some point, I'd like to show a relation to, if it is implemented, is the…