Check box if row becomes a child

Christopher Pretty

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.

Paul Newcome

Try something like this as a column formula:

=IF(COUNT(ANCESTORS()) <> 0, 1)

Paul Newcome

Try something like this as a column formula:

=IF(COUNT(ANCESTORS()) <> 0, 1)

Christopher Pretty

https://community.smartsheet.com/discussion/comment/342610#Comment_342610

Thank you that worked!

Paul Newcome

Happy to help. 👍️