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; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

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

check box formula

Danfenti

I am trying to get a check box to automatically check itself when a range of other check boxes are checked off, I have tried a few formulas with no luck, below is my latest formula

=IF([Sand 1]294:[Sand 1]310 = 1), 1)

Comments

Greg Gates

I think you can get your desired functionality using the COUNTIF function combined with an IF-statement. If you wanted to mark a box if 7 specific checkboxes are all checked, then you might write something like this:

=IF(COUNTIF([Checkbox Column 1]1:[Checkbox Column 1]7,1)=7,1,0)

Basically the formula says:

Count all of the boxes that are checked (equal to 1)
If the count of these boxes is equal to 7 (the number of boxes in my range), then check this current box, otherwise, don't

I hope that works for you!