Count Selected Options in Multiple Choice Column

General
1

Is there a way to count the number of selected options in a multiple-choice column and have that number generated in a new column?

For Example, column 1’s data type is multiple-choice and column 2’s data type is integer and is a generated column. Using a formula for column 2, is it possible to calculate the number of selected options in column 1.

2

Hello @Addae_N,

You can calculate the number of selected options in column1 using this formula for column2:

LENGTH(column1) - LENGTH(REPLACE(column1, ',', '')) + 1

Regards,
Olha