Link latest update from one smartsheet to another
Hello everyone!
I am having a bit of trouble trying to come up with a formula that will automatically pull the latest update from one smartsheet and copy it to a cell in a different smartsheet.
The latest updates are entered via a form by the users and the latest rows are shown at the top of the sheet:
I want to copy the Concatenated cell from the top row (Row ID 7) to a cell in the "Update" column in a different sheet.
The problem I'm facing is that when a user completes the form again to add the latest status, the newest update is not reflected in the second sheet. In this case, the updates column will continuously show Update 3 in the cell despite there being a new entry submitted into first sheet.
Is there any way that I can create a link or formula that will update the cell in the second sheet to reflect the topmost cell in the concatenated column of the first sheet?
Best Answer
-
If new forms are populated at the top of the sheet, try this...
=INDEX({Column To Pull From}, 1)
Answers
-
If new forms are populated at the top of the sheet, try this...
=INDEX({Column To Pull From}, 1)
-
@Paul Newcome - Thanks! This works like a treat!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!