Sign in to join the conversation:
Hi,
Was hoping if anyone know if it's possible to have a line and its indents to be synced between sheets in a way that any change on one sheet for these lines will be automatically updated on the other sheet.
Thanks!
Yes, If they are identical or linked correctly andthe information is added in the sheet and not thru form or another method.
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Thanks for the reply!
Unfortunately I cannot share my sheet as there's confidential data in it.
My Sheet is consisted of lines that are defined as Epic, Story and Sub-Task (agile terms).
Sub Tasks are indent to Stories, and Stories are indent to Epics. Epics are big projects, and Stories and Sub-Tasks are breakdowns of the Epics.
I want a specific Epic to be linked between 2 sheets that have the same format.
I just need to know how can this be done.
Thanks,
Nir
Happy to help!
If the structure and sheets are identical, I would probably set this up with the help of cell-linking.
Can you remove the sensitive information and share copies of the sheets with me instead?
Would that work?
Andrée
Hi Nir,
How did it go? Did you get something set up?
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
I have an automation that has a condition where I am looking at the column "LEA Interco Supporting Site(s)" and trying to find columns that have the value "Fort Loramie" in them. This works well when "Fort Loramie" is the first item listed in the cell, but it doesn't work when "Fort Loramie" is the second or third value in…
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
