Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
I have a scheduling sheet that I use to keep track of each project manager's pre construction timelines. Each project manager has a sheet to keep track of multiple projects. I have created each project as a parent row with children rows with each task for the referenced project. I am trying to create a report that shows our GM what projects have upcoming review dates. The only thing referencing the project is if the parent row is included in the report. Is this possible?
Hi Jill,
Yes, If I understand you correctly.
You'd probably need to add a helper column to your sheets (depending on the structure of your sheets).
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
I have done that before on a sheet I think. Is it where you create a checkbox helper column, to be checked if the row is a parent row? And then include rows that are checked in the report?
That's one way to do it. Another is to add automatic levels (parent, children and so on) and in that way, you can select to only include the top row.
Andrée
Seem to stumble upon these needs that ends up with some helper columns and stuff...
Looking for a way, like in the filter function in a sheet, to include the parent row of a filitered result in the report view.
Anotehr one for the wish list - hope that Smartsheet implements - invisible feature request list?
Donte really understand why i have to keep track of what is a parent row when the sheet apparently already has this information and can handle it "project view"...
/Mattias
Hi Mattias,
Great idea! That would be a great addition to Smartsheet features.
Please submit an Enhancement Request when you have a moment.
I hope that helps!
Workflow Consultant / CEO @ WORK BOLD
Who knows, maybe someone might find this useful.
I completely agree that more control over ancestor/descendant display in reports is a needed feature.
But In the meantime, I use a fairly simple workaround that does enough for my needs: I just added a column to my sheet named "parent" and just pasted =(PARENT([column name]@row)) into the whole column (I thought just =(Parent()) would be sufficient, but that only worked some of the time, and just using the other formula was simpler than trying to figure out why); then just hid the column on the sheet and then included it in the report and moved it over to the left side, it just comes up blank if there are no parent rows.
It wouldn't work for everyone (like if you needed to see the entire parent row and not just the name, but for me at least it generally suffices), and the more granularity you need over what information you need, the more complicated the formula would have to get. You could do it for child, grandparent, etc., too, obviously. You can also do this multiple times for different columns, though the more of those you do the more cluttered and less useful it gets.
For what it's worth, there is one big plus for me to this solution, which is that it gives the info I need without adding any actual additional rows to the report. Including all the parents could up to double a report length which is lot more to go through if you only need limited information from the other rows; this gives me what I need without making the report longer.
Again, if you need to be able to see the all or at least large amounts of information from the other row, this doesn't really help but, if you just needed a limited amount of information from a parent/other row, it's not bad.
@Andrée Starå you mentioned
"add automatic levels (parent, children and so on) and in that way, you can select to only include the top row."
I have sheets setup with dependencies enabled, is that what you mean by automatic levels? In my sheets, I indent the row below the parent so that it becomes the child. Now for my report, I'd like to only see the parent rows. I'm not understanding from your response above, just how to "include the top row" only. Would you please elaborate?
@Jovon Staveland
Yes! I found that incredibly helpful! Thanks for the great tip.
This one is easy.
Add a hidden helper formula column in your sheet that will calculate the Parent Task for that row.
Example of the formula below where [Task Name] is a column name in my sheet.
=PARENT([Task Name]@row)
In your Report, use the group tool to group by the helper column.
This will present the filtered tasks by the parent.
= Week (today()) & " - "& PARENT([Task Name]@row) to sort the Parent Rows by date
Hi there, I have just recently worked with Smartsheet's Implementation team to build a Control Center Blueprint. The workspace that holds the solution is titled something very generic and I would like to rename it. Can I do that w/out breaking anything or what steps would I need to take to successfully rename it. Thanks in…
Hey, I've got a sheet, which is autopopulated as a source sheet to feed into DataMesh (which runs once every 24 hours). Once DataMesh has run, how can I auto-clear the rows in the sheet to avoid repeating this the next day? I have no use to keep the data and want to avoid clogging up the source sheet. I have tried…
Hello everyone seeking for an answer and help please im having a hard time on approval request automation . My workflow runs smoothly however when the approver open the attachment on the request it automatically downloads and when clicking the approve it says link are already used and auto decline teh approval request…
