Copy a cell to another cell for updated numbers

Randy Poole

Hello, i want to copy one cell to another cell in the same row every time it updates. I still want to change the values in the cell that the numbers were copied to so it cant have a formula in that cell.

Example:

cell 14 Linked cell from another sheet - QTY= 50 (updates to 48)

-Copy/paste automatically to

Cell 15 - count was 56 (switched to 48 from Cell 14 being updated)

Cell 15 i want to update manually as well but i dont want cell 14 to change to a different number if i update cell 15. Cell 15 went down to 48 i update it to 50 manually i dont want cell 14 to update to 50 i want it to stay at 48 almost like a one way street.

Is there a formula or automation that can make this happen?

Andrée Starå

Hi @Randy Poole

I hope you're well and safe!

Please have a look at my post below with a method I developed. (it will use a formula, but as long as it's not a column formula and it's edited in the sheet, it should work)

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!