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

(Ellen Sligh) #1

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) #2

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

(Ellen Sligh) #3

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

(Aleksi Alkio) #4

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

(Ellen Sligh) #5

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) #6

Have you tried to use virtual column for this calculation?

(Ellen Sligh) #7

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

(Aleksi Alkio) #8