Formula to capture a total amount of items in a cell.

I am looking for a formula that will give me the total number of items listed under benefits for a project.

For example, =COUNTM([Project A]:[Project A], Benefits:Benefits])

We currently have 17 benefits that can be selected in each project. I this particular project, only 2 benefits apply.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!