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

Screenshot_20210514-194117_Smartsheet~2.jpg


Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!