Sign in to join the conversation:
Question... is there a way to automatically update information in a row when one row is updated on one sheet and copied to another sheet?
If not, is there a work around?
Thanks for any help!
Hi Lauren,
It sound like you could accomplish a part of this with cell linking but i can't know for sure before i have som more information.
Can you explain your use case in more detail?
I hope this helps you!
Best,
Andrée Starå - Workflow Consultant / Get Done
Thanks for the reply!
I have 4 project managers who track their tasks for multiple projects on one personal smartsheet. There is a column that assigns a resource (which all 4 project manager's share). This task row is currently being copied to the resources smartsheet. If the project manager makes an update to the task row, I need it to populate that change to the resources sheet. Is there a way to do cell linking in a mass case? There are close to 50 rows per resources sheet and I cant imagine the time it would take to link all the cells for all the tasks.
Thanks for your help!!!
Hi again Lauren,
I have a few ideas on how to se this up!
It sounds fairly complex but I'd happily work with you and help you with setting up a solution but I need even more information to see what would work best for your particular situation.
If you'd like we can book a time for a free discovery call and take it from there.
How does that sound?
Please e-mail me at andree@getdone.se and i'll set it up.
Have a fantastic day!
How did it go? Did you manage to get something set up?
Andrée Starå - Workflow Consultant @ Get Done
Hi, I'm using smartsheet to track updates on each task in a tracker. These updates may span over a year, so they get lengthy. I was excited about smartsheets because viewing these notes is a lot cleaner. However, I've just realized that there is a content limit to a cell, which is a huge issue. While excel was annoying to…
Hello, i've a question about 2 tasks. Task 1 has for example 4 hours and should be on day 1 for example 6 january. Task 2 has 30 hours and should be on start on 4 january and futher. How can i manage that on 6 january task 2 has only 4 hours? Now i got the message user is over-allocated because task 2 is planned on a full…
Hi All, We have several update automations on various solutions - and have worked very well for getting info from people that dont have smartsheet access - how ever in Sept we switched over to SSO and MFA and activated the Safe Share - We have now run into an issue that when our update automations trigger and people within…
