Sheet A, Sheet B
Hey,
New to this stuff. So if i wanted to have 2 sheets and one sheet colum is being updated how can i update the same data to Sheet B but in a dropdown list.
I want a feasible option, for example i cant have offloading or uploading a lot of data shuttles.
Answers
-
I accomplish this through the automations function in my sheets. Once a I have made an edit/update in the sheet the automation makes a copy of the row and adds it to the 2nd/identified sheet. They're fairly simple to build. See example below. If you have access to Smartsheet University, check out this self paced training: Automating Your Workflows - https://smartu.smartsheet.com/automating-your-workflows-elearning I found it to be very helpful.
-
@AMF the Automation that you are talking about isn't that for just simply updating two sheets. I am talking about that the other sheet colum gets updated in dropdown list manner -
