List function inside IF statement?
I;m trying to create a list using the List function based on if another field is populated or not.
I've tried almost every combination of the List and IF in my calculation and have had no success.
On a related table, I have Field1 - I want to list these values in Field2 in the parent table if Field3 (Also in the parent table = "Yes"
Is this possible? What is the correct combination of these two functions?