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 setup an automated workflow to notify users via notification email once their requests have been fulfilled. I've configured the workflow to trigger a completed notification email to the requestor based on the email in the Requester Email Address column after I've changed the status to Complete in the Request Status…
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.…