Connecting Two Sheets by Cell Value

I have two sheets - one for contract info and one for billing info. I'd like to be able to click on a row (or field/cell) in one sheet and be taken to the respective customer's info in the other sheet. I don't need to do calculations or inbound or outbound links. I only need to click on Customer X contract info and be taken to Customer X billing info in the other sheet, and vice versa.

So, for instance, something like "click here to find Customer X on Sheet 2" . . .



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!