I have this formula in my spreadsheet but I w...

[Ellen_Sligh1]

I have this formula in my spreadsheet but I want to put it in appsheet instead.

Appsheet is not recognizing it.

What is the appsheet translation of it? =COUNTIF(Notes!$I2:$I,“text”)

[Aleksi_Alkio]

Try COUNT(SELECT(Notes[ColumnName],[ColumnName]=“text”))

[Ellen_Sligh1]

Tried this - it’s not counting and showing any totals like the spreadsheet query did

[Aleksi_Alkio]

It should do that. Are you searching the string “text” or something else? May I see the formula you tried?

[Ellen_Sligh1]

So here is an image of an example of what I want done - to make a chart

bar graph show how many times particular words occur in a column.

Notes is the spreadsheet table and Impact is the name of the column =COUNT(SELECT(Notes[Impact],[Impact]=“Global Mindedness”))

drive.google.com - Screenshot 2018-05-20 16.04.34.png

Screenshot 2018-05-20 16.04.34.png drive.google.com

[Aleksi_Alkio]

Have you tried to use virtual column for this calculation?

[Ellen_Sligh1]

okay - I feel quite silly - I figured out the chart view can do the COUNT… for what I wanted - I’m learning.

[Aleksi_Alkio]