Automatic Cell data input..Formula???

Charmainem3 ✭✭
edited 12/09/19 in Formulas and Functions

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, 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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!