Show Last Month of a Quarter

Lisi

Hello,

I have a column that has the quarter, like Q1, Q2, Q3, and Q4. Now I'm trying to show the last month of that quarter on a new column. I tried to use IF([Refresh Eligible Quarter]@row) = Q1, "March") but it doesn't work.

Any idea?

Thanks!

 

Paul Newcome

Put Q1 in quotes in your formula.

 

=IF([Refresh Eligible Quarter]@row) = "Q1", "March") 

Lisi

Hi, thank you! When I do that I get #UNPARSEABLE for some reason.

 

Paul Newcome

Could you have accidentally included the comma or equals sign in the quotes?

 

Can you provide a screenshot of the formula in the sheet?

Lisi

Sure, I have attached it. 

 

 

Andrée Starå

Remove the parenthesis after @row and then it should work.

Did it?

Best,

Andrée

Lisi

What a foolish mistake!!!

 

Thank you 

Andrée Starå

Easy to miss! We've all been there and will be again