count text occurrence in a check box column

I have a multi-user sheet. 4 column with to-do tasks. When tasks are complete, the user put their initials in the box.

At the end of the column, I have a formula that adds up the initials and the cell fills in a "YES" for all complete or stays "NO" if not all complete.

At any given time, there could be 75-100 of these individual sheets and have been asked to create a report that just pulls data that will show when the column has been completed. I found that making the column a check box, adding a formula to auto fill a checkbox when the column hits "YES".

The problem I'm having - how do I count the initials (text) that was added into the checkbox column.

Any ideas - suggestions?

Find more posts tagged with

Formulas

Comments

Shaine Greenwood

Hi Kelli,

You might try using a COUNTIF formula for this, e.g.:

=COUNTIF([Column Name]:[Column Name], "YES")

Details on COUNTIF can be found here: https://help.smartsheet.com/function/countif