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! 🙂
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 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!