Formula per month

Marilen.Navarro103391 ✭✭✭✭✭

10/09/22 in Formulas and Functions

Hello,

Can you help me with the formula? When I do the formula below there's no value in column.

I add a helper on the last column Named "Month"

I want to get the total of all Contracts processed per month. Thanks

0 · Share on FacebookShare on Twitter

Sign in

Try for free

Best Answer

• 

  Paul Newcome Community Champion

  10/12/22 Answer ✓

  Right. So put the number 1 in the January column in the row that contains "Donna". You would then put 2 in the February column, 3 in the March column, so on and so forth.

  CERTIFIED SMARTSHEET PLATINUM PARTNER

  10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)

  Would you benefit from getting my help in person?

  0 · Share on FacebookShare on Twitter

Answers

• 

  Paul Newcome Community Champion

  10/10/22

  It looks like the January$1 cell is blank. Try putting the number one in that cell.

  CERTIFIED SMARTSHEET PLATINUM PARTNER

  10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)

  Would you benefit from getting my help in person?

  0 · Share on FacebookShare on Twitter
• 

  Marilen.Navarro103391 ✭✭✭✭✭

  10/12/22

  
  

  @Paul Newcome

  I have Zero value. My formula is below, I need to have the sum and simply drag the cell up to December formula. Thanks.

  

  
  

  0 · Share on FacebookShare on Twitter
• 

  Paul Newcome Community Champion

  10/12/22 Answer ✓

  Right. So put the number 1 in the January column in the row that contains "Donna". You would then put 2 in the February column, 3 in the March column, so on and so forth.

  CERTIFIED SMARTSHEET PLATINUM PARTNER

  10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)

  Would you benefit from getting my help in person?

  0 · Share on FacebookShare on Twitter
• 

  Marilen.Navarro103391 ✭✭✭✭✭

  10/12/22

  Thanks Paul. It works.

  0 · Share on FacebookShare on Twitter
• 

  Paul Newcome Community Champion

  10/13/22

  Happy to help. 👍️

  CERTIFIED SMARTSHEET PLATINUM PARTNER

  10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)

  Would you benefit from getting my help in person?

  0 · Share on FacebookShare on Twitter

Sign in

Try for free

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list