I am trying to create a formula that will count the amount of times a word is mentioned. For example I have containers on my sheet that contain words. In a summary box I want to count the amount of times the word “America” appears.
Question
Formula help
+8Hi
I’m not sure exactly how your setup looks, but here are a couple of ideas: If you’re using data linking, you could try a COUNTIF formula. If you’re working with shapes and text on the canvas, you could use COUNT(FILTER(array, expresson). The FILTER formula can be tricky to use, so here’s our documentation for more guidance: https://developer.lucid.co/docs/filter.
Let me know if you have any specific questions and feel free to share screenshots of your work.
Create an account in the community
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
Log in to the community
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
Log in with Lucid
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
