Is it possible to reference the column name (Heading) in a formula?

I'm creating an invoicing schedule and so my primary column is a list of tasks and then I have columns for past, current and future months: Dec-20, Jan-21, Feb-21, Mar-21, Apr-21 etc. In the cells I enter a monetary value which is the amount we either have invoiced or plan to invoice.

I want to have a column (Invoiced to Date) which adds up the invoicing amounts in a row, but does not include the current month or beyond, but cannot find a way to reference the actual column name. Is this possible?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!