Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

count text occurrence in a check box column

Kelli Lenz
edited 12/09/19 in Archived 2017 Posts

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?  



This discussion has been closed.