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

IF {Status} is "X" or "XX" and {Date} is in the coming 90 days
Hello, In the formula below I am asking if the status in a reference sheet is "Pending Submission" or "Pending Approval" then display "No" in a symbol column. I would be very grateful for any best practice on how to structure the formula to add in if {status} is "Pending Submission" or "Pending Approval" and a {Date…
Multiple Selection in drop down or buttons on forms
There should be a way to select multiple options on a form when choosing from a list.
Duplicate Rich Text Widgets to another dashboard
Hi, We have a project that has a SS dashboard with all the updates ("Master Dashboard"). We have another dashboard that would duplicate some of the RT widgets from the Master Dashboard. How can we do this automatically? Trying to avoid duplicated efforts for the same exact content. The content has some rich formatting, so…

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