Editing Formula
Hello,
I have a formula that calculates the current month's total of an item. I need a new one that will filter by a specific month/year when edited to do so. How do I update this to do that?
=SUMIFS(Spent:Spent, [Areas of Project Spending]:[Areas of Project Spending], @cell = PERSONNEL@row, [Expense Date]:[Expense Date], AND(IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), IFERROR(YEAR(@cell), 0) = YEAR(TODAY())))
I tried a few variations of editing for just the specific month (Nov) but getting #UNPARSABLE - sample:
=SUMIFS(Spent:Spent, [Areas of Project Spending]:[Areas of Project Spending], @cell = PERSONNEL@row, [Expense Date]:[Expense Date], AND(IFERROR(MONTH(@cell), 0)=11), IFERROR(YEAR(@cell), 0) = YEAR(TODAY())))
Thankyou as always for the help!
Angela
Answers
-
I just wrote this and it worked.
=SUMIFS(Spent:Spent, [Areas of Project Spending]:[Areas of Project Spending], @cell = PERSONEL@row, [Expense Date]:[Expense Date], AND(IFERROR(MONTH(@cell), 0) = 11, IFERROR(YEAR(@cell), 0) = YEAR(TODAY())))
I then spent an embarrassing amount of time trying to spot the difference. 😭
It was a parenthesis left over from removing MONTH(TODAY())
This one (in bold) 😠
=SUMIFS(Spent:Spent, [Areas of Project Spending]:[Areas of Project Spending], @cell = PERSONNEL@row, [Expense Date]:[Expense Date], AND(IFERROR(MONTH(@cell), 0)=11), IFERROR(YEAR(@cell), 0) = YEAR(TODAY())))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!