calculate average with criteria

Sven Krohn

Sven Krohn ✭✭

02/14/22 in Smartsheet Basics

a big thank you to everyone who supported me here in the past. Due to my great experience, I would like to ask another question.

lets say I have the following:

Now I would like SmS to

calculate the average for New York only
calculate the average for all other cities combined
state: The average sales in New York: xxx
(="The average sales in New York: " + ??)
Plus: the result should not have more than 2 post decimal digits.

I guess I need a summary formula. something like "if location = "new york", avg sales ...

Thanks!!

0 ·

Answers

Neil Watson ✭✭✭✭✭✭

02/14/22

Hi @Sven Krohn, have you tried the averageif formula?

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Possible to use a Smartsheet form as a formmail/sendmail?
My group has a need for a formmail/sendmail-type option, and I'm not sure if Smartsheet forms can be customized to do this. Need to be able to use a form to: Send emails with a return address from our team mailbox (not from automation@app.smartsheet.com) Specify a recipient for each form submitted Send to multiple…
Report does not display sheet dates or dropdown menu items
Hi there, I used the "Project Management Office" template to set up different projects and then a report that pulls the information from all the projects into a central report document. I have noted that if you have drop-down options in your original sheets, or dates, these are not displaying in the report. How do I…
Is there a way to merge user groups?
Two teams at my company have recently merged into one, and I was wondering if there's an easy way to merge their Smartsheet user groups into one group. I don't see a "merge" option available in the Group Management portal.

Help shape the future of Smartsheet.
Share your ideas and feature requests.