Sign in to join the conversation:
Hi,
Is there a way to do an If/Then formula for obtaining a count if a certain word is typed in a cell so that the count automatically adds one for each time the word is entered?
Thank you,
Crystal
Do you mean counting how many times a word is entered into the same cell or how many times a word is entered across a range of cells?
In addition to Paul's question, I have this one: will the cell only contain that one word or does each cell contain a paragraph of words that might contain that one word?
Hi Crystal,
To sum it up!
Can you describe your process in more detail and maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
It would count how many times a word is entered across a range of cells.
The cell would only contain that one word. I have attached an example of what I am hoping to have. So essentially one column would be for the name of the Brands, the other column would be the counts that I am hoping a formula could help pre-populate when one of the brands is entered via a dropdown in the third column.
Just posted a screen shot, let me know if you need more information for this. Thank you all for your help!
Thanks!
Try something like this.
=COUNTIF([Brand Counts]:[Brand Counts]; Brands@row)
The same version but with the below changes for your and others convenience.
=COUNTIF([Brand Counts]:[Brand Counts], Brands@row)
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
Try something along the lines of this...
=COUNTIFS(Brands:Brands, [Brand Counts]@row)
Edit: Changed column names. (I' can't update my original post)
=COUNTIF([Brands]:[Brands]; Brand Counts@row)
=COUNTIF([Brands]:[Brands], Brand Counts@row)
@Andree,
You forgot your square brackets around the [Brand Counts] column name.
@Paul,
Now I can't update the second post either so here it is again.
@Crystal
=COUNTIF(Brands:Brands; [Brand Counts]@row)
=COUNTIF(Brands:Brands, [Brand Counts]@row)
Are you getting blocked again? I haven't had that problem in a while...
Occasionally it happens, and I thought it was because of how soon I changed the post. It's probably set to strict for a community/forum I believe.
I've done updates as soon as the page reloaded after clicking on "Post" with no issue. At least it's not every other post getting blocked like it was a while back. THAT was painful.
Sometimes it works and sometimes it doesn't!
I do not use Smartsheet but am the admin for a company that uses it daily. We had a former employee cancel our company plan when the annual invoice inadvertently charged his credit card. We have since reinstated the plan; however, my colleagues are unable to access, edit, view or otherwise do anything with their data and…
Hello- There's been a few question/discussions on this topic, but they are a but they are older posts. I'm trying to record the email/name and date when travel requests are approved. I'm capturing the approved date with a Record Date Automation, so that it easy, but the approved by field is getting messy. I'm currently…
Hello Smartsheet Community, Our company recently went through a domain/email change, and since then one of our team members has been unable to access her Smartsheet account because the previous email tied to the account is no longer accessible. We have attempted several times to update the account to the new email address,…
