Days Since Tickets Were Created

RingJake ✭✭✭✭✭
edited 08/25/22 in Smartsheet Basics


I need some help with this formula, I am trying to create a datasheet that can pull in tickets from another grid & tell me how many tickets were opened within these timeframes.

30 days ago, 31 - 90 days ago, 91 - 180 days ago over 181 days ago.

I've done similar formulas with this for finding things between dates, but having trouble putting this together. Would appreciate if someone can help and take a look at this?

=COUNTIFS(AND({Priority}, Critical1, TODAY(30){Creation Date} ))