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.
CountIF where cell contains specific word
I've read a few posts and dicussions but still can't seem to find an answer that I can use.
I'm collecting data and have some basic dashboards setup which display the number specific words are recorded.
As an example:
Clinical Specialist Lead
I need to be able to count how many 'Clinical' roles I have (the number returned should be 3). The key word is Clinical.
I'm looking for some sort of 'where' or 'contains' formula that I use with COUNTIF