Hi folks, I’m curious how to filter a table by “recently completed”.
In my table this means showing all rows where the “status” column was changed to “done” yesterday.
Hi folks, I’m curious how to filter a table by “recently completed”.
In my table this means showing all rows where the “status” column was changed to “done” yesterday.
Table.Filter([status]=done AND [date completed]=today()-1)
[status]
column type is “Select list” or “Lookup from table”[date completed]
column type is “Date”Thanks @Ander !
I realized I first needed to create a “created date” column: