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

edited 09/08/23 in Smartsheet Basics

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.

Best Answer

  • RDRGSJ00
    RDRGSJ00 ✭✭
    Answer ✓

    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?