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 am attempted to export to excel. I have two different smartsheet documents to export. One of them exported to excel fine, but not the other. This happened a few weeks ago. I make sure all columns were the correct size & no cells were hidden. "We have found a problem with (file) Do you want us to try and recover as much…
Hello Smartsheet Community, I need some help with a report that I created and shared with a customer. The customer is not seeing any of the information that is pulling into the report. See screen shot below that the customer texted me. I do have the report filter only showing the customer their product pulling from our…
BLUF: When I create an Invoice, I need the cell-link to my live price data to be severed. I currently have a Price sheet for my products that is updated frequently. I use Control Center to create Projects, which includes an Invoice sheet. I have a dropdown on my invoice sheet to select a product, and then I use Index…
