I have 5 main parents with some smaller indents.

Pre-Explore (one of the 5 main sections) within that I have a parent meetings with children and several other parents with no children.

I have a % complete column we are manually filling out.

I'd like to be able to show just the 5 main sections and provide a number of total uncomplete items. I can do this in a report but wanted to add it to my dashboard as a metric.

Is this possible?


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You would need a column with the following column formula:


    Then in your metrics sheet, you would incorporate this column into your formula(s).

  • The main row is showing zero (pre-explore) I included a screen shot for you. What I'd like to show on my dashboard is how many items based on Pre-explore, explore are incomplete. The screen shot shows the formula provided in the help column. I'm not sure it's working the way I wanted, I don't think I explained it very well.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    My apologies. I misread your initial post. Based on your screenshot above, exactly which rows should be counted? Those on level 1, those on level 2, or both?

  • Not sure what level 1, level 2 are, sorry. I would want to show on pre-explore 3 that are not complete,

    on explore 4 (including the seasonal planning item), these are all not at 100%.

    Does that help?

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    It looks like the "help" column is denoting which level of hierarchy each row is on. Do you want rows that have a 1 in that column, a 2 in that column, or rows that are either 1 or 2?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!