How to reference the name of a column in a formula?

I want to create a column formula that will sum all columns in a range only if the column's name contains the word "ACTUAL" ? Is this possible? I can't find any functions that do this and I tried doing look ups for row #0 or row #-1 which sometimes works in other systems to reference table headers.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!