Scribbling Dock

Google sheet is commonly used as database. But did you know that you can use google form to collect it? I've been using google form for years now ... and made several how to's .. but I can't believe that I've never made how to create google form and connect it to spreadsheet ... so here ... There are many ways to connect google form to sheet 1. Through google form . Go to google form, and create your form. And at the responses, create the sheet. 2. Through google sheet Go to google sheet, and create your sheet. On tools- create form, it will automaticaly create a sheet as form response Then boom ... you have 2 files connected to each other. Share your form through link, email or web page. From the link, open in browser, then add to home page, it will create a browser shortcut to the browser, with form logo in it. So there ... ^_^

Did you know, di google Spreadsheet, kamu bisa bikin satu rumus untuk setiap baris dalam satu kolom. Cukup taro di paling atas, diikuti rumus beserta kolom kendalinya. Contoh: Saya mau kolom A1 - A10 berisi nomer baris, maka di A1 tulislah: =ARRAYFORMULA(ROW(A1:A10)) Arrayformula: artinya .. untuk setiap baris, berlaku ... Row(A1:A10): nomer baris dari A1 - A10 Hasil: Lihat hasilnya di sini .

Beberapa waktu lalu, saya tanda tangani sebuah perjanjian kontrak, yang akan berakhir pada beberapa bulan. Kemudian, saya bikin sheetnya untuk reminder, kurang berapa bulan lagi, kontrak itu berakhir. sheet Beberapa yang sudah saya ketahui di sini adalah ... Tanggal mulai kontrak, dan Lama kontrak Hal hal yang perlu saya tambahkan adalah sebagai berikut... Hari Ini Untuk mencari tahu hari ini, saya menggunakan fungsi =today() Kontrak Berakhir Kontrak berakhir ini, saya menggunakan fungsi: = EDATE(start_date, months) Dalam hal ini, =EDATE(tanggal_mulai_kontrak,lama_kontrak) Fungsi ini menggunakan bulan, jadi sebenernya ... ini sama juga artinya dengan ... " Kapan sih x bulan dari tanggal y? " Kalau lama kontraknya dalam hitungan tahun, ya berarti harus di kali 12 dulu, supaya ketemu berapa bulan. Sudah Berjalan Kalau ini, saya gunakan: =DATEDIF(start_date,end_date,"unit") Ini bertugas menghitung berapa hari/bulan/tahun antara dua tanggal. U...

ExcelFun tought me to create this in excel ...  I thought I can make it in google spreadsheet ... A bit different .. but hey .. it's cool .... the idea is the same ... so no need to explain A bit easier with excel ... and more artistic .. it has the icon custom format ... for google spreadsheet ... I only use regular custom format. Here is the excel version . Download it first and open with excel.

Sometimes I have several google sheet file with the same column. I need to combine all of them to make the summary. So, this is what I do ... 1. Make sure they have the same column     All my example have column A to F 2. Copy the sheet's ID, ( the random character after = ) 3. Put it in a sheet at the master file 4. Call it in a new sheet     I use:  = ImportRange ( list!B1 , "A1:F" )  to call all column,     and will grow whenever my data insert new record. 5. Make a master sheet, and combine all ...     a. I call all records with no blanks:           = FILTER ( '1st Data'!A2:F , '1st Data'!A2:A <> "" )     b. Combine all filter using {}, and seperate with ;          = { FILTER ( '1st Data'!A2:F , '1st Data'!A2:A <> "" ) ; FILTER ( '2nd Data'!A2:F , '2nd Data'!A2:A <> "" ) } 6. [optional] Add an auto numbering ...

Take the quizz here !

I've shared how to insert image in google spreadsheet here . But what if, my image is in my google drive? so here it is ... Link to my google spreadsheet . NICE!

An update from this log . A year ago, I was trying to populate my google form, from a column in a table, using a script formRanger . At that time, it can only be use in old google spreadsheet. So, when I change to new google spreadsheet, I can no longer use it. But today, I found out, it is in google Add Ons ... So... I'm in hype! The best thing is .. it can use other spreadsheet as the source. Nice he? So anyway ... I prefer to have my list in the same spreadsheet with the respons report of my form, so first thing is ... I prepare my table. I put it in another sheet, the first row is the title of the list . So if you use other spreadsheet as the source, just make sure you put the first row is the title, If you don't you'll lose the first row in the list. the list Since I start from the spreadsheet, I make a form from that spreadsheet, so it will attach automaticly. click form - edit form ... it will take you to form. The first time, I instal formRanger, just once...

I just found out that you can insert an image in google spreadsheet not just in a floating image, but inside of a cell, so you can call it back in other cell. Check it out here . The function is: =IMAGE(url,[mode],[height],[width]) ( 3 last part are optional ) First, you should have an url for your image. How? I put my image in picasa, it connects with google, and share it to get the url. This URL must have the image extention, such as .jpg, or .png, or ... if you have a website, you can put it there too ... so you can have the link. ... and then, choose the mode for the image. mode 1, is the default, so if you don't write it, it automatically use this mode. mode 2, will streatch the image to fit the cell mode 3, will show the original size. mode 4, you can custom the size as you wish. with this function, you can call the image anywhere you want in the spreadsheet. even in pivot too .... Just try in my spreadsheet , you'll get the idea. Source: Google Suppo...

HAPPY NEY YEAR!!! Akhirnya masuk ke awal tahun lagi ... haha .... Saya sempet bikin google spreadsheetnya ... Daftar liburnya cuma 2014 - 2015 doang ... Saya juga menambahkan daftar ulang tahun juga, jadi bisa ditambahkan disitu untuk catatan ultah, tapi 1 tanggal cuma bisa isi 1 nama doang .. blon bisa bikin yang multinya. Kalau mau ambil, copy aja dulu ke google.drive kalian, lalu silahkan diutak-atik sendiri ... haha .... Kalender Libur di Google Spreadsheet light blue 3 : TODAY light yellow 3 : Sabtu light orang 3 : Minggu light red 3 : hari libur pada daftar Saya dapat dafrarnya dari kompas. Ini daftar libur 2015 dari kompas Daftar Libur: 1 Januari (Kamis) - Tahun Baru 2015 3 Januari (Sabtu) - Maulid Nabi Muhammad SAW 19 Februari (Kamis) - Tahun Baru Imlek 2566 Kongzili 21 Maret (Sabtu) - Hari Raya Nyepi Tahun Baru Saka 1937 3 April (Jumat) - Wafat Yesus Kristus 1 Mei (Jumat) - Hari Buruh Internasional 14 Mei (Kamis) - Kenaikan Yesus Kristus 16 Mei (Sabtu) -...

Sometimes, I need to do this ... Dalam google spreadsheet, saya harus menyatukan beberapa kolom jadi 1 kolom. Awali dengan = Gunakan kurung kurawal untuk buka dan tutup Pisahkan kolom yang terpilih dengan titik koma Contoh: ={A1:A10;B1:B10;C1:C10} Google Spreadsheet Sample Combine Few Columns to One Column

Kadang kala ada angka dalam cell yang diformat sebagai text. Walaupun di awal selalu otomatis terbaca sebagai number, Namun, ketika ternyata dianggap sebagai text dan saya butuh dia menjadi number. Ada beberapa cara ... Dengan format cell Klik cell, lalu format - number untuk ganti formatnya. Dengan Rumus cek apakah dia text: =ISTEXT(A2), TRUE untuk Text, FALSE untuk Number Cek apakah dia number: = ISNUMBER(A2), TRUE untuk number, FALSE untuk text ubah jadi number: =VALUE(A2), akan keluar angka yang diformat sebagai NUMBER Lihat file di: https://docs.google.com/spreadsheets/d/16mLNF1ZT-FtQBL0HMySPkUX3BhrYxmuMqHZlEDO8olA/edit?usp=sharing

When I tried to use google spreadsheet as project management tool for my friends, I was having a hard time to keep up with the list. Do I have to write it down one by one? ... it's more than a hundred list! nightmare ... copypaste? ... still not an option! After I've asked my good friend "google" ... We've found an article in a google group. it is called formRange, created by ahab ... I don't know this person, but LORD please BLESS this man for making my life so easier!! ... thank you Ahab .. who ever you are ... ^_^ So, here is the how to section . Need I explain more? thehehehehehe ...