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

gregallen1207

Hi,

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.

Paul Newcome

You would need an INDEX/MATCH.

=INDEX({Sheet 1 Column B}, MATCH([Incident ID]@row, {Sheet 1 Column A}, 0))

Genevieve P.

Hi @gregallen1207

I see you marked Paul's response as not resolving your question. Would you mind letting us know what didn't work with that formula? Are you receiving an error or incorrect result?

You can learn more about the INDEX(MATCH combination in this Help Article:

https://help.smartsheet.com/articles/2482647-cross-sheet-formula-combinations?_gl=1*b7bilj*_ga*MTM0NDI2NzIwMy4xNjYxNTIwMDkx*_ga_ZYH7XNXMZK*MTY2OTgxNjU3MS43Ni4xLjE2Njk4MjIyOTEuMjUuMC4w&_ga=2.193254701.1432228225.1669626410-1344267203.1661520091

If this still hasn't helped, it would be useful to see screen captures of your sheets but please block out sensitive data.

Cheers,

Genevieve