Hi there, some help please?
I have a field called Posting/Document Date, that I need the sheet, when opened to select all values less than equal to Today's date.
I've created one Action to clear the selections in this field and then added another Action to Select values matching search criteria with the value of:
='<='&Date($(=Today()))
But it doesn't work 😞
I can type in <=09/14/2022 into the search criteria of the Posting/Document Date filter box and it works, but the action fails to fire.
Any suggestions please? Thanks!