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 am attempted to export to excel. I have two different smartsheet documents to export. One of them exported to excel fine, but not the other. This happened a few weeks ago. I make sure all columns were the correct size & no cells were hidden. "We have found a problem with (file) Do you want us to try and recover as much…
Hello Smartsheet Community, I need some help with a report that I created and shared with a customer. The customer is not seeing any of the information that is pulling into the report. See screen shot below that the customer texted me. I do have the report filter only showing the customer their product pulling from our…
BLUF: When I create an Invoice, I need the cell-link to my live price data to be severed. I currently have a Price sheet for my products that is updated frequently. I use Control Center to create Projects, which includes an Invoice sheet. I have a dropdown on my invoice sheet to select a product, and then I use Index…
