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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!