Filter on Column Formula based Field in Dynamic View

Samuel Mueller

Is it just me, or are you unable to filter based on a column with a column formula in it?

Ray Lindstrom

@Samuel Mueller,

I just tested, and I was able to filter on a column with a column formula applied to it.

Able to filter both on the Grid as well as via a Report.

Genevieve P.

Hey @Samuel Mueller & @Ray Lindstrom

To answer the first question, yes - I can filter on a column that has a column formula in Dynamic View!

However for your second question, no, it's currently not possible to filter by a Date, yet. Here's the Product Idea to add your vote and voice:

https://community.smartsheet.com/discussion/110416/dynamic-view-filter-by-date

Cheers,

Genevieve

Ray Lindstrom

@Samuel Mueller,

I just tested, and I was able to filter on a column with a column formula applied to it.

Able to filter both on the Grid as well as via a Report.

Samuel Mueller

Thanks @Ray Lindstrom, I'll have to do some more digging.

Ray Lindstrom

No problem. Let me know which column type you're working with, and I'll try the same from my end.

Samuel Mueller

@Ray Lindstrom what about date fields?

Ray Lindstrom

@Samuel Mueller,

I just tried on a Date field and Filtering works. I also tried on an Auto Date Field (Modified Date), and it worked.

Samuel Mueller

@Ray Lindstrom So when I go to filter, the date fields are not in the list at all. For example: all the possible fields to filter, then last field is the columns in the dynamic view. What am I missing 😐

Samuel Mueller

Ahh. wait so how did you filter on a date field? I found this article from a few years ago. @Genevieve P. is this on the roadmap? this is wild 😄

Date Filters within Dynamic View — Smartsheet Community

Ray Lindstrom

@Samuel Mueller,

My apologies. When I first read your post, I missed the Tag "Dynamic View". After testing in Dynamic View, I cannot filter by Date column. All of my previous testing was directly on grids and reports. Sorry for the mix-up.

All the best,

-Ray

Genevieve P.

Hey @Samuel Mueller & @Ray Lindstrom

To answer the first question, yes - I can filter on a column that has a column formula in Dynamic View!

However for your second question, no, it's currently not possible to filter by a Date, yet. Here's the Product Idea to add your vote and voice:

https://community.smartsheet.com/discussion/110416/dynamic-view-filter-by-date

Cheers,

Genevieve

Ray Lindstrom

Thank you @Genevieve P.!! 😊

Samuel Mueller

Thank you for clarifying @Genevieve P. 😃.