How do I copy cell values from another sheet?

I have multiple sheets that serve different purposes, but the information is similar. I am trying to set up a workflow where you only have to update a parent sheet. The column names cannot be equal so I was not able to use the copy row logic for this which is fine. I at least wanted to set up a formula to copy cell values from the parent sheet so that field would update in real time. Smartsheet AI indicated it was not able to generate a formula to copy values from another sheet. You can copy cells very easily within the same sheet. I would assume the same should apply except you reference another sheet. Is there a workaround to this? For example, I want to link the Notes for a specific cell from Sheet 1 into a cell in Sheet 2, so Sheet 2 notes update as I update the notes in Sheet 1.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!