If the row is a child row then copy parent row's data, otherwise offer dropdown to user

userdetails

Hi all,

Newbie to smartsheets and trying to find a way where I can eliminate redundant user entries for child rows, and offer dropdown of the newly entered row is a parent row:

thanks for all your help in advance!

Mark.poole

@userdetails The only way to achieve this is through the Use of a helper column. That column will be the actual drop down. "If you are using a form to populate you can keep the helper column hidden.

=IF(COUNT(ANCESTORS()) > 0, PARENT(), [Helper Column]@row)