I wonder if it is possible to create a custom printable view from a google spreadsheet.
– Suppose we have a single table in a google sheet.
– Our table columns are as follow: First column->Date and time of the record // Second column->Last Name // Third column->First Name // Fourth column->E-mail address // Fifth column->Books quantity // Sixth column->Glasses quantity etc. So we have records just like this:
1/12/2014-13:05:07 // Smith // John // email@example.com // 14 // 0
2/12/2014-14:06:08 // Kliafa // Ardea // kliafa_Ard@gmail.com // 3 // 4
In our printable view we need to re-arange the data and we need to omit some of them. Let’s say we need to omit the zero columns per person and the Email addresses. So, we need something like this:
NAME: Smith, John
NAME: Kliafa, Ardea
So, is this customization possible? Is there such choices in google sheets or we need to look up for a gs script? And is it an easy task?
I will appreciate any help