Link cell automation


This is probably a "no," but I am working on transferring a lot of Smartsheet data from one sheet to a new format, and it is requiring a lot of manual labor, so I'm trying to automate as much as I can. One thing I am doing requires me to link the cells in certain columns to another sheet. Is it possible to set up an automated workflow to automatically link the "IRB app..." "Study Status," and "Image Type" in the first sheet to the corresponding cells in the second sheet, if the Protocol IDs match?

If there are any other suggestions on how to do this more quickly, I'm open to alternative approaches! I should note that I need these to be linked because I need both to update when one is changed.

Thank you!

Best Answers