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
I'd like to create an automation that does two things. Trigger: When rows are added or changed I want the following two items to happen. Record a date in the column "Completed". Set to today. Move row to sheet called "Completed Jobs" Please let me know if there is a way to do this using conditions?? If so, please give me…
a PM asked me to look at his schedule because one of his predecessor cells had #REF. We can't figure out why this is happening because he references line 176 in other cells in the column. When I went and looked at the schedule on my computer, the #REF error moved to a totally different cell and I don't see it in the same…
Still looking for documentation, but I am curious about the limitations with the dropdown linking in Table View. Does a person need to have access to the dropdown source sheet in order for the dropdowns to populate on the Table sheet?
