Filter on columns with values populated by a formula
Hello. After searching and coming up empty handed, I decided to post for help.
I have columns in a sheet that are populated by VLOOKUP functions. Whenever I run a filter on one of those columns, all 1703 rows of my sheet are in included or excluded.
As an example, if I set a filter on the "Effective Price To" = "is not in the future" all 1703 of my rows are displayed, yet clearly some of the date values are in the future.
Both lookup and populated columns have the "date" column type set.
Is this a limitation of cell values being derived from a function?
Comments
-
Hi,
I've never seen this before, so I'll experiment and get back to you.
Can you share the sheet or a copy of it?
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andree,
Thanks for the response. Since my data is private and confidential, I decided to build a sample to share. However when I created the new sheets the functionality was as expected.
I guess the issue resides with this particular sheet and/or my source data. I'm going to try creating the sheet from scratch with my production data and see if I run into the same problem. I'll update this thread regardless of the results.
Thanks,
Sean
-
Hi Sean,
Ok. Let me know how it goes and if I can help in any way.
Have a fantastic weekend!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!