Issues with syntax in my formula- help!

lucybattaglene

Hey brains trust. I'm having issues getting my column formula to 'stick'. Can you see what I'm doing wrong?

My sheet lets me have this as a cell formula and happily works when I manually copy it into cells below but it gives me an error message when I try to set it as the offical Column Formula

any ideas?

Paul H

@lucybattaglene

="Q" + INT((MONTH([Start Date]@row) + 2) / 3) + " - " + YEAR([Start Date]@row)

Paul H

@lucybattaglene

="Q" + INT((MONTH([Start Date]@row) + 2) / 3) + " - " + YEAR([Start Date]@row)

lucybattaglene

Amazing! ugh I feel like an idiot. Thanks!