"not valid row references"

I’m getting the result that I want but get the “not valid row references” error… what’s wrong with my formula?

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.