# Function for Calculating with Dropdown Boxes

✭✭✭✭

Hello -

We have a column that has a checkbox for each year, and another column with a numeric number in it (called Complexity Score (NUMERIC FIELD ONLY) on my screen print). If someone has January, March, April and Sept checked for months in the dropdown column, I need to calculate a the numeric number times how many months are checked. I've attached screen prints for a visual.

Hope this makes sense! Thank you!

Sheryl

Tags:

## Answers

• ✭✭✭✭✭✭
edited 06/18/20

Sheryl,

Are you looking for a count of how many months are selected in the multi select drop down? If so you can use the COUNTM formula. it would be =COUNTM([2021]@row)

• ✭✭✭✭

@RossL Hi - No, what i'm looking to do is a calculation. I need to take the number that is in the Complexity Score (NUMERIC FIELD ONLY) field and multiply it by the number of boxes checked in the 2021 column. So, for example, if the Complexity Score (NUMERIC FIELD ONLY) = 20, and the 2021 column has Jan, April, May, September, November checked, theoretically, it would be Jan = 20, April = 20, May = 20 September = 20 and November = 20, and then I want to add those together. So, Jan20+April20+May20+September20+November20. I need to figure out a formula to have each month checked equal the number in the Complexity Score (NUMERIC FIELD ONLY) column and then add those together to create a yearly total. Hope this makes more sense! Thank you!

• ✭✭✭✭

@Paul Newcome That seems to have worked!! Thank you!!!

• ✭✭✭✭✭✭

Happy to help! 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!