Displaying %Complete Column on Metrics Sheet

Hello! My coworker and I think we are close to figuring out this formula on our Metrics Sheet but we keep receiving the "Incorrect Argument Set" message. Here's the formula in the screenshot:

=INDEX(COLLECT({Per Complete}, {P2H Task}, $Reference@row , {Milestone}, 1))

{Per Complete} = the %Complete column in the source sheet. This column is using hierarchy and formulas to average the % complete of each child row to display a % complete of each parent row.

{P2H Task} = the specific task name from the source sheet that matches the $Reference@row

{Milestone} = a checkbox row on the source sheet that is true/checked because it's a parent row.

Thank you in advance for any insights you can provide!

Find more posts tagged with

Formulas

Accepted answers

All comments

DKazatsky2

Hi @bnichols,

You are getting that message because you are missing the final argument for the Index function. Add ",1" between the 2 closing parens and see if that settles it.

Hope this helps,

Dave

bnichols

Hey, Dave! Thanks for the response. We gave this a shot and now we're getting the "UNPARSEABLE" error message. We already have , 1 included at the end of our original formula, so we tried placing between the parathesis instead like you said both with and without quotation marks with no luck. Any other ideas?

DKazatsky2

Hi @bnichols,

Try adding what I suggested while also keeping the ",1" as it was in the original formula.

=INDEX(COLLECT({Per Complete},{P2H Task},$Reference@row,{Milestone},1),1)

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.