Help me with this one please

Closed
JhunTan Posts 1 Registration date Wednesday July 27, 2016 Status Member Last seen July 27, 2016 - Jul 27, 2016 at 02:56 AM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Aug 4, 2016 at 10:36 AM
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

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Aug 4, 2016 at 10:36 AM
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
0