Hello,
I have a combo box that is populated with a list of job numbers from another table. When I setup the lookup for those values I pass a job status (Open or closed). I'm trying to filter the combo box to only show choices where status = "Open"
Filter(Choices('Project table'.'Project:Name'), 'Project:Status Pass' = "Open")
I'm getting an invalid arguments error on the Status Pass = "Open"
I've tried putting "1" or 1 in to see if it was passing the ID.
Pretty sure I'm one step away from the answer but I can't seem to see that step.
Thank you,
