Issues with adding data sources from multiple tabs in google sheet

[PJMatelli]

We have had an issue pop up several times and have come up with different ways to make it work. I am wondering what is the best solution to avoid this issue in the future.

We have a google sheet with main data tab…We also have, in the same sheet, tabs with data for the drop downs in the app. Occasionally, the issue is when attaching a data source from other than the main source, it doesn’t recognize the sheet properly. We did find out that it is confusing when the name of the tab is the same name as the column, so we don’t do that anymore. But now, I am getting the issue where App Sheet believes the data starts in the middle of the column and actually assigns a value to the column head. See examples below. Any advice/help is greatly appreciated. TIA!

Data (as set up in sheet):
TabName is: InvoiceMethods

Result when brought into app:

TabName is: PaymentTypes

Result when brought into app: