Contact Lists and Formulas

Hello! I am new to spreadsheet formulas so apologies for missing what could potentially be very simple. I am trying to write a formula that will auto select the right contact if a certain number is inputted into another column hence auto-assigning a job.

The formula works for inputing the right name, but only as text. Is there a way to have it select the actual contact too so then that contact is updated that a job is for them?

Formula is (but with using the real names):

=IF(Grade1 = "9", "NAME1", IF(Grade1 = "3", "NAME2", IF(Grade1 = "1", "NAME3", IF(Grade1 = "7", "NAME4", IF(Grade1 = "6", "NAME5", IF(Grade1 = "8", "NAME6"))))))

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!