True or False formula + Graphics

Dear Friends,

I’m new on AppSheet and it’ll be amazing if there is someone who can help me with the following scenario.

I have a google sheet with a list of shops and their products. I added a virtual column with the following formula OR(CONTAINS([Product],“Coca-Cola”),(Contains ([Product], “Coke”))) to tell me how many shops contains the following text.

Now, I want to create a graphic showing me the total number of shops that contains the text above vs how many doesn’t, for example, I have a total of 100 shops and 80 shops have the product and 20 shops don’t have.

Does anyone know the best way to do that?


One tool I heavily use is

Pass any texts from your fields which will generate the placeholder/icon/graphics either way you call in a dynamic way.

1 Like