Auto Filling a cell from data in another samrtsheet

fermingoitia76486

Good afternoon

I am creating a bid invitation sheet and need to list GC bidders per each job (row).

1. How do I create an autofill for these cells based on a directory I have created?
2. and once the GC is selected in this cell how do I autofill the column next to it with one of their many estimators at their company that is in the directory we have created?

 

Andrée Starå

Hi,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting