Currency format in Google Sheets not importing into Looker

My data source is Google Sheets with lots of columns being imported into Looker. However, the currency formatted columns from Google Sheets are being pulled in as a format type “number”. Is there a way to format the columns in Google Sheets, so it automatically recognizes the format type when pulled into Looker?

And if not, is there a way to update multiple data field types in Looker at once?

0 0 115
0 REPLIES 0