I have a row being copied via "Manage References" using INDEX MATCH from Sheet 1 to Sheet 2. If this row matches the project number and has a ".0" indicating added task to the same project, I want thi…
I have sheet that has many items on one that all have a similar process. If one is marked sold at any point (any child step) it will check all the sold for that particualr parent and children. This wi…
There should be a way to toggle option if we want to include child rows inside of a filter. Where we can currently have the parent row option, we should be able to also include child rows.
I have a project management sheet. CSYYXXXX is the header for the project name column Tasks is the tasks column - at the parent row, I just write "Tasks" and then there are child rows below that. Some…
Hi, I have this formula that works when automating parent/child tasks in a project plan. =IF(COUNT(CHILDREN(formula@row)) > 0, IF(COUNTIF(CHILDREN(formula@row), "Complete") = COUNT(CHILDREN(formula@ro…
I am attempting automate adding standard sub/child tasks to many parent tasks at the same time. Following the API documentation Specify-Row-Location I am using the parentID + toBottom location attribu…
I have parent rows (upcoming week, current week, and past weeks) and I'd like to be able to change the status cell from upcoming week to current week, and have it move the row under a different parent…
I am creating a Grid for not. It will be used as a form for the data entry aspect. And the primary viewing choice would be calendar. Now given that, I initially started with a template, and then just …
I'm working on creating some workflows that will copy information from a change order tracker sheet into a resource assignment tracker sheet. Ideally, I'ld like to grab key details from the change ord…
I am working with on of our departments internally on their Smartsheet system, and looking for insight into how some of you handle complex project plans. What they have right now is so bloated that it…