Making a Condition Based Only on Match

arw_88

If Index/Match is asking Smartsheet to "Insert value1 from Sheet B into A, where Value 2 on Sheet B matches Value 2 on Sheet A"

Is there a way to ask Smartsheet to "Insert Yes if Value 2 on Sheet B matches Value 2 on Sheet A".

So instead of inserting the indexed value, it is inserting a newly generated value you want only on the current spreadsheet.

Or maybe another way to phrase it is - can you make a condition based only on a match in a reference sheet, without indexing the values from that reference sheet?

Hope that is not too confusing!

Pauline J

Hi @arw_88

I think you might need a helper column for the index/match result. Then, in the column you want your "yes" you can compare the two column cells and enter "yes"

=IF(Column1@row = Column2@row, "Yes", "No")

I hope this helped!