Update Formula based on another field

Options
firestorm
firestorm ✭✭✭
edited 04/16/21 in Formulas and Functions

Hello,

Is it possible to have formula referred to a text in another cell to refer to the column to be used in the formula?

Example: I have numbers of hours under each month column, against projects (e.g. ABC) in the rows. I have a metrics that sums up total numbers of hours per project for that month.

=SUMIF(Project:, "ABC", Jan:Jan)



Other than updating the Column reference in "Manage References", is there a way to have the formula easily updated for subsequent months? Can I insert the name of month somewhere to be used in the formula? Or any workaround?

Thanks.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!