Index Collect Question
I am trying to use Index Collect for the following - and I am stuck :-)
In the column "Validation NL" (upper table) I like to display the value of the column "Jira Status" if
- the value in the column "Epic" = "GBT-704"
- the value in the column "Req ID" matches the value in the column "MMP ID"
This is the formula I tried but it returns and #Incorrect Argument:
=INDEX({Jira MMP's Validation Results - Jira Status}, COLLECT("GBT-704", {Jira MMP's Validation Results - Epic}, [Req ID]@row, {Jira MMP's Validation Results - MMP ID}, 0))
This formula I tried and it returns #Unparseable
=INDEX(Collect({Jira MMP's Validation Results - Jira Status},{Jira MMP's Validation Results - Epic},"GBT-704"), Match([Req ID]@Row, {Jira MMP's Validation Results - MMP ID},0))
I am at the ends of my wits 🧐
Thank you for your ideas!
SYLVIA KAY | DIRECTOR PROJECT MANAGEMENT
PLATFORM ENGINEERING & TECHNOLOGY TEAM
AMERICAN EXPRESS GLOBAL BUSINESS TRAVEL
M: 404-664- 1025 | SYLVIA.KAY@AMEXGBT.COM
follow us on twitter: @AmexGBT
follow us on instagram: @AmexGBT
Best Answer
-
Hi Sylvia,
Go ahead and try this formula
=INDEX(COLLECT({Jira MMP's Validation Results - Jira Status}, {Jira MMP's Validation Results - Epic}, "GBT-704", {Jira MMP's Validation Results - MMP ID}, [Req ID]@row), 1)
Answers
-
Hi Sylvia,
Go ahead and try this formula
=INDEX(COLLECT({Jira MMP's Validation Results - Jira Status}, {Jira MMP's Validation Results - Epic}, "GBT-704", {Jira MMP's Validation Results - MMP ID}, [Req ID]@row), 1)
-
Aww, thank you so much, but it also returns an error.
SYLVIA KAY | DIRECTOR PROJECT MANAGEMENT
PLATFORM ENGINEERING & TECHNOLOGY TEAM
AMERICAN EXPRESS GLOBAL BUSINESS TRAVEL
M: 404-664- 1025 | SYLVIA.KAY@AMEXGBT.COM
follow us on twitter: @AmexGBT
follow us on instagram: @AmexGBT
-
@Sylvia Kay dis you resolve?
If my comment helps you, I appreciate a 💡
Kind regards
Event: Strategies for Successful Adaption
Nico | LinkedIn
CEO | Lighthouse Consultings
Lecturer in Business Information Systems | DHBW
________________________________________________________________________________
addvalue@lighthouseconsultings.com
https://www.eventbrite.de/e/driving-change-with-smartsheet-strategies-for-successful-adoption-tickets-1047813557557?utm-campaign=social&utm-content=attendeeshare&utm-medium=discovery&utm-term=listing&utm-source=cp&aff=ebdsshcopyurlWe offer Licenses - Training - Solution Engineering
🔴Certified Smartsheet Partner _______________________________________________
💯 SCALEABLE Solutions Engineered by Lighthouse Consultings
We Don’t Just Implement Smartsheet; We Revolutionize How You Manage, Plan, And Execute.
-
@Sylvia Kay Exactly what error message are you getting?
-
Hi Paul, my mistake: The formula works! Thank you so very much!!!!
SYLVIA KAY | DIRECTOR PROJECT MANAGEMENT
PLATFORM ENGINEERING & TECHNOLOGY TEAM
AMERICAN EXPRESS GLOBAL BUSINESS TRAVEL
M: 404-664- 1025 | SYLVIA.KAY@AMEXGBT.COM
follow us on twitter: @AmexGBT
follow us on instagram: @AmexGBT
-
SYLVIA KAY | DIRECTOR PROJECT MANAGEMENT
PLATFORM ENGINEERING & TECHNOLOGY TEAM
AMERICAN EXPRESS GLOBAL BUSINESS TRAVEL
M: 404-664- 1025 | SYLVIA.KAY@AMEXGBT.COM
follow us on twitter: @AmexGBT
follow us on instagram: @AmexGBT
-
Thank you soo much
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!