Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to highlight values in the Job column that matches the Dependency Column where the status is equal to red.
In the first image, I have a list of jobs, the job's status and it's dependency. So if a Job's status is 'red' and it has a dependency, it should highlight the job that equals the dependency value.
I have tried several different expressions, but none gives me the result I want to display.
I've tried if(WildMatch(Job, '*' & [Dependency] & '*'), RGB(0, 255, 255)) but it doesn't seem to work
The output that I am looking for can be seen below
Hey there,
Perhaps consider this script code:
Hey there,
Perhaps consider this script code: