Function for Calculating with Dropdown Boxes

Sheryl Sheldon

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

Calculating Complexity for each Month.docx

Paul Newcome

Try something along the lines of...

=COUNTM([2021]@row) * [Complexity Score]@row

RossL

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)

Sheryl Sheldon

@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

Try something along the lines of...

=COUNTM([2021]@row) * [Complexity Score]@row

Sheryl Sheldon

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

Paul Newcome

Happy to help! 👍️