Project Based Master Contacts Sheet

Andrea Westrich

Is it possible to create a single master contractor sheet that is simple: Company name, contact, email, phone, etc. and then have that sheet feed into other sheets that use a form that has a drop-down for the contractor section? These are sheets are separate because they are used for tracking different things like warranty items or punch list items, but I'd like to have a single location for contractors.

I know this can be done from sheet to sheet, but can this be done when a form is used without having to update all the contacts in each separate sheet?

What I'm trying to do is avoid having different contact lists for things like a punch list sheet and a warranty item sheet, but the key is that my on-site team uses a form to assign items and it's a drop-down field.

Is this possible?

adp_cl

To my knowledge, you cannot have a dropdown column's options based dynamically on another sheet without Data Shuttle.