Help me with this one please

Closed
Report
Posts
1
Registration date
Wednesday July 27, 2016
Status
Member
Last seen
July 27, 2016
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
I like to display all the documents with "john salvatus" name. but only if the text in column C has "Overdue" in it and the column K has a null value. can anyone know the formulation for it?

1 reply

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi JhunTan,

Go through the option of the filter.

For column C, choose "End with" and enter the value "Overdue".
For column I, uncheck everything except "john salvatus".
For column K, uncheck everything except empty cells.

Best regards,
Trowa