How to create a Slack Bot from Google Sheets
Kanza Akhwand A lot of my reporting is repetitive mindless work. The fun part of data for me is the analysis but if I spend time updating my sheets and sending reports…
Google Sheets
How to Bulk add events to calendar | Kanza Akhwand
The following is to push Events from a google sheet to google calendar script: function addEvents() {var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();var lr = ss.getLastRow();var cal = CalendarApp.getCalendarById(“c_3qjs8u1i5cu0re1coi8ageo51s@group.calendar.google.com”); var data = ss.getRange(“A2:E”…
How to Pull Calendar Data to Google Sheets | Kanza Akhwand
Want to add your Google Calendar Data to Google Sheets? function getEvents() {var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();var cal = CalendarApp.getCalendarById(“kanza.akhwand@yayvo.com”); var events = cal.getEvents(new Date(“07/01/2020 12:00 AM”), new Date(“07/31/2020 11:59 PM”));…
How to increment Alphabets like numbers in Google Sheets | Kanza Akhwand
When you write 1 and 2 one below the other, copy them and drag it down the numbers increase calculating the difference between the first two cells. However you can’t…
Index Match, Vlookup’s Bulkier Cousin | Kanza Akhwand
In my previous post i talked about Vlookup and how easy it is to use and learn, in this post i want to talk about Index Match. In my personal…
Introducing Vlookup: Get Started on your Excel Journey | Kanza Akhwand
This is the first post on my new blog. I’m just getting this new blog going, so stay tuned for more. Everyone who uses Ms Excel or Google Sheets knows…