Grouping by Quarter

[Lisa_Wade]

I am working on a recall list by quarter. I am having trouble with figuring out a formula that will group the recall date by quarter but only if the status is “active”. Can someone help? I just can’t figure this out. Thank you all very much!

[Tim_Sullivan]

This will help you with your quarter calculations:

Date formula to show only the quarter and year Formulas

Welcome to the community, @Roger_L! You could just use the DATETIME_FORMAT function to call the quarter & year like this: IF({Your Date Field}, "Q" & DATETIME_FORMAT({Your Date Field},'Q/YYYY') ) Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slight_smile: