How to add a value from any row that has column = May


This sheet (displayed to users as cards) moves projects to different months for capacity planning. We then have a header task for each month which we display the total job value currently assigned to the month.

This value is currently manually calculated.

How/can we have a formula in the header task that sums all the $ fields from rows that have the matching month value?

This way when we move the cards around the totals will update

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!