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!

Automated Checkbox column

epollard

Hello - I am trying to make my checkbox column automated so that when the PARENT rows is checked all the CHILD rows get checked. I can only find help on the reverse. Can someone help me write that formula?

Thank you

Erin

Find more posts tagged with

Formulas

Comments

Paul Newcome

=IF(PARENT() = 1, 1)

This should do it for you.

epollard

Worked like a charm! thank you!

Paul Newcome

Sure thing.

Sign in to join the conversation!

Quick Links

Trending discussions

Update Assigned Person only for active phases
Hi, I’m using Smartsheet with a Master Sheet(All over Projects Basic Summary) and Individual project sheets that have multiple phases. When I change the Assigned Person in the Master Sheet, I want: •It to update only phases that are Not Started or In Progress •It should not change phases that are Completed Is this…
Creating Project Planning Sheets from a Template, Linking to Master Sheet
I created a master sheet that will list all projects for a department. We will also have a planning sheet for each project in the master sheet, created by copying one of four templates (based on the project type). Each of the four templates will have columns set up and a hierarchy of rows based on phases, workstreams,…
Formula that looks at multiple sheets
I need assistance with creating a calculation. I have a list of people on one sheet that has their names and rate of pay. The person fills in a form and enters their hours (form is the Contractor Pay Summary sheet). I need the one sheet to look at the other and pull in the rate of pay for each user. Contractor Sheet This…