I am looking to create a filter to help identify status errors.
For example:
Shot A - Animation Version 3 has a status of Fix, but the Animation task is still in review, or approved.
What I’m looking for is a way to show a list of shots where (Latest Version Status) is NOT equal to (Task Status)
I’d appreciate any tips or tricks you might have.
Also I have 1 column that has the info I need to make this filter work for myself, but in all page types (Shot, Task, Version) it is greyed out in the filter list, does anyone know why some options are not available in the filters?