6 Replies Latest reply on Oct 11, 2017 8:45 AM by Mine Safety

    Google sheets with formulas

    Asier de la Fuente



      I´m trying to use Tableau Public 10 with it´s new Google sheets import features, but i can´t


      The trouble i´ve encountered is the following:


      I have a Google spreadsheet with sales information.

      Commissions, taxes, etc., are calculated with a formula inside Google Sheets cells.


      When i load the sheet inside Tableau, y get all the values ok...if there are marked as "string"

      If i configure a row as "number" (with or without decimals) the cells that contains formulas appears as "null", so i can´t get numeric content in those cells to use inside Tableau 10.


      Any ideas on how to solve it?