# Timestamp on updating a cell **URL:** \ **Category:** Ask for Help\ **Created:** [December 20, 2022, 10:01am UTC](https://community.glideapps.com/t/timestamp-on-updating-a-cell/55908 "2022-12-20T10:01:45Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Rohan\_Saneja](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rohan_saneja/32/37266_2.png) [@Rohan\_Saneja](https://community.glideapps.com/u/Rohan_Saneja)\ **Post date:** [December 20, 2022, 10:01am UTC](https://community.glideapps.com/t/timestamp-on-updating-a-cell/55908/1 "2022-12-20T10:01:45Z")
Hi All I have made a glide app where my sales users update the status of a lead. At the end of the day I want to track how many leads were updated using the date stamp of cell updated. How to solve this? Attaching the screenshot, I want to check the date stamp when the ‘Current Status’ entry is filled. ![Screenshot 2022-12-20 at 3.31.05 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/4/54e32fced63da090839f34547e949ce6d4eb5bd6.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 20, 2022, 1:01pm UTC](https://community.glideapps.com/t/timestamp-on-updating-a-cell/55908/2 "2022-12-20T13:01:34Z")
There is no way to automatically update a date column when you are changing the status directly on the detail screen. Instead, if you use the Edit screen to change the status, then you can add a date time special value component that will insert the current date and time when the edit form is submitted. Another option would be to have a user specific column to temporarily hold the status. Your choice component would fill the user specific column. On the way into the detail screen, you would set the user specific status column with the value in the status column. On the detail screen, you could have a Save or Submit button that copies the user specific status to the status. So a user could choose a status and click on a submit button directly on the detail screen, but that submit button could also set a date column. The only other option would be some sort of script in a google sheet that could track when a status changes and update a date column, but that would be a lot of work for something simple. I would just use the Edit screen instead. ---
**Author:** ![Rohan\_Saneja](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rohan_saneja/32/37266_2.png) [@Rohan\_Saneja](https://community.glideapps.com/u/Rohan_Saneja)\ **Post date:** [December 20, 2022, 7:01pm UTC](https://community.glideapps.com/t/timestamp-on-updating-a-cell/55908/3 "2022-12-20T19:01:01Z")
> [@Jeff\_Hager](#): > > Instead, if you use the Edit screen to change the status, then you can add a date time special value component that will insert the current date and time when the edit form is submitted. Can you please explain how to do this? I am very new to Glide Apps and just made the first app ever. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 20, 2022, 7:32pm UTC](https://community.glideapps.com/t/timestamp-on-updating-a-cell/55908/4 "2022-12-20T19:32:57Z")
Tap on the pencil icon at the top right. ![Screen Shot 2022-12-21 at 3.30.04 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/5/f540422ec9cdfc067162c5dd3b1aa57cf37beeba.png) That will take you to the Edit screen. Add your input components on that screen, including an extra one for the datetime. Use the special value that Jeff mentioned for that. > **[Glide Docs • Current Date/Time](https://www.glideapps.com/docs/reference/values/current-date-time)** > > Submit the current date & time automatically. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [December 20, 2022, 7:34pm UTC](https://community.glideapps.com/t/timestamp-on-updating-a-cell/55908/5 "2022-12-20T19:34:30Z")
> [@Jeff\_Hager](#): > > Another option would be to have a user specific column to temporarily hold the status. Your choice component would fill the user specific column. On the way into the detail screen, you would set the user specific status column with the value in the status column. On the detail screen, you could have a Save or Submit button that copies the user specific status to the status. So a user could choose a status and click on a submit button directly on the detail screen, but that submit button could also set a date column. This is what I would do ☝ ---
**Author:** ![HL\_OF\_SB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hl_of_sb/32/16654_2.png) [@HL\_OF\_SB](https://community.glideapps.com/u/HL_OF_SB)\ **Post date:** [February 20, 2023, 3:04am UTC](https://community.glideapps.com/t/timestamp-on-updating-a-cell/55908/6 "2023-02-20T03:04:48Z")
Hi , I have been using edit screen to update time stamp by using special value component. But its seems no working on Edit screen for the last few days. Any issue on the special value component? Thanks ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 20, 2023, 4:44am UTC](https://community.glideapps.com/t/timestamp-on-updating-a-cell/55908/7 "2023-02-20T04:44:30Z")
I haven’t had a chance to try it out myself, but it sounds similar to what’s happening in this thread, so I’m not sure if there is a bug or what’s going on. > [@Special value "User's email address" not working anymore](https://community.glideapps.com/t/special-value-users-email-address-not-working-anymore/58131): > > Hi, I have an application in production used daily by tens of users since 3rd of Jan. Today users reported me that something was going wrong. I found that special value “User"s emai address” is not set anymore. I use it to identify who has made the udpate of a record but this field is now left as blank… Any idea ? Any recent change ? Laurent