formula help linking to a row on a different sheet is the text from one cell is found.


I am somewhat new to SS and I am trying to link 2 sheets. one column on sheet A is auto generated when the incident is logged. the autogenerated text is a reference number for the incident (ie: INC.052) I am trying to link to the description of that incident in a different sheet. so far, the only way I can think of it is to create a separate column, and have a formula that says if sheet 2 column A has the text of sheet 1 column A, generate the link to that Sheet 2 row in sheet 1 column B. I am sure that is confusing, but if there is anyone who can help, it would be greatly appreciated.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!