Filter on columns with values populated by a formula

sgintexas
sgintexas ✭✭
edited 12/09/19 in Formulas and Functions

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?

SmartSheetFilter.JPG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!