Multiple IF statements/Managing large formula.
Hello Smartsheets Community,
I was curious if anyone had some input. I've developed a sheet that runs different formulas for different "vendors" in a column to get a final price based on the vendors data. It's become a very large IF statement as there's many vendors now (if vendor is Vendor 1, *do this* etc). I'd like to make an easier way to add vendors into this formula as we get new ones throughout the year. Is it at all possible to say, have a sheet that I could enter the vendors and data into, and "match" a formula onto another sheet instead of using a long formula? For example, instead of writing a formula for each vendor in one large formula, be able to call on a different formula for each vendor in another way? Hopefully that makes sense, looking to make it easier for other team members to add vendors into the formula. May or may not be possible.
Thanks for any thoughts!
Help Article Resources
Check out the Formula Handbook template!