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…
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" +…
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"));…
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…
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…
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…