Sigma Community

Counting Values From This Month

Sigma Formulas and Functions

ztrean September 23, 2020, 10:00pm #1

Is it possible to create a formula where I can refer to a date using “this month” or “this week”? In other words: countif([date field] = “This Month”

Ryan September 23, 2020, 10:01pm #2

Hey Zachary!

Yes, I believe this formula should work for you!
CountIf(DateTrunc(“month”, [date field]) = DateTrunc(“month”, Today()))

system automatically bumped October 18, 2020, 4:30pm #3

system automatically bumped November 2, 2020, 5:58am #4

system automatically bumped November 21, 2020, 6:59pm #5

system automatically bumped December 10, 2020, 9:45pm #6

system automatically bumped December 30, 2020, 2:19pm #7

system automatically bumped January 19, 2021, 6:44pm #8

system automatically bumped February 9, 2021, 1:14pm #9

system automatically bumped March 2, 2021, 5:40pm #10

system automatically bumped March 24, 2021, 3:33am #11

system automatically bumped April 14, 2021, 5:30pm #12

system automatically bumped May 6, 2021, 12:31pm #13

system automatically bumped May 28, 2021, 1:44pm #14

system automatically bumped June 20, 2021, 5:42am #15

system automatically bumped July 13, 2021, 1:57am #16

system automatically bumped August 4, 2021, 1:50pm #17

system automatically bumped August 27, 2021, 3:25pm #18

system automatically bumped September 20, 2021, 2:33am #19

system automatically bumped October 13, 2021, 6:44pm #20