Formula to close or open all children rows?

Autumn Bennett

Autumn Bennett ✭✭✭

04/13/23 edited 04/13/23 in Formulas and Functions

Is there a formula or something where you can easily click something in a cell to close all parent/children relationships and the something to open them all?

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

04/13/23

You could use the + or - in the Primary column.

Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Child Row Formula to Reference Parent Row
Hello! I'm trying to figure out a formula that will always reference the Parent Row. I need all the cells in the Practice Name column to reference the parent row above it. I'm assuming I can't make this a column formula, otherwise the parent row I need to reference will be referencing the parent row above that. So for…
Using IF(AND Formula
Hello - I am trying to capture a few different scenarios to determine if part of project should be worked on (Go/No Go column) based on Benefit Level and Effort Level columns: I tried one of the scenarios as a starting point a few different ways but got an Unparseable error =IFS(AND([Benefit Level: High or Low]@row=High,…
Multiple Criteria Formula - Metric Sheet
I am looking for a formula to calculate the number of APPROVED projects with Technology Impact. I am able to get the number of all projects with technology impact, but cannot figure out the second part of the formula to only include APPROVED projects. Current formula which includes information from the Technology Impacted…