One follow-up question for this function.
This works vert well when getting rows from a table that looks up the value of “Project” from another table as illustrated in this image:
When the Project column is change to a plain text field for the Projects, this no longer works. I can’t find the current value of Project, or selecting the actual value of “Project 1”. Just a string of “Project 1”
What’s the logic behind this? Do I have to have a predefined objekt? Like a tag, or a single lookup value from another table to make it work? Maybe @Connor_McCormick would know?
In addition I’m having an issue with “deleted reference” when trying to use this formula on a CrossDoc table. I’m not sure why, because the values are clearly in the table.
