Filter on Column Formula based Field in Dynamic View
Is it just me, or are you unable to filter based on a column with a column formula in it?
Best Answers
-
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.
-
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:
Cheers,
Genevieve
Answers
-
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.
-
Thanks @Ray Lindstrom, I'll have to do some more digging.
-
No problem. Let me know which column type you're working with, and I'll try the same from my end.
-
@Ray Lindstrom what about date fields?
-
I just tried on a Date field and Filtering works. I also tried on an Auto Date Field (Modified Date), and it worked.
-
@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 😐
-
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 😄
-
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
-
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:
Cheers,
Genevieve
-
Thank you @Genevieve P.!! 😊
-
Thank you for clarifying @Genevieve P. 😃.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives