How do I score out a survey and have it populate in another column?

Hi everyone ,

I am attempting to create a scoring system for a survey based on this type of scoring below.

These are the survey questions and it already built in a sheet.

Thanks in advance for the support.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!