Sign in to join the conversation:
Hi,
I have 2 columns, one with a product description(Different products on a 1000 cells) and the other column it is their individual value. May you assist on how to get a sum of, say "shirts" only from the product description column?
Hi Tsholanang,
Try something like this.
Replace "Shirts" with what you want to SUM.
=SUMIF([Product Description]:[Product Description]; "Shirts"; [Individual Value]:[Individual Value])
The same version but with the below changes for your and others convenience.
=SUMIF([Product Description]:[Product Description], "Shirts", [Individual Value]:[Individual Value])
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Hi everyone, in several of my Details Views for multiple Dynamic Views, text fields and/or checkboxes that are configured in the Dynamic View settings are not appearing in the Detailed View. Is anyone else seeing this today? I've not updated any of my configurations lately and don't know how to explain this! Thanks!
The timeline widget has a toggle: Set the default hierarchy state. I am turning on "expand lanes by default." It seems regardless if I turn this "on", save, sign out, and sign back in, it automatically changes back to "off" when I log out. I have tried clearing my browser cache.
Can someone tell me how to get rid of the 120.0% max on this graph? It is always going total 100% and never any more, so I would like to use more of the space for graph display purposes. I even tried reducing it so that the largest value was 99.999%, thinking maybe being exactly 100 would cause the next "level" to…
