Copy a cell to another cell for updated numbers

Options

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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!