Hi!
I’m getting the result that I want but get the “not valid row references” error… what’s wrong with my formula?
Thanks!!
Hey there! That’s because your column type is a lookup.
Lookup column types contain row-reference values.
Your filter formula returns row references, but at the end of your filter formula you chained on a green “ready to activate” chip which turns what would have been a list of row references into a list of text references
So if you want text references, just change your column type to text
If you want row references, delete the green “ready to activate” chip
Thank you, Scott! I’m just starting with Coda, you helped me understand it better!!
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.