Help w/ Sumif date is before today
Hi,
Hitting a snag w/ a very basic sumif. I need to sum the total capital investment column if it's corresponding date value falls before or on today's date. Here's the formula I have now:
=SUMIF([Fiscal Month End]1:[Fiscal Month End]12, <=TODAY(), [Actual Capital Investment]1:[Actual Capital Investment]12)
And a screenshot:
The formula is currently returning $0 and but should be summing the Actual capital investment to $1,606,566.5. I've tried flipping the >= but am getting $0 both ways. Any pointers?
Best Answer
-
Your formula looks good! But is your "Fiscal Month End" formatted as a date column? It looks like a text (should have the leading 0's for the months). Double click on the header to change it to a Date type column and you should be good to go!
Jason Tarpinian - Sevan Technology
Smartsheet Aligned Partner
Answers
-
Your formula looks good! But is your "Fiscal Month End" formatted as a date column? It looks like a text (should have the leading 0's for the months). Double click on the header to change it to a Date type column and you should be good to go!
Jason Tarpinian - Sevan Technology
Smartsheet Aligned Partner
-
Wow, thank you! Always forget to check the date formatting!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 377 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!