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; } } }

Welcome!

Calculate the total amount base on status

richard_uy

Hi,

As per attached screenshot, how can i calculate the total amount when status in RED?

Screen Shot 2018-03-07 at 11.00.53 AM.png

Find more posts tagged with

Comments

Tukee

Sorry first attempt was wrong. I think you need a hidden column where you place a simple IF statement that grabs the value IF the Status="Red" , else it drops in a 0 then you can just add them up with a =SUM and then copy that over to the origin column. =IF(Status3 = "Red", [down payment]3, 0).

In my image below you then sum the HIDEME column and in the payment column just grab the value from the hidden column. There's surely a slicker way to do it but will work quickly and easily.

Hideme formula: =IF(Status3 = "Red", payment3, 0)

Hideme column formula: =SUM(hideme3:hideme6)

Payment column formula: =hideme8

Mike Wilday

You can also use a Sumif formula.

=Sumif(status:status, "Red", payment:payment)

Would sum all of the payment cells where Red was in the status cell. No need to add hidden columns. Hope that helps!

https://help.smartsheet.com/function/sumif

Tukee

Way better solution thanks for the education Mike.

Mike Wilday

Not a problem. Glad I could help!

richard_uy

It work. thank you Mike.

Sign in to join the conversation!

Quick Links

Trending discussions

"Fields marked with an asterisk (*) are required." line on every form.
Hi, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
Dynamic View Issue - Group Sharing
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…