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())))

Find more posts tagged with

functionality

Sheet Summary

help

References

Accepted answers

All comments

MichaelTCA

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"?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.