Use the Index/Match formula combination to pull data from one Smartsheet sheet to another automatically.
I’ve used this formula combination in almost every Smartsheet implementation I designed for clients. It updates in real time without having to worry with automations or advanced Smartsheet tools to kick in.
📰 Plan your Smartsheet implementation like a Consultant: WorkflowCreative.com
The only Smartsheet book I recommend: https://amzn.to/45fUu1A