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?
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?
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!
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
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!
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)
You forgot your square brackets around the [Brand Counts] column name.
Now I can't update the second post either so here it is again.
=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've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.