Automatic Cell data input..Formula???
I am polling permission via web form from 150 of our top accounts. The web form will only collect client info they would know, such as their name, account name, email, contact # and yes or no for permission. However, on our end, when that entry comes in, I need other internal info to auto populate based off the "Account name" entry. Example: If Dell says yes, "Dell" and its client info will fill the sheet. I'd like for SS to populate the rest of the row with the associated or "tied" Manger name, business unit, manger email, etc..info we would have. Whats the best way to set that?Keep in mind this is for 150 possible account values and their associated account manager names and info. Can this be done? Is it a particular formula function? Do I need a separate data sheet with the values and tie via sheet cross referencing? Please help!
Help Article Resources
Check out the Formula Handbook template!