Thanks. I think I get the syntax, and have it written properly - something else must be off. Here’s a more detailed breakdown, maybe you can spot something: The Parent table is “Cleanse Records” and the related records are in a virtual column called “Related Tasks”. That refers to a table called “Tasks” that has a column named “STATUS”, the values of which are “COMPLETE” or “INCOMPLETE”.
In the Status column of Cleanse Records (parent table) I have this formula:
IF(IN("COMPLETE",[Test: Related Tasks][STATUS]),“Yes”,“No”)
The Expression Assistant validates this, so references are correct. That Status column’s TYPE is set as “Text”, and by default it is blank.
I also tested it another way, with a virtual column named “Test: Related Tasks” which is [Related Tasks][STATUS], and then used this formula instead of the above:
IF(IN("COMPLETE",[Test: Related Tasks]),“Yes”,“No”)
In both cases the parent table Status column with the formula remains blank. What might I be missing? Does the Status column TYPE need to be something else?
Again, appreciate your help!