How can I transfer my calculated data onto the duration column if there are parent rows?
Hey everyone, I'm new to smartsheet and I have a question regarding the project sheet.
Attached is a screenshot of my current data.
I have over 1200 data and they are already seperated by parent-child relationship.
Each task has a production score and the parent's score is calculated by summing up all of the children's score.
We have a weekly quota of 270000 production score a week (or 54000 daily), and I calculated how long it would take to complete the task by taking the row's production score and dividing it by the quota. This gives the results as shown in column11, which are the duration of each task daily.
I would like to know if there's a way to transfer the data from column11 to the duration column in a fast way because if I copy paste the entire column, there is the following error for parent rows: "Because this row has sub-tasks, this cell is a summary value and cannot be edited directly."
I have 200+ parent rows, so it will take a while to copy paste all the children rows manually into the duration column.
Best Answer
-
Hi @Tvl_97
What I would do in this instance is use a Helper Column to identify if a row is a Child Row or not:
=IF(COUNT(ANCESTORS([Task Name]@row)) > 0, 1, 0)
You can make this a Column Formula, then you can use this column to set up a Filter on your sheet, hiding all of the Parent Rows:
Then once the filter is applied, you will only have Child Rows so you can Copy/Paste across all your data:
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hi @Tvl_97
What I would do in this instance is use a Helper Column to identify if a row is a Child Row or not:
=IF(COUNT(ANCESTORS([Task Name]@row)) > 0, 1, 0)
You can make this a Column Formula, then you can use this column to set up a Filter on your sheet, hiding all of the Parent Rows:
Then once the filter is applied, you will only have Child Rows so you can Copy/Paste across all your data:
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives