Auto insert Timestamp in Google Sheets based on another cell changes
Вставка
- Опубліковано 25 сер 2024
- This video is how to add timestamp in Google Sheet's Cell based on another Cell changes. How to apply formula on circular dependency. How to on iterative calculation in Google Sheets and how to apply conditional formatting in ranges based on another cell.
++++++++++++++++++++++++
Google Sheet Link: docs.google.co...
If you want to learn more advanced topics in Excel, Google Sheets, Google Apps Script, Google Data Studio, SQL, Big Query, Tableau, MS PowerBI, Dashboard Creation, Data Visualization then please subscribe this channel and press bell icon 🔔 for notification:
/ @tenpowerten
Follow on Social Media for extra new updates.
Facebook: / tpt.analytics
Telegram: t.me/tenpowerten
Recommended Products:
DSLR Camera:
amzn.to/36plyyi
amzn.to/3konLio
Laptop:
amzn.to/2GT3DHt
amzn.to/2UrzbqZ
Wireless Mouse:
amzn.to/2Uni1Lc
Book:
amzn.to/35mByle
amzn.to/36tKJ2L
Books for Excel & VBA & Google Sheets & Script:
amzn.to/3eUpWt1
amzn.to/2Ir3ifE
amzn.to/3eSEZTR
#GoogleSheets
#timestamp
#GoogleSheetsHindi
#googlesheetstutorial
Finally , i got what i searching since 2 days .
Thank You.
ZABARDAST BOHT RESEARCH KIA UA-cam PR AAKHIR AAP K BAAT SAMAJH AAI
Glad to hear.
Thank you.
Thank you u r good at explaining
You are most welcome.
the gretest teacher.
Thank You for your Words. Just sharing my knowledge.
Saludos desde Colombia
Hello!, Greetings from India.
Thank You, Cheers!
Sir, agar main kuch employee ki ik Google sheet mein alag alag name se tab banata huun aur sab ko daily task deta huun day by day un sab tab ka data ik alag Google sheet mein merge kerna chahta huun, but Jo sheet jiske name se ho wahi use ker sake doosre name wali sheet ko open na ker sake , kaise ho ga plz bataye, unke task mein mujhe pending aur done ke liye rule lagana hai, plz bataye
Sir, apse ek question hai google form se jo response ata hai wo hum.kaise pta kr sakte hain ki form kisne bhara but jo google form mein option hai email ka to usme to koi bhi vyakti kisi ki bhi email id likh sakta hai, but actual id kaise receive hogi?
Hi Thank You for your lesson. It is very help full . I insert it to my sheet. it works perfect. but after few hrs dragged formula is deleted in my sheet. Idont how why. the sheet is link to goole form. it accuses one team member. anyway I protected that colm. they can't edit it. please help me
Auto delete not possible. Please check History from File menu Version History who changed/edited/deleted.
Thank you.
makasih mas mas india
Thank you.
Had to modify this formula a little to get it to work with a "TRUE/FALSE" button, but it certainly can be done. If anyone else is trying to do what I was, this is what worked for me
IF(BA2:BA,BA2:BA,IF(AZ2:AZ=TRUE,NOW(),""))) to just copy into the destination cell, or =ArrayFormula(IF(BA2:BA,BA2:BA,IF(AZ2:AZ=TRUE,NOW(),""))) to populate an etire column.
Thanks ji
but time is changing when we refresh sheet. What is the solution for that?
but if you open the file at another time it will change. Is there a way to make the date fixed for the first time and doesn't change?
@Dean S. Brown which email I don't understand
it's a nice project. but if you open the file at another time it will change. Is there a way to make the date fixed for the first time and doesn't change?
Please follow all instructions. Actually this videos is for question. if not solved then please mail. email is given in about section.
Thank you.
@@TenPowerTen hello, thank you for your reply. I wrote you for a different subject than e-mail. If you don't mind, you can check it out.
pls let me know from this video i want the date and time disappear when the check box is unchecked
You can use simple if condition then it will work. for more details please email us . email is given in about section.
@@TenPowerTen Hi! I have the same question, what is your email? Also, do you have a video about creating a TIME IN-TIME OUT for Employees that's somehow similar to this?
Janab time stamp lagany k bad agly din date change hota hain iska keya hal hain.
Please watch full video. Solution is there which is from file menu - Settings - calculation- Iterative calculation.
Thank you.
Iteration option Ms excel mein on kaise hoga sir
1 Go to file menu
2. Click on Option
3. Click on Formulas then Click on Enable iterative Calculation change as your need then click on save or OK.
Thank You.
Sir ye formula google sheet Android me kam krega?
Haa
@@sdabrarullah4919 nhi ho rha h bhai
Why type the title in English when you're talking Marsian???
It's her choice.
Sir ye function hum normal excel mein lga rhe hain ek to result bhi nhi arha aur #Value! Error bhi arha hai
Iterative bhi enable hai please solve my issue sir
Please use this formula in Excel:
IF(D3"",IF(E3"",E3,NOW()),"")
In excel logical test is mandatory. But we have used in Google Sheets IF(E3,E3,IF(******) which is error in excel.
Thank You.
I want only Date not time.
thanks
Use today() instead of now().
Thank you.
Your video is not clear
Please click on Settings then Quality for quality settings. you can change video quality. 720P is max in this video.
Thank you.