fixed a bug in the formats caused by gsheets range lookups