I’m trying to create a badge that shows the number of times the shape’s text occurs throughout the page. The shape text is coming from column A of a linked data set.
This is what I’m trying to use: =COUNTIF(CHILDREN(PAGE)."A",THIS."A")
But it just returns a 0. If I type out the shape’s text long-hand like this I get the count I want: =COUNTIF(CHILDREN(PAGE)."A",THIS="Exact text of column A")
How can I get it to count for me without typing long-hand values for every shape?
Try this formula: =COUNTIF(CHILDREN(PAGE).”A”, x => x=THIS.”A”)
The CHILDREN(PAGE).”A” gives an array. The second half of the function evaluates the condition for each value in the array, and the x=> defines the current value we are checking as x so we can compare it.
Hi
A Lucid account is required to interact with the community. You will be redirected to the Lucid app to create an account.
A Lucid account is required to interact with the community. You will be redirected to the Lucid app to log in.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
