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

मीशो कंपनी में शिकायत कैसे करें:-
मीशो ऐप के माध्यम सेः ऑर्डर डिटेल्स में जाएं: (093 80 22 59 64)अपने ऑर्डर की डिटेल्स में जाएं। "शिकायत दर्ज करें" का विकल्प चुनें: ऑर्डर डिटेल्स में आपको "शिकायत दर्ज करें"मीशो कस्टमर हेल्पलाइन।
Custom Report View
I have a report that is pulling information from a sheet. Is there any way to set this report up so that anyone that views it only sees the rows with their name on it?
I have the Year and Month on a sheet. How can I have the summary look at both to count?
I would like to create a summary if the month is Sept AND the year is 2024 to count. I have found that I can use the and but keep getting an error message This is the Formula I have in the Summary that is coming up #Unparseable =COUNTIFS([Next Renewal Year]:[Next Renewal Year], "2024") AND(([Next Renewal Month]], "Sept")