Cross Sheet Formulas For Children Rows

Nina_Micha

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.

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