Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formula to reference cell in another sheet?
Hi, I'm wondering if it's possible to reference a cell in a different sheet with a formula. My source sheet is intended for users to add entries, and my destination sheet is intended to keep track of when the source sheet was last updated. Because entries are added to the source sheet, and I always want the newest date on the destination sheet, I can't use cell linking. I need a static link to another sheet, similar to Excel's "Sheet_name!Cell_address" reference (I pulled that from https://www.ablebits.com/office-addins-blog/2015/12/08/excel-reference-another-sheet-workbook/ if more info is required).
Basically, I want to have some form of:
to show the created date (the value of the Date column) of the entry in row 1 (the newest entry) on the First Aid Kit Inspections sheet. Is this possible?