Sign in to join the conversation:
Hello!
I am wanting to connect multiple sheets and sum on each parent level.
Each sheet has the same strucutre. I am looking for a "grand total" of many parent rows on these sheets.
How do I go about this?
Hi Nicole,
You could use cell-linking or cross-sheet references to collect everything in a so-called master metric sheet and sum everything there.
Would that work?
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
There are a few different options depending on your exact setup and needs.
My recommendation would be to sum up each sheet individually on each respective sheet.
From there you could either cell link each sheet to your metrics sheet then add all of them together, or you can use cross sheet references in a SUM formula.
Hi everyone, I’m experiencing an issue where all of my sheets have suddenly disappeared from my account. Here’s what I’ve already checked and tried: I’m logged in with the correct email address I’ve confirmed I’m in the correct region I’ve checked my Deleted Sheets folder I’ve tried logging in and out in all possible ways…
I am looking for a decision matrix, preferably weighted. Is there such a thing in Smartsheet currently today, or is this something that I have to build?
Is there a way to pull comments out of a proof and have them show up as a column on the main sheet? They don't come up in the conversation area, but they're on the activity log. I just don't want to overlook a comment on something if they don't tag me. I'm looking for any way to put a signal on the sheet that there's a…
