# Update Value in Timesheet **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** beginner\ **Created:** [April 22, 2021, 6:32pm UTC](https://community.thunkable.com/t/update-value-in-timesheet/1239650 "2021-04-22T18:32:50Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![richard8x8](https://avatars.discourse-cdn.com/v4/letter/r/7cd45c/32.png) [@richard8x8](https://community.thunkable.com/u/richard8x8)\ **Post date:** [April 22, 2021, 6:32pm UTC](https://community.thunkable.com/t/update-value-in-timesheet/1239650/1 "2021-04-22T18:32:50Z")
I am trying to create a timesheet where I can click a “Clock in” button and it puts the time in a specific row on Google sheets. I can’t get Thunkable to find the correct row based on the date (all dates are already typed into the first column of the sheet). Any ideas? ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [April 22, 2021, 6:41pm UTC](https://community.thunkable.com/t/update-value-in-timesheet/1239650/2 "2021-04-22T18:41:43Z")
It’s really hard to help if we can’t see how you set up your blocks. Post a screenshot and someone may have an idea of what to change to get it working. ---
**Author:** ![richard8x8](https://avatars.discourse-cdn.com/v4/letter/r/7cd45c/32.png) [@richard8x8](https://community.thunkable.com/u/richard8x8)\ **Post date:** [April 22, 2021, 7:16pm UTC](https://community.thunkable.com/t/update-value-in-timesheet/1239650/3 "2021-04-22T19:16:01Z")
![Screen Shot 2021-04-22 at 2.09.56 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/c/6c3774bdc3132467ac288543038d943656da6811.png) Here is how I set up my block and what the Google sheet looks like. The “for row id” part is where I don’t know what to put in there to target the correct row. I basically want it to search for today’s date in the 1st column of the sheet and then put the time value in the adjacent column on the same row. ![Screen Shot 2021-04-22 at 2.13.44 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/d/2dca210430ca1f9c211303f244409de39211c91c.png) ---
**Author:** ![catsarisky](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/catsarisky/32/100661_2.png) [@catsarisky](https://community.thunkable.com/u/catsarisky)\ **Post date:** [April 22, 2021, 7:20pm UTC](https://community.thunkable.com/t/update-value-in-timesheet/1239650/4 "2021-04-22T19:20:12Z")
I think you want a VLOOKUP. See this tutorial: [Performing a VLOOKUP in LocalDB](https://community.thunkable.com/t/performing-a-vlookup-in-localdb/66057) I’m thinking you can sub in Google Sheets for localDB without issues. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [April 22, 2021, 8:20pm UTC](https://community.thunkable.com/t/update-value-in-timesheet/1239650/5 "2021-04-22T20:20:54Z")
In Google sheet the row id is actually the row number of the sheet - 1. So to add the time in the 7th row in the sheet, set the row id in the block to 6. ---
**Author:** ![richard8x8](https://avatars.discourse-cdn.com/v4/letter/r/7cd45c/32.png) [@richard8x8](https://community.thunkable.com/u/richard8x8)\ **Post date:** [April 22, 2021, 8:56pm UTC](https://community.thunkable.com/t/update-value-in-timesheet/1239650/6 "2021-04-22T20:56:33Z")
Is there an easy way to just tell it “look for [todays date] in column 1”? ---
**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\ **Post date:** [November 8, 2024, 1:25pm UTC](https://community.thunkable.com/t/update-value-in-timesheet/1239650/7 "2024-11-08T13:25:04Z")