Ok, as per usual, having a problem with expressions.
I have a table with Columns I am trying to filter out by using the “Show_If” function.
I want to filter the Columns based on the name of the column header, not the value in the column.
That’s to start, and maybe where I am having problems.
The column headers are names of clients.
I want my equation to only show that column if the user/employee has been assigned to that client.
I have this information in another spreadsheet.
I have tried the following but it doesn’t seem to be doing anything at all.
I can still see the Columns of clients whose information I am not assigned to, so I think it isn’t working.
=“text value” = ‘Master Garden List’[Client Name].[Employee Name]
Please let me know how my terminology is wrong.
My second question is this: if an expression verifies, how is it possible that once you “Verify and Save” it brings up an error?