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
 10.5K Get Help
 61 Global Discussions
 46 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!