Archived 2017 Posts
Archived 2017 Posts
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
