Formula for Quarter & Year

I'm trying to pull the quarter & year from a column using a formula, but I keep getting "unparseable". I've searched through the community with no success using the answers found. I'm pulling data from my "Expected Close Date" column. Below is an example of a formula used. Any help is greatly appreciated.

=IF(OR(MONTH([Expected Close Date]@row) = 01, MONTH([Expected Close Date]@row) = 02, MONTH([Expected Close Date]@row) = 03)), "Q1 ", IF(OR(MONTH([Expected Close Date]@row) = 04, MONTH([Expected Close Date]@row) = 05, MONTH([Expected Close Date]@row) = 06)), "Q2 ", IF(OR(MONTH([Expected Close Date]@row) = 07, MONTH([Expected Close Date]@row) = 08, MONTH([Expected Close Date]@row) = 09)), "Q3 ", IF(OR(MONTH([Expected Close Date]@row) = 10, MONTH([Expected Close Date]@row) = 11, MONTH([Expected Close Date]@row) = 12)), "Q4 ")))) + YEAR([Expected Close Date]@row)

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!