Showing Only the Parent Rows in a Dashboard Chart

edited 12/09/19 in Formulas and Functions

Hi - I have created a dashboard to show pie charts of my data. My problem is that the pie chart wants to include every single row as a data point, I only want to show the parent rows and not the children. I used the formula "=Count(Ancestors(row))". This gives me a 0,1,or 2 based on how many ancestors the row has. But I'm having trouble making the charts do what I want. Any help? Pics below (I just want to show HR and F&A in the pie).





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!