Is there an appsheet expression to join a tex...

(Ellen Sligh) #1

Is there an appsheet expression to join a text with a count

In google sheets I have the formula: =G2&":"& countif($G$2:G,$G$2)

Can that translate into an app expression?

(Levent KULAÇOĞLU) #2

@Ellen_Sligh1 =CONCATENATE([ColumnName],":",COUNT(SELECT(TableName[ColumnName],{Yes/No})))

(Ellen Sligh) #3

nice try - no luck

(Levent KULAÇOĞLU) #4

@Ellen_Sligh1 I’m not aware about your sheet, your sheet structure and even your data. I’m also not aware what you want to concatenate and what’s that COUNTIF sheet formula is all about. The sheet formula that you have typed is transcribed as per AppSheet expression and it’s correct in structure. There is no COUNTIF function in AppSheet and you have to simulate it with a COUNT(SELECT(…)) expression.

So; if it’s not working just check your SELECT expression’s conditional sentence ({Yes/No} part at the end or elaborate your query.

(Levent KULAÇOĞLU) #5


Or you can try one of these: =CONCATENATE([ColumnName],":",TEXT(COUNT(SELECT(TableName[ColumnName],{Yes/No}))))


(Ellen Sligh) #6

Great - will do

Its about counting a specific text and how many times it occurs in a column - then in another column I wanted to join the word being counted with the sum total of the count such as :

Blue:1 or Red:4.

(Levent KULAÇOĞLU) #7


Are these words solely “Blue” or “Red”? OR are they inside a sentence i.e. “This is a blue color”? I’m asking this because it matters for the True/False conditional statement for counting them.

(Ellen Sligh) #8

the column has 1 word per cell