Linking to another sheet when a certain word is used

justin46491 · 05/16/18

I am trying to get 2 sheets to work together. Meaning when I have a certain word or phrase I would like it to link to another sheet. How ever it can only be that word or phrase or nothing else.

I need help

Thank You

L_123 · 05/16/18

=if(find("Phrase",[Column2]1)>0,{link to cell in other page},"")

URL Posted below is help on referencing other pages

https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets

Linking to another sheet when a certain word is used

Comments

Categories