Absolute Cell Referencing for New Top Row on Another Sheet


I am having trouble trying to write a formula that absolute references a specific row (Row 1) on another sheet. The referenced sheet has a new row added by Zapier everyday. I am writing a formula that would reference Row 1 Column 1. In Excel for example it would be "ReferencedSheet!$A$1. I don't seem to be able to create absolute references in another sheet, therefore my referenced cell keeps changing when the new row is added everyday. Any ideas?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!