Update Formula based on another field

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


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?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!