I set up a report to show tasks completed, but only the child row is showing up. I would like the parent row to be included to provide more context. Do I need to change something on the sheet or report to implement this change and how?
I would suggest inserting a checkbox column and inserting this column formula:
=IF(COUNT(ANCESTORS(Status@row)) <> 0, IF(Status@row = "Complete", 1), IF(COUNTIFS(CHILDREN(Status@row), @cell = "Complete") > 0, 1))
This will check the box on child rows that are complete and on parent rows where at least one child row is complete. Then you can build you report to show rows where this column is checked.
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
I have a report that is filtered by a particular folder within a shared workspace... everytime I remove items from that folder the report no longer watches the folder, and it turns into individual items within the folder... Is this common behavior? Has anyone else experienced this behavior recently? I want the subfolder to…
I need some help translating a formula from Excel into something that I could use with Smartsheet. The final formula in Smartsheet would end up being a nested if: If Enterprise 2022 R1, give # of months between GA date and Go-live date, if EDIS 2022 R1, give # of months between EDGA Date and Go-live Date, if these are…
OK, this might not at all be possible but I am hopeful and am not giving up until I find out it can't be done... Hello Smartsheet Community!! I've been playing around with creating a Report, specifically a Row Report in that case. It works fabulous and YouTube videos are a great help! This "issue", though, I am unable to…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.