nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

¿Automatically sum up child values into Parent Cell?

mgahumada

I'm looking for a solution to automatically sum up child values for selected numeric columns.

There is a workaround that is to use sum(children()) formula, but I dont want to write the formula every time I add Parent rows.

Any ideas?

Thank you.

Comments

Shaine Greenwood

Hello,

There isn't a way to have child cells summed in the parent row without placing that formula in the parent cell.

To make it easier though, you might try either copying and pasting the formula (Ctrl + C to copy and Ctrl + V to paste), or select your parent cell and click the Sum button in the toolbar on the left. Since the Sum button is contextually aware, it'll place a SUM(CHILDREN()) formula in any selected parent row. More on the sum button here: https://help.smartsheet.com/articles/2476171-create-and-edit-formulas-in-smartsheet