How to map data from cells from Smartsheet source to Smartsheet target?
I have a task where I'm collecting information from automation events to a Smartsheet (source). The source Smartsheet contains columns of data of interest. Based on a status in Smartsheet, I want to trigger the copying of data from specific cells in source and paste it into specific cells in a target Smartsheet. The idea is to map data between two cells (one from each Smartsheet).
I am familiar with cross-sheet functionality like vLookup but wondering if my actions to pull data into my target Smartsheet can be based off a daily schedule dictated by a status column in my source Smartsheet?
Do note, the number of columns in my source Smartsheet will be different and labeled differently than those found in my target Smartsheet.
Any ideas on how to setup this mapping? I don't think our company has access to the DataMesh paid functionality in Smartsheet - so looking for creative alternatives from the community.
Help Article Resources
Check out the Formula Handbook template!