Formula help

Question

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.

Richard Udell · Answer

Hi ​@ArielleLiaa,thank you for contributing to the Lucid Community! I’ve placed your question in our Product Questions space, where other community members and experts can more easily help with formulas.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

Log in to the community