Is there a way to copy Summary Fields to other sheets but not overwrite data already entered


HI, I have an issue where we have most Summary Fields that contain formulas but we have a few which are keyed in for integration with our CRM.

I have created a sheet with the manual summary fields and another for formula fields but when I copy only the last set of Summary fields are stored.

Additionally, when we add more formula fields and copy them to other sheets (in batches of 20), these manually entered fields are being overwitten by those from the template.

I can add a cell in Smartsheet that contains the codes and I can create a formula to populate a summary sheet bit this is prone to user error.

Does anyone have any suggestions?



Best Answer