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'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
Currently Triggering recurring workflows are only supported at the top of each hour. For instance 10:00, or 11:00, etc. Would like the ability to set 10:30 or 10:45. Perhaps the inteface can stay hourly so it doesnt get huge, but have the ability to manually edit the time directly to any custom time.
I have an automation that has a condition where I am looking at the column "LEA Interco Supporting Site(s)" and trying to find columns that have the value "Fort Loramie" in them. This works well when "Fort Loramie" is the first item listed in the cell, but it doesn't work when "Fort Loramie" is the second or third value in…
