Linking Sheets

Options

Hi,

I have a set of 43 sheets, reports and dashboards. We recently linked a section of one project (10 rows) into another sheet so that the information gets updated in one place, yet it shows in the other project for which it is a dependency.

I now realize that while my reports pull correctly, my calculations are double dipping. i.e Countifs that count the status (rygb) count the original rows as well as the linked rows.

Does anyone know if there is a way to exclude linked rows in calculations?

I hope I have explained this well. Please feel free to ask questions in the quest to resolve this.

Thanks

Best Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Melitta King ,

    I can only suggest a workaround. Add "Exclude" as a checkbox column to the sheets with data being counted. Check the box in rows that are linked and being double counted. Then add the Exclude column as a range and =0 as the criteria in your COUNTIFS formulas.

    Curious to see if someone has a better solution.

    Good luck,

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓
    Options

    Based on what I am reading, the suggestion of an "Exclude" column is going to be the best initial solution.


    Are you able to provide more details as to your workflow, which metrics you are pulling, how your sheets work together, etc?


    There may be a way to restructure that wouldn't require an "Exclude" column to help with not needing to manually check boxes (which can easily be forgotten or missed) as future projects are added and linked.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!