How to pull information from sheet A to sheet B based on a dropdown selection on sheet B

RDRGSJ00

I have two separate sheets. Sheet A contains job titles for a variety of different departments (Dept IDs). I need to pull all of the job titles from sheet A when a specific dept ID is selected in Sheet B's dropdown list. Any information will be greatly appreciated.

RDRGSJ00

Thank you jmyzk_cloudsmart_jp. It worked. I was able to pull information from one column based off of Dept ID and positions. Would it be possible to pull several columns instead of just one?

jmyzk_cloudsmart_jp

Hi @RDRGSJ00

I would use the COLLECT function to get titles from Sheet A's Title range with Sheet A's Department ID range as a criteria range and Sheet B's [Department ID]@row as a criteria.😁

Example:

=JOIN(COLLECT({Job Title}, {Department ID}, [Department ID]@row), ", ")

Please take a look at the demo dashboard below.

You can edit Sheet A's [Department Name: ID] dropdown list and add new data to Sheet B to check how the formulas work.

Smartsheet

https://app.smartsheet.com/b/publish?EQBCT=f2df029f734b4727a7f789b311b44fdb

RDRGSJ00

Thank you jmyzk_cloudsmart_jp. It worked. I was able to pull information from one column based off of Dept ID and positions. Would it be possible to pull several columns instead of just one?