Cross Sheet Formulas For Children Rows

Hello. I´ve spent all day trying to look for how to do this, I found some info but wasn´t exactly what I needed, plus, I´m new using smartsheet.

What I need is to bring info from another sheet, but only what is inside a children row. I have a budget sheet with several ancestor, parent and children rows; I need to use perhaps "sumif" formula to bring info from a specific children in another sheet. I hope my explanation was clear enough.

Find more posts tagged with

Sheets

Comments

Andrée Starå

Hi Nina,

Unfortunately, it's not possible at the moment to reference children in a cross-sheet formula, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

There might be another solution/workaround.

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Sign in to join the conversation!

Quick Links

Trending discussions

Unable to find team members in search function to share a sheet with
I am trying to share a Sheet, can't find some people in the search function. Why not?
Permissions not updating
I was given editing permissions this morning but when I open the sheet it still says I am View Only.
indent for entire cell
Hi I'm trying to make indent for 78 groups, is there a way to make it in one click or I need to do it one by one. see image below, e.g., I want contioue up to B-78, and that takes a lot f time. Any suggestion?