Hello Gen
What is your current filter? Are you using a formula, or directly in the filter options of the table?
Can you share a doc with the data that you want to filter?
If you provide more details it would be better to help you
Best regards
Arnhold
Hi Arnhold
I used the direct filter options of the table > Date Added > equal to This week. I’m sorry I’m unable to share the doc since our admin restricted the access. But when I try to change it to the Last Week or This Month, it won’t show.
There is something strange.
I tested the filter bar with the date column, and it works as expected.
How did you set up the Date Added column?
It seems that the values in this column are empty. I assume this column should display the creation date of each row, correct? Please confirm if this column is being populated.
Best regards
Arnhold
Yes the Date Added column has just been hidden.
I tried just now, I inputted dummy notes and it worked when I change the filters. Is there a possibility that the previous notes won’t show because I am not the one who added values in the rows? Like will it only show my notes? (hope that makes sense)
Thanks
Probably not. For this filter, it doesn’t matter who added the rows.
I see that your column is a calculated one. Just to clarify, what is the formula you’re using?
Intuitively, I imagine it might be something like thisRow.Created().
Revisiting your filter options, it seems there’s another filter applied in addition to the filter bar. This additional filter is filtering out any rows older than a certain date, and I think this is where the issue lies. The filter bar doesn’t replace the filters you’ve set in the table properties; instead, it works as an added layer. In other words, if your table properties filter is set to show only rows from the current week, and you select “Last Week” on the filter bar, it will display nothing.
Hi Arnhold
YOU ARE A LIFE SAVER!!! I just removed the other filter and it worked!! Thank you so much for your help!!
Gen