Create a table filter to only show rows with a date within 7 days

1

Hi there,

i would like to create filter on a table that only shows the rows where the column status is ‘complete’ and the date completed is within 7 days of today.

Is this best done as a filter or columns formula?

2

What I do is make three columns: Status, Date Completed, and Mark as Complete Button.

The buttons modifies the current row and sets Status to Complete, and Date Completed to today(). Then, just add the filter for Date Completed to the filter bar.

image
image742×343 32.2 KB

image
image382×539 30.2 KB

3

hi @Andy_Farquharson , I believe that @Samuel_Langford gave a good and practical solution

the last seven days can be written as a true / false statement:

image
image1554×1444 142 KB

however, my idea is that the solution @Samuel_Langford offered may be the best way forward.

cheers, christiaan

4

Thanks for the feedback.

The challenge i have is that I would like to view the data within the cards/kanban format and this level of filtering doesn’t seem available.

Any ideas on how to address that?

5

Yes you can filter table with formule directly.
Personally, I prefer to do it as a formula directly in the filter.

statut == “complete” && date >= Today() && date <= Today() + 7

6

I tried that formula but had the issue that it filtered the whole table rather than those with the status “completed”

Here is the formula;

=thisRow.Status=“completed”&& thisRow.[Date completed] >= Today() && thisRow.[Date completed] <= Today() + 7

Any suggestions on how to improve it?