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โ)
Try COUNT(SELECT(Notes[ColumnName],[ColumnName]=โtextโ))
Tried this - itโs not counting and showing any totals like the spreadsheet query did
It should do that. Are you searching the string โtextโ or something else? May I see the formula you tried?
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
Have you tried to use virtual column for this calculation?
okay - I feel quite silly - I figured out the chart view can do the COUNTโฆ for what I wanted - Iโm learning.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |