IF statement with child/parent logic
I need to have autonumber as a Unique Identifier for each row. When that row changes due to changing business requirements, I want to create a child row but it should not have a different Unique ID from the parent. It could either have the same Unique ID or no Unique ID, but if I have autonumber turned on then Smartsheet automatically numbers every single row separately.
1. Use autonumber, which creates a Unique ID for every row (even child rows)
2. Create a calculation column to reference the autonumber column. I need help writing the formula for the logic "if row is a child row, then calculation field equals the Unique ID of the parent row. If not, then calculation field equals the Unique ID."
In the attached screenshot, it would be something like "IF((row = child), [Campaign ID]5=Parent([Campaign identifier]),[Campaign ID]5=[Campaign identifier]5)"
Help Article Resources
Check out the Formula Handbook template!