Check box for parent row only

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

Data Science & Reporting Specialist | Information Technology

United HealthCare Services (UHS)

EAP | Mobilizer | Automagician | Superstar | Community Champion

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

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!