Formula previously working (along with others) and not now

Hi all
I have this formula in one of the summary sections for tracking the SLA of job completions as part of a number of others, mainly for the creation of graphs and percentages etc and a lot of them seem to have stopped working. They now say #INCORRECT ARGUMENT SET. None of the references have changed and I'm so confused as I need to fix it all for some customer presentations of their stats
=SUM([Missed SLA This Year (This Sheet)]#, COUNTIFS({IT Ticket Tracking SLA Days}, <0, [Year Reference]:[Year Reference], YEAR(TODAY())), COUNTIFS({IT Ticket Tracking Resolved}, "", {IT Ticket Tracking Deadline}, <TODAY(), [Year Reference]:[Year Reference], YEAR(TODAY())))
Answers
-
Hello @OliC
Try breaking it up into a couple functions and see if each section works.
I would recommend investigating broken references and incorrect column properties.
You mention Summary Section. Does this mean it's a section of a "Sheet" that you have designated as the summary or are you using a "Summary Report"?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 150 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 500 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!