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.

How to count a text in a column?

Ben
Ben
edited 05/24/17 in Archived 2017 Posts

Hey there,

I'm trying to count a specific initials in a column with multi initials in each cell, but it doesn't work.

Please check out the image.

Is that a limitation?

Thanks.

count.png

count1.png

count2.png

count3.png

count.png

count1.png

count2.png

count3.png

count.png

count1.png

count2.png

count3.png

count.png

count1.png

count2.png

count3.png

Comments

  • I think you might be right that there is no direct way of doing it, I've attached a possible workaround though, using the Find feature to effectively get value to count from.  Hope this helps

     

    smarttest.png

  • Hi Tony,

    Thank you for the replay, but unfortunately it won't work for what I need.

    I'm building a schedule calendar for my team, I have 5 columns: Week day name,  Date, Morning, Day and Night. In each shift there are more than 2 people (in each cell). See the picture.

    I need to count each individual person, how many shifts he had in the Morning, Day and Night on different periods (week, month).

     

    2017-05-25_135322.png

This discussion has been closed.