Formula for quarter based on finish date

Becca Grube
Becca Grube ✭✭
edited 01/14/21 in Formulas and Functions

I want to create a formula that will auto-populate the Quarter column with Q1, Q2, Q3, or Q4 based on the date entered in the "Finish Date" column. For instance, if the "Finish Date" is 4/15/2021, I want the Quarter to be "Q2".



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!