How do I auto-update a cell value from one sheet to another without copying an entire row?
I have two sheets -
Sheet A tracks participant form submissions from program events. The forms include information about each event/activity (date, time, contact info, etc) the participant participated in.
Sheet B is a participant management sheet that contains information about each individual participant, including their activity within our various programs.
Id like the most recent event submission date from sheet A (by participant) to populate to sheet B under the matching participant name, in order to keep participant activity updated.
I'm quite a beginner and would love any helpful suggestions! Thank you!
Answers
-
Are you able to provide a screenshot for context?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Sheet A - where the forms are submitted, often times many at once for the same participant.
Sheet B, where we manage participants. Id like the column to be called "Most Recent Monitoring Event" however the priority is just to have the cell update by participant.
Thank you for getting back to me!
-
Try a MAX/COLLECT combo.
=MAX(COLLECT([Date Column}, {Email Column}, @cell = Email@row))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!