I have a Virtual Column with an app formula of that finds the MAX value of a column by the user. I want to pull this value into another table. How?
My current approach (which has not been working) was creating a reference column to the referenced table (with the Virtual Column Calc). Then I had a Column with the app formula [Reference Table Key].[Virtual Column Name] and the value comes back as nothing.