Need Advice on Configuring a Sheet

Brandon Sills

Hello!

I am looking for advice on the best option to set up a sheet.

My goal is to create a blank sheet, set up a a few columns, and then pull in the Community Name for the "Active" Communities into a column stemming from the source sheet. I also want it to remove the communities from the row data when it becomes inactive. (Active vs Inactive are distinguished in the source sheet and are updated as new files are imported via Data Shuttle)

I was almost able to accomplish this with creating an attachment from the source sheet and triggering the attachment to update a DataTable via Data Shuttle…then linking a data table to the blank sheet. The problem with this is that once a Community is no longer active, I cannot remove it from the DataTable.

I looked into DataMesh but do not think this is an option, as I do not have any row data in the blank sheet.

Any suggestions on the best practice for setting something like this up other than utilizing an INDEX function?

Thanks,

Brandon

swfascetti

Have you looked into using datashuttle to update drop down menus based on a query? You would need a separate sheet that lists the Communities and their status.