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
I am trying to create a Form that requires the user to supply information related to any item existing in the Primary Column. If I pull that existing field into my form, the user entry is a free-form field and I can't figure out how to restrict it (other than validating by data types). If I add a new field with a dropdown…
Is it possible to display both the planned and actual duration for a single task on a Smartsheet Gantt chart? I would like the Gantt bar to show the planned duration (e.g., in blue) based on a Planned End Date column, and then show the actual duration (e.g., in green) based on an Actual End Date column. Can the Gantt view…
I noticed in the Board View tags are grey by default but in the how to videos, in the Board View some of the tags are colorful. I'd like to leverage that same functionality as I'm building a research repository with many different types of research in it and a visual cue would be lovely. Can anyone assist? I attached a…