Auto Fill Fields in Sheet



I have 2 columns I am looking to auto populate based on what is selected in another column.

Depending on the requestors name the Manager and Director will populate. The thing I am having trouble with is that multiple requestors are under a manager. I cant get my IF statement to work.


Lisa, Doug, and Frank are all under Michael as the Manager.

I can get =if Requestor is Lisa then add Michael to the column, but I cant get multiple selections... Also, all fields are Contacts.

The purpose is to be able to remove those two fields from the form.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!