lizmorton1990
New Member
- Joined
- Aug 19, 2020
- Messages
- 16
- Office Version
- 2013
- Platform
- Windows
Hi,
I have created a google sheet that has what training people have done (all data tab), the data contains 4 courses and I then created 4 new tabs on the same sheet, one for each course. I then in each of the 4 tabs created an import range bringing all the data for the one course from the all data tab. My formula is this:
=QUERY(IMPORTRANGE("Google Sheets - create and edit spreadsheets online, for free.","Saba Report!a:j"),"Select * Where Col2='Skill Up, Stay Smart Module one: Firm Up Foundations'")
But my all data tab contains both text and numerical values, for example there is a payroll number column that has just pure numbers and also payroll numbers starting with IE. The 4 tabs bring through the numerical payroll numbers onto the tab but it doesn't pull through the payroll numbers starting with a letter, what am i doing wrong?
Also I have another column that shows time spent in the e-learning module and the format in the all data tab is like this 00:00:00, 0:00:21, 0:45:34 but in my 4 tabs it either pulls a blank or 0 - what do I need to do to ensure it pulls exactly what the data says in the all data tab please?
Thanks in advance, Liz.
I have created a google sheet that has what training people have done (all data tab), the data contains 4 courses and I then created 4 new tabs on the same sheet, one for each course. I then in each of the 4 tabs created an import range bringing all the data for the one course from the all data tab. My formula is this:
=QUERY(IMPORTRANGE("Google Sheets - create and edit spreadsheets online, for free.","Saba Report!a:j"),"Select * Where Col2='Skill Up, Stay Smart Module one: Firm Up Foundations'")
But my all data tab contains both text and numerical values, for example there is a payroll number column that has just pure numbers and also payroll numbers starting with IE. The 4 tabs bring through the numerical payroll numbers onto the tab but it doesn't pull through the payroll numbers starting with a letter, what am i doing wrong?
Also I have another column that shows time spent in the e-learning module and the format in the all data tab is like this 00:00:00, 0:00:21, 0:45:34 but in my 4 tabs it either pulls a blank or 0 - what do I need to do to ensure it pulls exactly what the data says in the all data tab please?
Thanks in advance, Liz.