Hi,
As per attached screenshot, how can i calculate the total amount when status in RED?
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
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
Way better solution thanks for the education Mike.
Not a problem. Glad I could help!
It work. thank you Mike.
My co-worker had to recreate one of our admin scheets, so I was hoping I could create a workflow that could copy the ENTIRE sheet, not just relevant rows. This sheet would then "overwrite" the previous copy we have in our current back-up folder. Is this possible? I didn't find an existing workflow, only creating something…
I am trying to create dependencies on my timeline for a construction schedule and when I try to connect certain line items I get an error of INVALID TASK. Its not on all the line items but I cant seem to fix it or figure it out and my whole schedule doesn't work without putting these task into the right dependency order.…
Is there any way around the 100 item limit when using" save-as-new". I built a large reporting and dashboard structure with hundreds of individual reports and aggregate dashboards. The reporting structure is for a state agency that contracts with many partners, so lots of reports and dashboards for each individual partner.…
