# How to create formula in a multi-select column that will populate added value when multiple selected

Options

Can someone help me? If I have a multi-selection column and want to have it calculate the total value if more than one is selected what would I need to change in this formula?

I need to provide values to the selections and if multiple selections are made I'd like to have it populate the total value. This column is group in to a final scoring column formula. I was trying to prevent having to add 4 more columns and then add those to the final score formula for 6 different sheets. Thanks!

=IF(LEFT([Business Critical]@row, 1) = "1", 50,

IF(LEFT([Business Critical]@row, 1) = "2", 25,

IF(LEFT([Business Critical]@row, 1) = "3", 30,

IF(LEFT([Business Critical]@row, 1) = "4", 25,

IF(LEFT([Business Critical]@row, 1) = "5", 50, 0)))))

• ✭✭✭✭✭✭
Options

I hope you're well and safe!

Try something like this.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

Hi Andree! Thanks! I tried it and I don't see any error but I also don't see the value populate for this example field I'm testing it on right now. For example selections of 2 & 4 would total to 50 and with that new formula it's just blank.

• ✭✭✭✭✭✭
Options

There was a typo.

Try this.

Did that work?

Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

I'm thinking I may need to try a statement like this:  IF (CONDITION) THEN (OUTPUT) ELSE(OUTPUT)

• Options

Thank you! It worked! I also noticed the typo and had thought I corrected it. I'm a novice so thank you so much!

• ✭✭✭✭✭✭
Options

Excellent!

You're more than welcome!

Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!