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).

How do I create an autofill for these cells based on a directory I have created?
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?

Smartsheet Autofill Question.jpg

Find more posts tagged with

Forms

Workspaces

Sheets

Publish

Contacts

Formulas

Dashboards

Importing and Exporting

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

Join distinct collect with contains
Can someone help with this formula? Its not working as-is, but I also would like to use the "contains"/"has" for the leader column as I combined a bunch of contact columns. Here is my attempt to use has - Heres the references (other sheet) Month, all Leads, and R&B prog is the first one (project)
Submitting forms for approval
Any help would be greatly appreciated! We have a 3-step process for travel approvals. I am able to get the forms to the correct people. I now have a request for the ability to add comments during the approval process. Staff submit request via Smartsheet form Automation forwards the form to the manager for approval Once…
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.