How to hide columns using the Google Sheet add-on

Here is a guide on how to hide columns in Google sheets using the Google Sheet add on and manipulate the data.

Steps: 

0. Download the Copper CRM Custom Report Builder if you do not already have it

1. Download your records (in this case: Opportunities) using the Google sheets add on

 2. Make a new tab called Sheet1, or use the existing Sheet1 tab if it is empty

3. Go to Sheet 1 and copy paste this in cell A1

=ArrayFormula('All Opportunities - Business Development'!B2:B)

 4. Drag the cell over as far as you want it to go by clicking the blue square at the bottom right of cell A1

 6. Go to cell B1, look at the formula. Go to cell C1, look at the formula. See how they are all different? If you do not want a column to show, just delete it.

7. Decided which columns to hide and delete them

8. Now refresh the data, by going to the Add-on and click this button :

 

9. You will see all the updated values show up on your Sheet1 tab without the deleted rows!

 

Advanced:

Now that you have seen how to hide columns, what else can you do with the add on?

 You can see the sum of opportunities by company name:

 

Formula:

=QUERY('All Opportunities - Business Development'!A2:Z,"SELECT D,SUM (E) WHERE A IS NOT NULL GROUP BY D ORDER BY SUM(E) DESC",1)

SELECT D,SUM (E) refers to these columns:

 

More cool things you can do:

https://www.copper.com/blog/the-new-custom-report-builder

https://docs.google.com/spreadsheets/d/1f4B3C9v8h1r78ujVA6Z8VFtdiVSXpJ-_Kp7GBlSbCIU/edit#gid=1137015567

Still have questions?

Still have questions? Ask in our Community, and get answers from our Customer Success Team as well as fellow users.

 

Was this article helpful? 0 out of 1 found this helpful