Sign in to join the conversation:
Is there a way to remove sub-rows from formula tracking? Ex: We want to track the general Task but not the detailed items below that task.
Can we do this with a formula and generate a single metric number?
Thanks for all the help!
Yes - and there are a couple of ways to do this.
Easiest? That depends on what you're trying to accomplish. If you just want to exclude all sub-rows, then I suggest something like what I've shown in this screenshot (count the children, if it's zero than it's a sub-row).
If you need finer control over it, I've also had success by creating a column called "Level" and Counting the number of ancestors. That gives you a numeric value for how many levels indented a row is, and you can use that number for conditional formatting, or picking only the levels you care about for reports / formulas.
Hi Sarah,
To add to Corey's excellent advice. Here's another formula that combines all in one.
I use this one all the time in my client solutions. I name the column Level and use that to simplify conditional formatting and more.
Try something like this.
=IF(COUNT(CHILDREN([Task Name]@row)) > 0; COUNT(ANCESTORS()) + 1)
The same version but with the below changes for your and others convenience.
=IF(COUNT(CHILDREN([Task Name]@row)) > 0, COUNT(ANCESTORS()) + 1)
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma."
I hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
Is it possible to sort a report widget in dashboards? We have data that could be sorted by date or by location name depending on the use case. Is this possible? I know the underlying sheet can be sorted by column, but I can't see a way to sort the data in the report widget.
When building this report an incorrect filter was added to the report (see picture). After it was added, we were unable to delete the filter, edit anything within the report, or edit columns in the sheets tagged to the report. Does anyone have a solution to this?
Is there a way to see where data is coming from if it is input or copied into a sheet by an automation? I have a sheet that is receiving to lines of data every night. I am not sure where these two lines of data are coming from. Initially I thought I was just failing to delete everything I didn't need after a sort, but I…
