Sign in to join the conversation:
Is there a way to get an average of selected cells (all the Children of a column) only if they are not blank? I am stuck and trying to automate the functions as much as possible. Thanks a ton in advance!
Hi Teresa,
Try something like this.
=AVG(COLLECT(CHILDREN(Column@row); CHILDREN(Column@row); NOT(ISBLANK(@cell))))
The same version but with the below changes for your and others convenience.
=AVG(COLLECT(CHILDREN(Column@row), CHILDREN(Column@row), NOT(ISBLANK(@cell))))
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Smartsheet Community - I AM STUMPED!! I am trying to do a crosssheet SUMIFS formula with 1 Column and 2 Rows of Data. I need to sum across {Weeks 1 to 104} Column to match : {Helper Column} = Baseline@row Vertical Rows {Month} needs to match Month@row, and Row {Year} needs to match Year@row I have tried SUMIFS, JOIN,…
Cant figure out why this is not working. It comes back NO MATCH. I have changed it to true and to 1. Nothing works. HELP
I’m hoping to get a second set of eyes from the community in case I’m missing something obvious or there’s a cleaner pattern I should be using. I’ve used ChatGPT to try and help me group/organize my situation coherently…. Because at this point I feel crazy… I’ve literally worked on this for hours. Environment •Smartsheet…
