Set Data Type by Row



Is it at all possible to set data types by row or specified account?


We are trying to build a card that shows a P&L view, which would require importing accounts that have multiple data types (i.e., $ for Gross Margin, % for Gross Margin %).




  • Hi there,


    Just to get more context, is there something stopping you from using the text datatype for the relevant columns? If you can provide a screenshot of the data that would give us a better idea of what you're dealing with (if you do decide to provide a screenshot don't forget to censor any sensitive data!)