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.
Hello, I have a report that summarizes all hours spent on a particular phase. Is there any way to include the missing information? I need to create a condensed report to add to a dashboard. Missing information: Site Name, Turbine Number, Blade Number, Date Performed, & Current Phase
How do I link a sheet in one workspace to another workspace?
If i disable a user from User Admin, does it retain any items they own? Including any Premium App workflows like Data Shuttle, Mesh, Pivot and JIRA Connector?
