Check box if row becomes a child

Hi All. I am using a salesforce connector with one of my smartsheets. Because of a salesforce filter built into my connector if a Salesforce item is closed it will not flow to the sheet and therefor will error. These errors appear under a parent row. What I would like to do is if a row becomes a child I would like a box to automatically check off. This would then run an automation (which I have built) to move that row to an archive sheet. Currently we have to go in and check all the rows that are children and I would like to automate this. Any help is appreciated.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!