Previous Topic Next Topic

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 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 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 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 555
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