Linking to another sheet when a certain word is used
Options
Comments
-
=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