Trying to do a group IF statment

edited 12/09/19 in Formulas and Functions

Not sure how to ask this but I am trying to set up a tracking sheet that will automatically pull info from a master sheet.  I would like to send out a form from for someone to fill out and all they would need to do is put in the job # into the form, and on the track sheet it will automatically fill in the rest of the project info from the master projects sheet; Names, address, phone numbers etc.  There could be hundreds of job number and address, so I am trying to find the best way to do this.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!