Invalid Data Type, could it be the Month (@cell)
Hello,
In the sheet summary field (property is Text/Number) I am trying to sum invoice amounts (Column is called Amount) that are submitted each month (Column is called Invoice Date and is a Date column) using this formula but getting Invalid Data Type:
=SUMIF([Invoice Date]1:[Invoice Date]22, MONTH(@cell) = 4, [Amount]1:[Amount]22)
4 = April
What is also strange is the formula will somehow change to this:
=SUMIF([Invoice Date]1:[Invoice Date]22, MONTH(@cell) = 4, Amount1:Amount22)
Any help is much appreciated.
Answers
-
@lisa.bolger27646 When using the Month() function it requires a date like Month([Invoice Date]1). Trying using it with the example to see if it works, then you can use whichever column has the April date and should be good.
Regards - JC
-
Thank you Jeremy C! I'm getting closer. Not exactly sure how to work Invoice Date in with Month(@cell)
I understand that the month function sometimes gives errors. Would IFERROR help?
This formula below works!
=SUMIF(Invoice Date1:Invoice Date11, MONTH(@cell) = 2, Amount1:Amount11)
I would like the formula to look at the entire column and tried this, but it doesn't work:
=SUMIF(Invoice Date:Invoice Date, MONTH(@cell) = 2, Amount:Amount)
Any ideas? I know it's not too complicated but I'm stuck, appreciate your help!
-
Try something like this.
=SUMIF([Invoice Date]:[Invoice Date], IFERROR(MONTH(@cell),0) = 2, Amount:Amount)
Did that work?
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!