Summary Row Card View

Hello,

I cannot find any resources showing how to create a summary row card in card view. My lanes are based on stages of a project which is selected through a drop down on each row. I would like to total the NPV of each project that is in that stage (NPV is one of the columns in my sheet). How do I do this?

Thanks!

Find more posts tagged with

Project Management

Card View

Comments

ricki

I think I had something similar so maybe this will help

I had a parent row in my sheet for Sprint

And then i had children rows for each item in the sprint

I wanted to know what the total number of hours per sprint for each item

My first attempt was to use a sumif with children. The limitation of this is that it would not capture any of the grandchildren

If you need I could try and dig up that formula

So instead I switched to a formula which used a sprint column in each item row. I needed to do this as two columns - one was estimate and a second sprint estimate to make sure things didn't get double counted

=SUMIF(Sprint:Sprint, "Sprint 22", [Estimation of Effort]:[Estimation of Effort])

Shaine Greenwood

Hello,

To create summary rows with totals, you'll want to do the following:

Temporarily your sheet to grid or gantt view
Establish hierarchy by indenting child rows underneath a parent, more info on this in our help center: https://help.smartsheet.com/articles/504734-hierarchy-indenting-outdenting-rows
Create a SUM function that adds together your NPV children, e.g. placing this formula in the parent row: =SUM(CHILDREN())

More information on the SUM function here: https://help.smartsheet.com/function/sum

Sign in to join the conversation!

Quick Links

Trending discussions

Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…
How to Share Single Workspace Folder?
I have a workspace that I created with two subfolders. A user needs to have access to only one of them but when I have that folder selected, I can only share the entire workspace with them. Is there a secret way that I can share the parent folder and ensure that any new files created will be shared with the same people? I…
I have a Pro plan but I cannot create ANY reports
I have a Pro plan but I cannot create ANY reports. The system does not allow me to choose a folder, and consequently a sheet to create a row report and suggests an upgrade to Business or Enterprise. I'm quite new to Smartsheet and feel a bit disappointed with this limitation, or maybe I'm just doing something wrong. Alberto