Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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
Anyway we can make this view only for security purposes? We would like to prevent users from sending responses to other users by accident.
I am currently setting up an automation for people to get notified through their email, when they are prompted. But is there a way that they can reply in the email of a comment that will then go to the specific sheet. This way they do not have access to the sheet, but can just comment through email with updates?
I am extremely frustrated and disappointed with my current Smartsheet experience. I have paid for a Pro subscription, I am the owner and administrator of my account and sheets, and I have confirmed I am logged into the correct account. Despite this, Smartsheet is not recognizing my Pro subscription, and I am unable to…
