Automatically populating a cell

edited 02/22/24 in Formulas and Functions

Hi everyone. Some help please.

I've been through index match but I don't think it's what I want. What I want to do is...

  1. Someone submits a form with one of the fields being "sub job", selected from a dropdown.
  2. Once I go into the spreadsheet after the form is submitted, I want the adjacent "WD no" column to be automatically populated.
  3. I want it to be automatically populated from another sheet, based on the "sub job" form entry.


*edited to add photo and extra steps.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!