Filtering values by V-lookup based on multiple column values

prathap.krishnashetty69881
prathap.krishnashetty69881 โœญโœญโœญโœญ
edited 01/19/20 in Formulas and Functions
Capture.JPG Capture1.JPG

Hi, i'm trying to filter values without YES in Column2 of sheet Y by Vlookup from Column2, Column3 of sheet X where Column3 is tagged as YES. Here is the formula: =COLLECT([Column2]1:[Column2]8, {New Sheet Range 1}, @cell=Value<>Yes). I feel something wrong with my code or approach. Any help appreciated.

Best Answer

ยซ1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!