Can't work out why I am getting an UNPARSEABLE error message please help

All I need is the correct return according to the Probability and Impact criteria in screenshot 1 into my Risk log in screenshot 2

Screenshot 1

=INDEX(COLLECT({Risk Management Matrix Range 1}, {Risk Management Matrix Range 2}, Probability@row), {Risk Management Matrix Range 3},Impact@row),1)

Find more posts tagged with

Formulas

Project Management

Accepted answers

All comments

Jeff Reisman

@Paul Allen Try these fixes:

Paul Allen

@Jeff Reisman thanks for getting back to me but still no joy :(

Just as a check and balance this is what I have now further to your advice but the #UNPARSEABLE error still remains

=INDEX(COLLECT({Risk Management Matrix Range 1}, {Risk Management Matrix Range 2}, Probability@row, {Risk Management Matrix Range 3}, Impact@row), 1))

...the quest continues

Paul Allen

@Jeff Reisman OK so I cleared all references from the scoring matrix and started agin and hey presto it worked so thank you so much.

Paul Allen

@Jeff Reisman OK so I cleared all references from the scoring matrix and started agin and hey presto it worked so thank you so much.

Paul Allen

@Jeff Reisman OK so I cleared all references from the scoring matrix and started agin and hey presto it worked so thank you so much.

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.