GOOGLE SHEETS: Now function changing itself? Need help.

[jwillits]

In google spreadsheets, as in the photo, I have a clock in system allowing people to click the checkbox, and have it put the current date and time. There are occurances to where randomly throughout the day, it will automatically change all the clockin times for a particular day to the current date and time again, without anything changing in the spreadsheet to activate it. What could be causing this and how do I stop it?

You can see in the picture for June 22, that it changed all of yesterday clock in times to 0:03:26 even though that isnt what time they clicked the checkbox. Sometime in the middle of the night it changed itself to that time.

 

[ExceLoki]

are you using =now() to get the date and time?
are you able to use macros in your sheet?

 

[jwillits]

are you using =now() to get the date and time?
are you able to use macros in your sheet?

You should be able to see the formulas I am using in the pictures at the top. I imagine I can, I have never used them before.

 

[ExceLoki]

it sounds like anytime the sheet is updating it's looking for the current value of now().
do you have something changing the cell contents from a formula to a static value?
if it is putting in a static value it will not change the date/time.
you could do this with a macro. here's an example below:
--------------
check box 1 is assigned to the macro

Sub DateTime()
'
' DateTime Macro
'

'
    ActiveCell.FormulaR1C1 = "=NOW()"
    Selection.Copy
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
End Sub

 

[Fluff]

@ExceLoki this is a Google Sheets questions & so cannot use VBA.