Hi Kristy,

Can you please check what is the Column data type for the "Earnings"?

It seems it might be set as a String column?

Can you tell me do you have this currency symbol inside the cells where your numeric data is on the source Sheet?

If so, this will not work with our Plugin for numeric Columns such as Floats or Integers.

The solution is, to remove any symbols and just leave pure numeric data in the cells of your source Google Sheet,

then you can make integer or Float Column from this in our connected Table.

 ( Just also double check if you have the same Number Format matched in the main plugin settings, and the decimal numbers)

After this, just go in the Display settings of the column, and add any prefix or suffix symbol there.

Then you will be able to change this Column from String to numeric, such as Float or integer, and you can have numerical sorting.

If you use the Column as String, then you can't have numerical sorting - any Strings in the Plugin an only sort as alphabetical order.

Let me know if that helps.

Thank you.

Hi Kristy,

You're welcome.

Basically, if the source cells in this column from the Sheet have any symbols (such as $ or any other), this makes it a String Column in our Table, and that is why it can not have proper numerical sorting.

If you can change that on the source to have it generate numerical values as pure numerics without symbols, then you will be able to either go in our existing ( already linked) Table and just change this Column type from String to Float ( or integer), then just add a prefix as $ in the Column Display settings and the issue will be solved.

- Or, if you make a new Table then our Plugin will automatically 'guess' this Column should be Float ( or integer if it doesn't have decimals) and properly set it to the right numeric Data Type and not as String.

2. Just an additional possibly important detail. When you say the data in the Sheets/the spreadsheets are automatically generated, do you possibly include any kind of a formula/ or script on your source Sheet?

If so, we have a specific method when we try using a Google Sheet with Formulas, basically.

In all of our Testing, we are unable to get the Google Sheet with Formulas working properly, so we have this Guide which you can follow to have the Sheet with Formulas as data source without any issues.

In short, the main idea is to make a new Sheet Tab/ or a completely new Sheet, which is blank, then add the !importrange in the A1 cell,  so this passes all the values from the Original Sheet after the Formulas are finished, then our Table gets just the pure 'finished values', if that makes sense.

So you can still work/edit anything you need on the Original Sheet that has Formulas and certain Formatting,

while our Table will just pick up the final values after the formulas go through them on the second connected Sheet Tab.

What we said about the numerics with symbols still applies, this is just an additional side note to check, just to avoid any possible issues if you use Google Sheet formulas.

Let me know how it goes.

Hi Kristy,

I am glad to see this has been solved.

We will go over your remaining open ticket as soon as possible.

Thank you.