So I’m in the Column structure and trying to get the Price of plants based on their Plant Size in another table.
I am using this expression in a virtual column in the app formula field:
=ANY(SELECT(Design Numbers for 2018[Price], Design Numbers for 2018[Tray Size] = [_THISROW].[Plant Size (1)]))
It verifies & saves, etc. all good, seemingly.
BUT, it is not showing up in the form or table when I go to fill out the form for this table, entitled Timesheets.
I have already double checked that nothing is hidden or filtered out in the table & form view, the column structure, the table, etc.
The weird thing is that when I go to the Table View and scroll down to look at the columns, it shows up.
But when I go into the form, it does not show, even though I have put no filters on the form and don’t have any slices or anything like that going on.
I have also made sure that the table I am referencing doesn’t have any hidden stuff going on, or filters/security issues, etc.
Running out of theories…anyone have any ideas?
Starting to think that maybe something weird is happening with the expression?
I’m not sure.