Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Link Cells - Anyway to update data on either sheet
I use the cell linking extensively, however it would be so very helpful if cells could be updated from either sheet... For example, I have a master project sheet that consolidates lines from mulitple projects in sepearte sheets. However when I want to make a change to one of the lines I have to go to that projects sheet rather than being able to update from the master sheet. Not all users of the individual sheets need or should have access to the master sheet so I don't want the data to "start" in the master sheet either. Thoughts?????