Sign in to join the conversation:
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.
Still looking for documentation, but I am curious about the limitations with the dropdown linking in Table View. Does a person need to have access to the dropdown source sheet in order for the dropdowns to populate on the Table sheet?
I want to add a calendar to my team's dashboard that shows both Anniversaries and Birthdays every year. I have the following columns: Team member Date (date of anniversary and birthday) Anniversary column to show this year's date (formula) Birthday column to show this year's date (formula) When I go into calendar mode, I…
I’m not sure if this has already been asked here or if there’s an existing Enhancement Request, but: is there any way to apply conditional formatting to multiple widgets in a dashboard at once? I have a large number of widgets, and applying conditional formatting individually to each one is very time‑consuming. Ideally,…
