Adding Months and Placing Data in a Month Column

Samuel Dowdy Jr.

Sheet --> https://app.smartsheet.com/sheets/Rp5CHm6mFGcw2CG7x8rFjmfGwVpG394xffJw2x91

I really need some help placing data throughout this sheet by using formulas. I know what I want but I dont know the formulas.

I want the total monthly payout to be spread out into the monthly columns once the payout dates are entered. Can anyone help me?

Sean Morgan

Hello @Samuel Dowdy Jr ,

As your sheet is not published, we are unable to see the data within the sheet. If possible, please can you share a screenshot(s) of your sheet and I'll try suggest some best practices with regards to formulas.

It sounds like you want to use a SUMIF or SUMIFS formula as seen here: https://help.smartsheet.com/function/sumifs

Furthermore, there are a few date based SUMIF/S formulas that others have worked on that may provide some guidance for what you are trying to achieve:

https://community.smartsheet.com/discussion/68088/sumifs-formula-help-needed-please

https://community.smartsheet.com/discussion/65588/date-and-sumif-or-sumifs-formula

Kindest Regards

Sean