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
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?
Comments
-
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
