Date Formula

americansurveymanagement35236

I looking for help on a formula that will SUM the column by month. So when I go into a new month, it will sum only the month we are in since the column represents all months of the year. I have a supporting value and formula sheet that host these values and are linked to my dashboard. I currently have to edit reference the fields to select the cells in the present month. I have attached an image of the columns in question. Any help in this matter will greatly be appreciated. 

Mike Wilday

Hi there, 

You can accomplish this using a SUMIFS statement. Try this formula

=SUMIFS(Fee:Fee, [Date Approved]:[Date Approved], MONTH(@cell) = MONTH(TODAY()), [Date Approved]:[Date Approved], YEAR(@cell) = YEAR(TODAY()))

It will look at the month and year of today and provide you with the sum value of all of the fees of the current month/day. 

If you want to manually input the year and Month you can use this one... This would be good for summary data for each month. 

=SUMIFS(Fee:Fee, [Date Approved]:[Date Approved], MONTH(@cell) = 3, [Date Approved]:[Date Approved], YEAR(@cell) = 2018)

Replace the 3 with the month you want and the year with the year you want. 

Hope that helps! 

https://help.smartsheet.com/function/sumifs

americansurveymanagement35236

Thank you  Mike, the formula worked perfect for my situation. 

Mike Wilday

Awesome. Glad I could be of help!