INDEX COLLECT Formula Help

Good afternoon!

I have the following formula written to index collect a number from my master sheet and I am utilizing 2 sheets as references in the formula:

=INDEX(COLLECT({PSTrax SR #}, {PST Station #}, [ASSIGNED TO]@row, {PST Issue}, Issue@row, {PST Problem Type}, [Issue Helper]@row, {PSTrax Type Master}, TYPE@row, {PST Open Date}, >=DATE(2023, 1, 1), {PST Open Date}, <=DATE(2023, 2, 1))), 1)

It is coming back #UNPARSEABLE. I tried adding =IF([ASSIGN TO]@row, 1, to the front of the formula, but it only returns a 1. Help?

Thank you in advance!

Find more posts tagged with

Accepted answers

All comments

Samuel Mueller

@Michelle Fayed Never mind I think I understand. I think you may have to add a manual process to choose the PM type on the Master Services request.

you could make a report filtered to if Problem Type is Blank, and include the columns you would need to determine what the problem type should be, then as you fill them out your list gets smaller.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.