Best Of

Glad it helped!

(I literally asked my co-worker the same question 2 weeks ago so it was fresh on the brain) :)

I have followed the instructions here:

But, I don't get a "who" option when building a report. How can I dynamically adjust a report to show tasks for the logged in user?

thanks in advance

For people curious about how to approach this using Data Shuttle, here's something that worked for me after experimenting with the stuff I was reading in these forms.

You will need to create two automations, one Offload Automation and one Upload Automation:

Start with the Offload Automation:

1. In the Source step, start by selecting the sheet that contains the column values for which you looking to create a dynamic list.
2. Then in the Target step, select "Smartsheet Attachment" followed by the same worksheet as step one. Choose whatever name you would like for the title, and choose CSV (Include headers if you want, you'll just have to remember they are present in the file)
3. In the next step, apply Filters if needed. I just left this field blank.
4. in the Mapping section, I removed all columns besides the one that was meant to populate the Dynamic Dropdown.
5. Schedule the automation to run as frequently as you would like, this will determine how often your Dropdown is updated as new data comes in. Lastly, Name your automation.

Now onto the Upload Automation:

1. Start with the "Source Location" as "Smartsheet Attachment", select the same file that was used in the Offload Automation step above. Choose attachment based off "Most Recent". If you kept headers, check the box stating so (data still starts in row one) If you choose CSV in the Offloading step, the delimiter will be commas.
2. In the Target section, select the smartsheet that you wish to have the Dynamic Dropdown in. Then select "Update dropdown choices for the selected column"
3. Add Filters if needed.
4. In the Mapping step, have the column with the desired dropdown options mapped into the the Target destinations dropdown column.
5. In the next section, select Run on Attachment
6. Add an expression if desired.
7. Name your automation and test it out! The Upload automation wont run until the Offload automation has occurred so you might want to run it manually once for testing purposes.