Check box for parent row only

Options

I have a sheet where there is a helper column that says either Parent or Child. If the helper states "Parent", I want the checkbox in a column named "Report" to be checked. Otherwise (if the Helper states "Child") I want the checkbox in the "Report" column to be unchecked.

Can this be done with a formula or conditional formatting?

Sherry Fox

Business System Data Analyst

Del-Air Heating, Air Conditioning, Plumbing and Electrical

EAP | Mobilizer | Automagician | Superstar | Community Champion

https://www.linkedin.com/in/sherryfox/

Best Answer

Answers

  • JamesB
    JamesB ✭✭✭✭✭✭
    Answer ✓
    Options

    @Sherry Fox

    This can be done with a formula or Automation.

    Formula:

    if(Helper@row="Parent",1,0)

    Automation:

    When Helper Column changes to Parent set Report cell to checked.

  • Sherry Fox
    Sherry Fox ✭✭✭✭✭✭
    Options

    @JamesB ,

    Thanks, that worked perfectly!

    Sherry Fox

    Business System Data Analyst

    Del-Air Heating, Air Conditioning, Plumbing and Electrical

    EAP | Mobilizer | Automagician | Superstar | Community Champion

    https://www.linkedin.com/in/sherryfox/

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!