Formula to get multiple choice form question onto dashboard

Smartsheet Newbie here and I'm having trouble figuring out a formula that works with the multiple choice answers on the form I created. I want to put the answers onto my dashboard in a bar graph and have created a roll up data sheet. I have the single answers questions up there but I can't figure out the multiple answers. I have attached a screen shot but happy to provide any other information. Thank you.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!