Hi,
I’m using a lookup field which aggregates a list of single selects (containing values like : “Yes”, “No”).
Within the lookup fields, I’m using the formula : ARRAYJOIN(values)
It works great. Then I have a formula field with a FIND() :
FIND("Yes",...
I got it, I did that and it works perfectly. Thank you! Though interested if there’s a better way to do it!
LEN(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
{Support ...
Hi Justin. Thanks so much for this and your quick reply. I fixed the topic of my post, yes, I had meant Rollup instead of Lookup.
What I don’t understand is why I have to go substract the other words instead if just counting the values I am intereste...
