Formula calculating revenue for Q2

steve50951 ✭✭
edited 12/09/19 in Formulas and Functions

I am trying to calculate revenue for Q2 only for a given property

Here's what i had in the cell

=SUMIFS({Garden Grove Bill Rate}, {Garden Grove Inv Date}, YEAR(@cell) = YEAR(TODAY()), {Garden Grove Inv Date}, MONTH(@cell) > 3).

But that formula doesnt work now that we are in july. as it calculates july revenue as well.

So this is what i changed it to

=SUMIFS({Creekwood Apartments Bill Rate}, {Creekwood Apartments Inv Date}, YEAR(@cell) = YEAR(TODAY()), {Creekwood Apartments Inv Date}, MONTH(@cell) > 3, {Creekwood Apartments Inv Date}, MONTH(@cell) < 7)

Just wandering if there is an easier way, other than adding another @row reference. Can i use a date range with an @row reference that would express months 3-6?






Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!