How do I write a formula to return a category based on the item(s) in a cell?

In this example, the first column contains various fruits and vegetables (multi select dropdown). I want to write a formula that returns the category (fruits or vegetables) based on the first item




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!