Interesting filter questions

1

How can I create a filter to NOT include records that a flaggged as Done in the status field and the date is more than a week old?

2

Try along the lines of filter(Table.Done?=false AND table.date > today()-7)

(EDit to remove quotes as suggested by Max”

1 Like
3

only dont put false in quotes

max

1 Like
4

Hello @Chris_Hall ,

I think what you are asking for is the following code (enter this in the filter options of a table):

not(Done) && Date<today()-7

for your information:
&& is shorthand for AND
|| is shorthand for OR

2 Likes