Trying to copy formulas from the Source Sheet to the target sheet using DataMesh

Markus Walser
Markus Walser ✭✭
edited 06/14/22 in Add Ons and Integrations

Hi,

I've set up a configuration, that merges entries using copy from a source to a target sheet that is updated with the latest new rows. Copying of the data is working fine, however the formulas in the source sheet get lost in that process. Is there any way to avoid this?

Background:

I've an Excel sheet containing hyperlinks. I import that sheet, keeping the formulas and the hyperlinks are kept in Smartsheet that way. When I now try to merge the new sheet with an existing sheet (already containing hyperlinks for the existing rows) I have to updated the hyperlinks manually after the merge, which can be tedious.

Thanks.

Tags:

Answers