A simple script that records the current date and time to a cell as simple text. The result is a timestamp will never be updated automatically.
Works with:
9K+
Overview
The feature is invoked via a new function, F=_NOW()
This will not replace the existing function F=NOW()

Simply type "=_NOW()" into a cell to test your installation.

Useful for many different purposes. I use it for integrating reminders within the spreadsheet.
Additional information
PricingNot available
Developer
Trader status unspecified
Privacy policy
Terms of service
Static Timestamp will ask for the permissions shown below. Learn more
Static Timestamp will need access to your Google account
This will allow Static Timestamp to :
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
George B
December 17, 2022
Works for me...you have to read the directions and use the =_NOW() inside the formula area to create a static timestamp. This is a great extensions and it's a shame there's not an OEM feature. Thanks for doing this!!
Is this review helpful?
Yes
No
Profile Picture
Nico Kurniady
August 18, 2021
Works really great! But may I know how to adjust it for my timezone? Thank you very much.
Is this review helpful?
Yes
No
Profile Picture
Paul Zeng
May 31, 2021
It doesn't work? I typed in "=_NOW()", but all I got is "#NAME?"
Is this review helpful?
Yes
No
Profile Picture
Mostafa Omar
December 5, 2021
It worked well for one day, then on the next day I found that all the cells with the formula _NOW() have been updated to a date in the next day. I have been looking for a reason for this but I could not find any. Please help
Is this review helpful?
Yes
No
Profile Picture
Luiza Schulman
November 9, 2021
This add on would have been great if only it was possible to adjust it to my timezone.
Is this review helpful?
Yes
No
Profile Picture
Bodyshop Veer Ford
July 13, 2022
Kindly suggest how to change format and timezone?
Is this review helpful?
Yes
No
Profile Picture
Sidhk
April 7, 2021
This is PERFECT! Does exactly what it is meant to do. Thank you!
Is this review helpful?
Yes
No
Profile Picture
Gaurav Radadiya
May 30, 2021
Thank You. Please provide ways to use time format such as DD/MM/YYYY HH:MM:SS
Is this review helpful?
Yes
No
Profile Picture
Nikša Đerek
January 23, 2022
Add an option to change data format and timezone!
Is this review helpful?
Yes
No
Profile Picture
The N00B
April 22, 2022
and how to change timezone ?
Is this review helpful?
Yes
No
1-10 of 10
Search
Clear search
Close search
Google apps
Main menu