Tables: Apply Filter - Multiple column filter
Hello, I have a workflow that is currently filtering a data table into three different parts based on webform submission. In one of the filtered parts ('Show'), I need to filter again by date (<='formatted-date').
When I try the formula below in the advanced filter logic, it works when all of the submissions in the original data table are 'Show'. If I have any other submissions with 'No Show' or 'Change,' the results are 0, even if there is a 'Show' included.
I've also used the 1st & 2nd column filter fields and that worked only when there were multiple submissions in the original data table, not when the only submissions were 'Show.'
columns == "Show" && columns["Start Date"] <= "formatted-date"
Any help would be appreciated!