Can I extract the name of a column and use it in a formula?

Options

I have a table set up with data organized by quarter (3W20, 4Q20, 1Q21, etc), and am using the quarters as the names of the columns. I have formulas in the columns that display data for that quarter, but I've had to manually type in things like "3Q20" in my SUMIFS formula for one of the criteria. Is there a way to pull out the name of the column, and have it entered in the appropriate cells?

Thanks,

Dennis

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!