Reference cell in column on one sheet, against column on another.

Jason Dickson
Jason Dickson ✭✭
edited 09/01/22 in Formulas and Functions

I am trying to create a formula thagt will look at the "Item Name" columns numbers, and then check to see if any instance of that number appears in a column on another sheet, and if it does return "True", and if it doesnt return "False"

I've had a similar equation in excel "=NOT(ISERROR(MATCH(A2615,'Up-To-DateLK'!A:A,0)))" but I am trying to move away from excel as it is very frustrating to use(equation works sometimes and just decides not to at other times). I cant seem to get this to work in smart sheet though.

I've tried modifying it to "=NOT(ISERROR(MATCH([Item Name]@row{MES-Relevent Items Range 1},0)))" however this gives me a #UNPARSEABLE error.

Any help would be appreciated!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!