adding an unmarked check box only if its a grandchild row

NikkiOno

i need to add checkboxes to the grandchildren rows. how can i do this without making it look so messy? i created a workaround with helper column but it looks messy and its time consuming.

Kelly Moore

Hey @NikkiOno

Looking at your data, do you also want the parent rows and the grandparents to include a 'na'?

You will no longer need the 'yes' column. This formula can be converted into a column formula (if unfamiliar, after entering the formula into the checkbox column, right click on that cell and scroll down the list to choose 'convert to column formula')

In the checkbox column add this formula. Be sure to edit and insert the real name of your primary column.

=IF([whatever your primary column is called]@row<>"", IF(COUNT(ANCESTORS())=2, 1, IF(COUNT(ANCESTORS())<2, "na")))

Will this work for you?

Kelly

If you are unfamiliar with column formulas, you may be interested in this post

https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas

NikkiOno

@Kelly Moore thanks so much!