Linking Children to Parents
I need to use SmartSheet as a data collection tool.
The user will have a sheet with Company information including a unique Company ID. I need a way for them to enter Contacts tied to the Companies by the Company ID
I thought about using Forms but, I'm not sure how to pass the Company ID to the Contact Record
I also thought about using DynamicView but same issue, I'm not sure how to pass the Company ID to the Contact record
Maybe using Ancestor with a formula to bring down the Company ID for children?
I'm fresh out of ideas and looking for suggestions