Push a Column to Each Sheet in Google Sheets


Warning: Undefined array key "background_image" in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 87

Warning: Trying to access array offset on value of type null in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 90

Warning: Undefined array key "background_image" in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 87

Warning: Trying to access array offset on value of type null in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 90

Warning: Undefined array key "background_image" in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 87

Warning: Trying to access array offset on value of type null in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 90

Warning: Undefined array key "background_image" in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 87

Warning: Trying to access array offset on value of type null in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 90

Warning: Undefined array key "background_image" in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 87

Warning: Trying to access array offset on value of type null in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 90

Warning: Undefined array key "background_image" in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 87

Warning: Trying to access array offset on value of type null in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 90

Warning: Undefined array key "background_image" in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 87

Warning: Trying to access array offset on value of type null in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 90

Warning: Undefined array key "background_image" in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 87

Warning: Trying to access array offset on value of type null in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 90
Push a Column to Each Sheet in Google Sheets
YouTube video

I had a request by a premium member that they had one Google Sheets spreadsheet with a tab per teacher to keep track of the daily contacts with students and parents. She wanted to add a column each day with the date to each of the sheets for the spreadsheet.

Authorize the Add-on

After making a copy of the spreadsheet wait about a minute for the code to load. Locate the “Add column” menu that shows up next to the help menu. Choose “Authorize Add-on.” I have personally coded this Add-on, it is safe. I have NOT submitted it to Google. If you get a warning that Google has not reviewed it, that would be because I did not ask them to.

Choose “Add”

Choose “Add” from the “Add Column” menu. This will prompt you “What column title would you like to send to each sheet?” Type whatever column header you want to show up on each sheet in your spreadsheet.

2 thoughts on “Push a Column to Each Sheet in Google Sheets

  1. You can also use the IMPORTRANGE command to import a column from the same tab, another tab in the same sheet, or even from another sheet (document) completely.

    Don’t need a separate add-on when there’s already a built-in function…

    1. This would be a bad idea for this application to use import range. You are limited to how many importranges you can use and it loads slower. Also you can’t edit the importranfe values.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

© 2024 All Rights Reserved.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Oct24th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for using FigJam to start every lesson.

Exit this pop up by pressing escape or clicking anywhere off the pop up.