Nested IF to populate Cell



I have a nested If formula I am having trouble with,

=IF(Category@row = "Drink", "Lemonade, Tea, Water, Soft Drink", =IF(Category@row = "Toping", "Pepperoni,Steak,Chicken", IF(Category@row = "Fries", "Cheese, Chili")))

I have a drop in the Category column. If I choose the "Drink" option is is working fine, but if I choose "Toping" or "Fries" I am getting #Invalid Operation error. I made sure the spelling and format matches.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!