I'm trying to grab name from a row on a separate sheet where the row matches two criteria.
I'm trying to grab a name from a row on a separate sheet where the row contains "Completed" and the same part number.
Here is the equation I'm attempting to use but get "UNPARSEABLE"
=INDEX({Employee Name Column}, COLLECT({Employee Name Column}, {Part Number Column}, [Part Number]@row, {Part Complete? Column}, "Completed"))
1st Page Below is where the equation originates.
Second Page is where I'm trying to match the part number to the first page and populate completed by with the employee who completed the part.
Ideally I would be able to add multiple names if two employees completed the same part.
Thanks
Best Answer
-
Hi @Christian Graf
Hope you are fine, please try the following formula and convert it to column format formula:
=IFERROR(JOIN(COLLECT({Employee Name Column}, {Part Number Column}, [Part Number]@row, {Part Complete? Column}, "Completed"), " / "), "")
Data Sheet Screenshot
Formula Sheet Screenshot
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Answers
-
Hi @Christian Graf
Hope you are fine, please try the following formula and convert it to column format formula:
=IFERROR(JOIN(COLLECT({Employee Name Column}, {Part Number Column}, [Part Number]@row, {Part Complete? Column}, "Completed"), " / "), "")
Data Sheet Screenshot
Formula Sheet Screenshot
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
-
Excellent, I will be happy to help you anytime
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!