automatically mark multiple rows when one row is marked

Chevon Brownell
Chevon Brownell ✭✭✭
edited 12/04/21 in Formulas and Functions

Is there a formula to check all the boxes with the same account number when one is checked?

For example, Account 10-111 has 3 owners. When we receive a vote from anyone of them, we will choose the method the vote was received and check a box under the valid or invalid vote columns. Is there a way to cross out all three owners when we mark just one row? Maybe based on the account number?

Best Answer

  • Mogule
    Mogule ✭✭
    Answer ✓

    By first glance, I'd go with nested IF statements.

    =IF({First Owner Checkbox Reference},1,IF({Second Owner Checkbox Reference},1,IF({Third Owner Checkbox Reference},1,0)))

    It'll check the first owner's checkmark, and if it's True (checked), it'll show the box as 1 (Checked). If it's not checked, it'll check the second owners checkbox, etc.

    You'll need to change the checkbox column in to a text column to set the formula up, then change it back to checkboxes when you're done.

Answers

  • Mogule
    Mogule ✭✭
    Answer ✓

    By first glance, I'd go with nested IF statements.

    =IF({First Owner Checkbox Reference},1,IF({Second Owner Checkbox Reference},1,IF({Third Owner Checkbox Reference},1,0)))

    It'll check the first owner's checkmark, and if it's True (checked), it'll show the box as 1 (Checked). If it's not checked, it'll check the second owners checkbox, etc.

    You'll need to change the checkbox column in to a text column to set the formula up, then change it back to checkboxes when you're done.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!