Can I do a cell link with an absolute?

How can I cell link but have the information stay in the exact cell I pull from when the data gets upadated? For ex

the bottom sheet is the information i want to pull from. Column RDC, row 1 is the value I want in that cell to return to the top sheet every time the bottom sheet gets updated no mater the information in that cell.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!