Ashley,
The root cause of the problem is that you have hard coded your projections into fixed fields as opposed to a child table of Monthly Projections. I know that tis may not be the answer that you want to hear, but I suggest That you consider a change to the structure of your app.
In Quick Base anytime you fInd yourself creating dozens or even a few very similar fields it should "feel wrong" and you should re-think the data base design.
------------------------------
Mark Shnier (YQC)
markshnier2@gmail.com
------------------------------
