nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Copying rows from one sheet to another

Lauren Koch

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!

Find more posts tagged with

Comments

Andrée Starå

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

Lauren Koch

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!!!

Andrée Starå

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!

Best,

Andrée Starå - Workflow Consultant / Get Done

Andrée Starå

Hi Lauren,

How did it go? Did you manage to get something set up?

Best,

Andrée Starå - Workflow Consultant @ Get Done

Sign in to join the conversation!

Quick Links

Trending discussions

Created Date Time Stamp
Has anyone figured out a way to use a column as a created date but not have the time stamp? It causes problems for my manager trying to use that date to pull into PBI. I know how to convert in a helper column to a year-month and a year, but those have to be text/number columns, not date columns and he can't use those…
How to auto populate cells
I am looking for a way to automate a cell so that when column A displays 9 'Days Open' (or between the values 0-14) the 'Req Age' will auto populate (or trigger) the ranges provided. Image below: I want the highlighted section to auto populate based on the value in 'Days Open'
Why Can't I no Longer Able to add Folders, Sheets, or Reports in my "Sheets" folder
Good morning, I haven't needed to do this is quit a while but I went to clean up the "Sheets" folder in my account and can no longer create a folder, sheet, or report in any area of that folder. The "Create" button at the top right takes me the templates page. This is what I am seeing vs what I can do within a workspace.…