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.
Help Article Resources
Check out the Formula Handbook template!