Cell Format on grouped sheets

[James Shaw]

So, I have 3 sheets displaying into 1 Master Sheet.

On the Master sheet - one column only it will only display numbers #####. If I enter a value that has letters, it will not display on the master sheet (AB#####) but will show on the other sheets.

Any way I can get it to display anything?

[Hassam Saeed]

Hi James,
You may need to share more details about the formulas or scripts being used in the master sheet to help others better understand your issue.

[James Shaw]

Ok,  Here  is the formulas I am using.

=QUERY({IMPORTRANGE(X2,AA2);IMPORTRANGE(X3,AA3);IMPORTRANGE(X4,AA4)},"Where Col1 is not null ORDER BY Col2")

It works fine. Everything thing is displayed correctly, It just one column only will display number (####) when I need to to display a combo of number and letter (AB###)

I've a screen shot showing the Red Arrow:

This is the master sheet missing the data in the column 

 

This is the working sheet with the data in the column

[Hassam Saeed]

Gotcha. Thanks for sharing the details.

As per the Query documentation:

Each column of data can only hold boolean, numeric (including date/time types) or string values.
In case of mixed data types in a single column, the majority data type determines the data type of the column for query purposes. Minority data types are considered null values.

https://support.google.com/docs/answer/3093343?hl=en

The solution is to convert that particular column to string/text datatype. You can do that via Format>Plain Text and if that still causes some issue then use the to_text() function to convert that column to text.
Lastly, in your query formula, its also recommended to use the header(last argument) explicitly i.e. in your scenario it will be 0.  

Let me know if that helps.

Thanks

Hassam Saeed
GSheets.com

[James Shaw]

Thank You. I have been playing around with this. I've changed the column to 'plain text' and still nothing. I just don't understand how other column's are able to have mix data type and this one not. is it because its in a format of AA#### and other is like a address 123 Street Ave?

I'm also Adding the '0' for headers.