Hello hello - help with function

ilyas star

this function

show all the unique names in one cell =JOIN(DISTINCT(Categories:Categories), " - ")

Please i want show the data in different cells

thanks

ilyas

Paul Newcome

Here is a link that contains some information as well as a published solution for parsing data out from a text string.

https://community.smartsheet.com/discussion/comment/273631#Comment_273631

ilyas star

Paul i mean

iMEAN to get the data like this not all in one cell

Paul Newcome

Right. You have to pull the string into one cell and then use one of the Parsing solutions detailed here in the community. My above post links to one of them.

ilyas star

Pail thanks

used the countif but cant get it

can you send the formula

thansk

ilyas

Paul Newcome

Are you struggling with the parsing solution or the COUNTIFS? The COUNTIFS is applied after the data has been parsed.

ilyas star

https://app.smartsheet.com/sheets/mx7hVR2V34QpPRCJjJ2PwCQ5xGfWJMXqw8MCQQc1

the sheet like

i want all unique task names

thanks

Paul Newcome

Referencing THIS SHEET...

First you will create the three columns on the right of the sheet (List/Comma/String).

Then you would use the three columns on the left to determine which formula goes into which cell and whether or not it is dragfilled (or possibly manually entered data).

Your existing JOIN/DISTINCT formula would go in the String1 cell, then the rest of the formulas would apply as is with the exception of the delimiter. You will want to use a matching delimiter. So if you have "-" as your delimiter in your JOIN formula, you will want to change the delimiter references in the other formulas to "-", or if you wanted to be able to copy/paste the other formulas, you will need to change the delimiter in your JOIN formula to a comma ",".