In a table I ve a column with the end date of the project. I’ve also an other table with the project phase.
If the Date is before today AND the Phase in not ‘Completed’ … then I would like to display ‘Delayed’.
Is it possible ?
It seems that it is not possible to make AND conditions ?
you have and or conditions in filters… in the IF-ELSE column you need to use a trick… make the order of conditions, the way that will eliminate nontrue options… so in your case, it will be:
if date is on after => 0
if phase is completed => 0
so the result will be 1 if the date is before and is not completed.