count text occurrence in a check box column

Kelli Lenz

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?  

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