# If Then Formulas

Options
✭✭✭✭
edited 12/09/19

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

«1

• ✭✭✭✭✭✭
Options

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?

• ✭✭✭✭✭✭
Options

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?

• ✭✭✭✭✭✭
Options

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

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭
Options

It would count how many times a word is entered across a range of cells.

• ✭✭✭✭
Options

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.

• ✭✭✭✭
Options

Just posted a screen shot, let me know if you need more information for this. Thank you all for your help!

• ✭✭✭✭✭✭
Options

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?

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭
Options

Try something along the lines of this...

=COUNTIFS(Brands:Brands, [Brand Counts]@row)

• ✭✭✭✭✭✭
Options

Edit: Changed column names. (I' can't update my original post)

=COUNTIF([Brands]:[Brands]; Brand Counts@row)

The same version but with the below changes for your and others convenience.

=COUNTIF([Brands]:[Brands], Brand Counts@row)

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭
Options

You forgot your square brackets around the [Brand Counts] column name.

• ✭✭✭✭✭✭
Options

Thanks!

Now I can't update the second post either so here it is again.

@Crystal

Try something like this.

=COUNTIF(Brands:Brands; [Brand Counts]@row)

The same version but with the below changes for your and others convenience.

=COUNTIF(Brands:Brands, [Brand Counts]@row)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭
Options

Are you getting blocked again? I haven't had that problem in a while...

• ✭✭✭✭✭✭
Options

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.

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭
Options

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.

• ✭✭✭✭✭✭
Options

Sometimes it works and sometimes it doesn't!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.