I am trying to tally a column by month
=SUMIF([End Date]:[End Date], MONTH(@cell) = 4, Pricing:Pricing)
Trying to tally my pricing column if the 'end date' column is within the month of April.
I am getting "INVALID DATA TYPE"
@Paul Newcome - I have found your answers to other helpful in the past
Answers
-
I figured it out for anyone who might need it in the future
=SUMIFS(Pricing:Pricing, [End Date]:[End Date], AND(IFERROR(MONTH(@cell), 0) = 4, IFERROR(YEAR(@cell), 0) = 2022))
-
Thanks for posting your solution! 🙂
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 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
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!