Tuesday, March 27, 2012

yogi_Insert Current Date At Different Times And Hold (Meaning Entry Remains Static)

Yogi Anand, D.Eng, P.E.                Google Spreadsheet          Post  #489         www.energyefficientbuild.com

user Luiz Felipe said: 
This timestamp Function is updating Hi, I just added the timestamp funciton, and used it as some users dicribed here, but the date and time are beeing updated, sometimes when I open the spreadsheet. Could anyone help me ? i just need to put the date(can be with or without the time) at the first column(A) every time that column(B) get a value. 
following is a solution to the problem using DataValidation In this workaround I use Data Validation from a List ... the List consists of one cell with the following formula ... =today()