I'm missing something here. Hope someone can help.
I've put conditional formatting on the first few columns of the Project Info table. It looks for the existence of a record in the Time Input table, coloring green if there are none. I will instruct that it's okay to change a name if it's green, and action would be required if it's not (records exist). Here's a snip of the table.
So there is column that he'll use to set the status of his projects, Open or Closed. As you can see, I've set the value to Closed on one project. Now, on the Time Input Table, I want to conditionally format the Project column to indicate if the project is closed. Later, when he does maintenance on his file, he can filter his tables by the highlight to delete closed projects.
Thought I could do that with Index Match function, but am getting an error in the formula box. Here's the formula.
=If(INDEX(ProjectInfo[Status],MATCH([@Project],ProjectInfo[Project Name],0)))="Closed"
Hope you can help!! I don't want to add an unnecessary column to Time Input just to get a format to work.
Thanks in advance for your help!
I've put conditional formatting on the first few columns of the Project Info table. It looks for the existence of a record in the Time Input table, coloring green if there are none. I will instruct that it's okay to change a name if it's green, and action would be required if it's not (records exist). Here's a snip of the table.
So there is column that he'll use to set the status of his projects, Open or Closed. As you can see, I've set the value to Closed on one project. Now, on the Time Input Table, I want to conditionally format the Project column to indicate if the project is closed. Later, when he does maintenance on his file, he can filter his tables by the highlight to delete closed projects.
Thought I could do that with Index Match function, but am getting an error in the formula box. Here's the formula.
=If(INDEX(ProjectInfo[Status],MATCH([@Project],ProjectInfo[Project Name],0)))="Closed"
Hope you can help!! I don't want to add an unnecessary column to Time Input just to get a format to work.
Thanks in advance for your help!