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
Best Answer

Try something along the lines of...
=COUNTM([2021]@row) * [Complexity Score]@row
Answers

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!

Try something along the lines of...
=COUNTM([2021]@row) * [Complexity Score]@row

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

Happy to help! 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 200 Industry Talk
 429 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!