I'm trying to figure out a formula for when a parent is marked as complete that all the children under are also marked as complete.
Can't you set the child cell to =Parent()
@Debbie Sawyer unfortunately there are some projects that are more in depth and the children are tracked with different time lines. The goal is if a Parent project is marked off complete as a whole, no matter if your children are more in depth or the project is less intensive it would mark them all off as complete regardless.
Maybe have a hidden column that is a copy of the complete column, where the formula in the parent row = Complete@row and the child rows is =Parent(). Then have a Set Value Automation to say when the helper column is set to complete, update the value in Complete@row to show complete too?
Then the children in the complete column can be tracked to thier own tasks, but when the parent is marked as complete then they get changed too.
Would that work for you?
I have data in Excel that I need to import on a weekly basis into Smartsheet (lets say columns A-F) I would like to have columns (lets say G-H) with formulas. How do I import data each week replacing the previous week's data (only columns A-F) without overwriting the formulas? Is it possible to do this via Datashuttle or…
We had a Latest Comment column but the Column Type wasn't accurate. Showing as a Text / Number type. I tried to resolve this and I get the error "There is already a Latest Comment column in the sheet". To try to resolve, I created another column and deleted the original. However this still hasn't fixed the issue. There are…
Hi everyone, my colleagues and I are new joiners to smart sheet, we all have pro plan licenses, but when I share a sheet with them with Admin access for each and every one of them they still don't see the Filter CHOICES I added in the Task Bar (to the right of the dropdown for changing the view), any idea why that is? I…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.