Auto Filling a cell from data in another samrtsheet

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?

 

Smartsheet Autofill Question.jpg

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!