Additional Criteria - SUMIFS
Hi Everyone,
We are achieving to create a new adjustment in our visualization that will allow us to automatically calculate the total numbers of FTE per month drilled down to Status. Needing someone to correct my formula as it returns an error on my end.
Formula 1 for In Progress
SUMIFS({FTE}, {DateReceived}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2021), {OverallStatus}, "In Progress")
Formula 2 for Completed
SUMIFS({FTE}, {DateReceived}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2021), {OverallStatus}, "Done")
Answers
-
What error are you getting?
-
It looks like you might just be missing the closing parentheses for the AND statement:
AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2021)) < this one
Try adding these in:
Formula 1 for In Progress
SUMIFS({FTE}, {DateReceived}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2021)), {OverallStatus}, "In Progress")
Formula 2 for Completed
SUMIFS({FTE}, {DateReceived}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2021)), {OverallStatus}, "Done")
Let me know if this works!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Ignore me!! Paul pointed out that your AND statement is actually closed.
Since the structure is correct, can you identify each of the columns you're referencing and what type they are?
{FTE},
{DateReceived}
{OverallStatus}
And yes, it would be helpful to know exactly what error you're receiving.
Thanks!
Genevieve
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.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 67 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!