Count by Quarter, in Current Year, if "published" status

Options
Jessica Griffin
Jessica Griffin ✭✭✭✭
edited 08/25/21 in Formulas and Functions

I am attempting to create a metric that counts a line item based on a published date, but I want the count to be by current year quarter.

Using "Date Published"

Completed Policies (current year) Tracked by Published 'Date'

Q1 #UNPARSEABLE

Q2

Q3

Q4


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!