nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Welcome!

Summary Row Card View

john.harder42361

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

Unread conversation indicators (red dots) do not clear after reading conversations
I am using Smartsheet on an Individual (Pro) plan. The red unread conversation indicators on rows no longer clear after I open and read the row conversations. I have already tried: Opening every conversation and scrolling through all comments. Using Mark all as read. Refreshing the sheet. Hard refresh (Ctrl + F5). Testing…
Hide menus on published sheets
I have created an educational tool for our study teams to guide them in meeting Clinical Trial Transparency Best Practices. I've confirmed that I can publish a sheet with all columns and rows locked except for one cell. This cell has a dropdown column that is updated nightly via a data shuttle. People with access to this…
Common Notification Errors
I have two sheets that use the exact same workflow: Trigger: When rows added/changed When checkbox - checked Send to contact in a cell Then record date In one sheet the workflow works as intended. In the other, the workflow appears to work (date is recorded) but no notification is received. I have already confirmed that…