Indeed Sleek, Neat simple and very useful! Thank You Prolific Oaktree!
@PCor183 жыл бұрын
Exactly what I was looking for, thank you so much!
@SidhkYouTubeSidhk3 жыл бұрын
Hi This is a great video but its not working for me. I have 10 tasks and every time i tick one off the times of the others also change to the current one.
@mercylenemahinay2 жыл бұрын
I am having the same problem. I still don't know how to get it right
@reyesma.donnalyn43262 жыл бұрын
Same case. Hoping for your response Sir Prolific Oaktree. Thank you!
@rebecontreras192 жыл бұрын
Hi. Could you please explain how to add the counter of the completed tasks. For example 3/6 complete. I saw I should concatenate and add some sums, but haven't been able to do it. Thanks
@sabrinastowell12652 жыл бұрын
This was so helpful! Took me no time at all with this tutorial :)
@lakebum5 Жыл бұрын
Is it possible to have each row that is not checked off as being complete to be copied to different tab. Say tab one being the master data tab and tab #2 sheet just showing uncompleted task. So that you could just click the different tags and have your data sorted in those tabs. All your videos very helpful thank you for the great info.
@reyesma.donnalyn43262 жыл бұрын
Hi! Thank you very much for this tutorial. It helped me a lot!😊
@chrisellis33579 ай бұрын
This was great....thank you!
@ProlificOaktree9 ай бұрын
Glad you enjoyed it.
@sagarsinghpune Жыл бұрын
HI but the timestamp will update for the next day it is not keeping the fixed value
@vb1design3 жыл бұрын
Professor, thanks for the great content. I did it here and it worked well for some time but now my sheet is replacing the timestamp values for old values. I marked the checkbox yesterday and today it returned to last week's value. Do you know why is this happening?
@mrlich20 күн бұрын
I have something similar but not the same. Once I check any additional boxes in my list, the new item gets a time / date stamp, while all the previously dated (completed) items get a "TRUE". Not sure why.
@MehranMansouriFar Жыл бұрын
thank you, this was so helpful 🙂
@ProlificOaktree Жыл бұрын
Glad it was helpful!
@stevenfearon6424 Жыл бұрын
Perfect. Thank you.
@ProlificOaktree Жыл бұрын
Glad it helped!
@elizabethbrown24803 жыл бұрын
Thank you for this. What would the format look like if the date wasn't dependent on anything else? For instance, opening a new 'form' with a place for the date, I would like the date to automatically populate, but not change when I come back to it.
@TheSuperman082 Жыл бұрын
How would this work with a drop down menu??
@victorialung19003 жыл бұрын
This is so helpful!! Thank you so much !! ♥♥
@ProlificOaktree3 жыл бұрын
You're so welcome!
@graceadato5665 Жыл бұрын
what if you want multiple columns crossed out? I tried editing the range but it didn't apply to more than one column
@YasithaWijayanayaka2 жыл бұрын
much helpful (y) thanks
@yuriyrybiy20342 жыл бұрын
I have an error in the Time completed column. What it the problem can be?
@ck15683 жыл бұрын
Thanks for the vid
@relaxingandpeacefulinstrum9902 жыл бұрын
Dear Sir, what if I want to keep only the time and not the date? Is it possible? By the way, useful and knowledgeable video. Thankyou for your hard work.
@cliche5113 жыл бұрын
Thank you!
@ProlificOaktree3 жыл бұрын
You're welcome!
@jeffdouglas33742 жыл бұрын
Great video. Is it possible to lock a checkbox once the it has been checked? I'd like to lock the checkbox to keep the correct date.
@ProlificOaktree2 жыл бұрын
Possibly. Take a look at this video for something similar kzbin.info/www/bejne/jKbHgaeOeMtlmLc
@joscoprinters7732 Жыл бұрын
It shows 24hours clock format is there a way to format it for am and pm
@ProlificOaktree Жыл бұрын
Yes, go into the custom formatting options in the menus. It's generally covered here. kzbin.info/www/bejne/hprRe4Wuja6Sf7s
@surdogic3 жыл бұрын
Hi! It does an error for me, but there is one difference I see - You have both D3 in violet, while I have first one violet, second - black. I catch the issue is there, but can't understand how to fix that. Thanks!
@vb1design3 жыл бұрын
Same here!
@vb1design3 жыл бұрын
I figured it out, in my excel the problem is that commas are not the correct way to separate values, i used ; instead and it worked
@farhanrevifitrahandoyo-5778 Жыл бұрын
@@vb1design Thaks for the information
@user-gs4vz6dh5j Жыл бұрын
Hi, great tutorial! Any idea how-to group the checklist items, so when the group name is checked, all items in the group are checked at the same time automatically ? Thank you, Adam
@ProlificOaktree Жыл бұрын
Nope!
@user-gs4vz6dh5j Жыл бұрын
@@ProlificOaktree Ok, going for Dynalist app..
@josephjamandre25143 жыл бұрын
Can you do auto summary to be reflected on the next sheet. Its like pressing Done button then the checklist will refresh and old data will be summarized on the other sheet.
@ProlificOaktree3 жыл бұрын
Use the FILTER function on the next sheet.
@ck15683 жыл бұрын
I was wondering if anyone can help me.... On 1 sheet I have a task list with a whole years worth of tasks on it (so eg 200 tasks and with how many hours each task will take in the next column)... I would like to have a new sheet for a daily task list where I can input how many hours I have available that day, and would like google sheets to automatically fill in the tasks upto the amount of time I have inputted, is this possible? Thanks
@migdon470 Жыл бұрын
I am typing in the date formula and its not working
@lizette89073 жыл бұрын
Hello, how can I change the settings to drag down a time or date to copy it down the cell without the date changing?
@ProlificOaktree3 жыл бұрын
You should copy it, select the cells where it goes, and then paste it instead of dragging it down. That will work. I'm not aware of a way to change it in the settings.
@PCor183 жыл бұрын
I've had a strange bug happen to me. It recalculated a timestamp in spite of having the correct settings and it did it only once!
@PCor183 жыл бұрын
Actually, it happened again, I'm afraid this does not work...
@flatlineproductionsllc2 жыл бұрын
Would it be possible once the checkbox is checked to have the entire row for that task be archived or transferred to a different sheet called completed tasks?
@ProlificOaktree2 жыл бұрын
I get that question a lot so I made this video. Hope it helps - kzbin.info/www/bejne/e4DGhpKAhJ1midU
@flatlineproductionsllc2 жыл бұрын
@@ProlificOaktree This helped immensly! The only issue is that it says I get the error TypeError: Cannot read property 'getDataRange' of undefined autoSort @ The piece of code that is the issue is line 63: function autoSort(sheet) { // Get the entire set of data for this sheet. var range = sheet.getDataRange(sheet);
@pointblankperiodpodcast73383 жыл бұрын
Hi, this is really helpful, but I'm having trouble getting the formula for the time stamp to work. I was hoping this video would walk me through how to do it, step by step, like the =b3=true formula. Thanks.
@ProlificOaktree3 жыл бұрын
=IF(B6=TRUE,IF(D6"",D6,NOW()),"")
@johnmarksalas58433 жыл бұрын
I dont understand what to uncheck... lol.. I got Error.
@MrSinghLko3 жыл бұрын
how to create a reminder Tasks from the list of Google Sheets?
@ProlificOaktree3 жыл бұрын
There is no built-in way that I'm aware of.
@lizette89073 жыл бұрын
lol love the sheet name
@ProlificOaktree3 жыл бұрын
Thanks for catching it! I like to put little things like that in videos and see if anyone says anything.