Formula Help!!!!! PLEASE

Brian_Anderson_AMR

I have a data set with a bunch of dates

09/03/19

09/04/19

08/19/19

07/01/19

You get the idea....

Im trying to get a count of "incidents" by month... but I cant get the formula to work!!!

July = 10

Ive tried... (below) and many others...

=COUNTIF({(NEW) Support Request (USER) Range 10}, MONTH({(NEW) Support Request (USER) Range 10}}7))

#Unparseable

=SUMIF({(NEW) Support Request (USER) Range 10}, MONTH({(NEW) Support Request (USER) Range 10}7))

#Unparseable

Find more posts tagged with

Formulas

Project Management

Comments

Mike Wilday

=COUNTIF({(NEW) Support Request (USER) Range 10}, MONTH({(NEW) Support Request (USER) Range 10}) = 7))

Give this slight modification a try.

Paul Newcome

You don't want to look at the MONTH for the ENTIRE range as a whole. You want to look at the entire range yes, but on an individual cell by cell basis.

=SUMIF({(NEW) Support Request (USER) Range 10}, MONTH(@cell) = 7)

Sign in to join the conversation!

Quick Links

Trending discussions

How to split contents from a cell from a smartsheet into another smartsheet
I need to extract and split the contents of a cell in a Smartsheet into three separate columns to a new smartsheet. The cell entries are originally submitted through a form.
Information in a form populates specific cell.
Hello, Just investigating an idea. I'm building a staff register sheet. I'm curious to know if its possible to populate specific cells by the answers given in a form? So if, in a form, a staff member gives their name, the date and that they will be on leave, sick, training ect. Once the form is submitted, it will populate…
A multiple SUMIF function
My current formula is below. I would like to update this so that I only get a total of those that have been Quoted and have a timeframe data of 2025. How do I add this extra filter into the formula? =SUMIF(Status:Status, "Quoted", [Est. GP]:[Est. GP])