Sign in to join the conversation:
I want to count multiple values from a cells which are separated by ";" from a column.
Can it be achieved by COLLECT/FIND/COUNTIF ?
The following screen shots has the Info & expected output .
Any suggestions please.
The best way to do this would be to change your Country column into a multi-select column. This allows Smartsheet to read each country as an individual value, even when in the same cell. Then you can use a COUNTIF(HAS formula, like so:
=COUNTIF(Country:Country, HAS(@cell, [By Country]@row))
If your Country column is in another sheet, replace the Country:Country column reference with the sheet reference in curly brackets {like this}. Please see a screen capture below of an example from one of my sheets, using a multi-select drop-down column type.
Thank you Genevieve Penny It worked
Great! Glad to hear it.
Is there a way to copy a row into multi sheets without doing it manually? Be able to choose sheets and copy a row of data into new sheets. We have construction schedules build and want to add new tasks to sheets
I have an active automated notification in a sheet of project tasks that lets the "assigned to" know when anything has changed in their row. However, they don't need to know about changes they made themselves so I am trying to eliminate those. I set up a column called "MATCH" and added a formula to check for a match…
Hi, I have a dropdown column in a sheet. The column contains 98 separate dropdown values. I've noticed that one of the values (the longest one) doesn't show in the list when trying to filter using the "is one of" or "is not one of" options. All other 97 dropdown values display. This is the name of the value that doesn't…
