# Google Formula **URL:** \ **Category:** Ask for Help\ **Created:** [October 29, 2019, 7:35pm UTC](https://community.glideapps.com/t/google-formula/1492 "2019-10-29T19:35:10Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Christopher\_Breen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christopher_breen/32/649_2.png) [@Christopher\_Breen](https://community.glideapps.com/u/Christopher_Breen)\ **Post date:** [October 29, 2019, 7:35pm UTC](https://community.glideapps.com/t/google-formula/1492/1 "2019-10-29T19:35:10Z")
Does anyone know of a formula to input into sheets that will do a reset of a value based on a change in another cell… In non-formula terms: IF datecell\<\>date cell [so it changes] then reset workdone to 0 ---
**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:** [October 30, 2019, 1:38am UTC](https://community.glideapps.com/t/google-formula/1492/2 "2019-10-30T01:38:59Z")
Take a look at this thread. It’s something I tried that seemed to work. It involves turning on iterative calculations in the sheet. Maybe this would work for you with some modification to the formula. > [@'Snapshot' of a cell's contents (similar to copy-\>paste values)?](https://community.glideapps.com/t/snapshot-of-a-cells-contents-similar-to-copy-paste-values/1315): > > A2’s value is constantly changing. I’d like a ‘snapshot’ of A2 taken as soon as C2 is ticked. I’ve been told that this is only possible with VBA. Is that really true? ---
**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:** [October 30, 2019, 1:59am UTC](https://community.glideapps.com/t/google-formula/1492/3 "2019-10-30T01:59:59Z")
What sets workdone to a value other than 0, or maybe a better explanation of what you are trying to do? ---
**Author:** ![Christopher\_Breen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christopher_breen/32/649_2.png) [@Christopher\_Breen](https://community.glideapps.com/u/Christopher_Breen)\ **Post date:** [October 30, 2019, 2:15am UTC](https://community.glideapps.com/t/google-formula/1492/4 "2019-10-30T02:15:50Z")
Changing the date ---
**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:** [October 30, 2019, 2:21am UTC](https://community.glideapps.com/t/google-formula/1492/5 "2019-10-30T02:21:13Z")
So you want the date change to set workdone to 0 and a value other than 0? I’m confused. ---
**Author:** ![Christopher\_Breen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christopher_breen/32/649_2.png) [@Christopher\_Breen](https://community.glideapps.com/u/Christopher_Breen)\ **Post date:** [October 30, 2019, 2:34am UTC](https://community.glideapps.com/t/google-formula/1492/6 "2019-10-30T02:34:04Z")
I want the date change to reset the value to zero but as long as the date value =Today() it can be increased until the date value doesn’t = Today() in which case it would reset to 0 ---
**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:** [October 30, 2019, 3:11am UTC](https://community.glideapps.com/t/google-formula/1492/7 "2019-10-30T03:11:09Z")
I get that you want to workdone to reset when the date changes but I still don’t get how workdone gets incremented to begin with, I’m trying to play with this in a spreadsheet, but I’m stuck because I don’t know the entire scenario. You also didn’t mention the use of Today() as part of the formula to begin with, so that could change how I set up the formula. The problem I have is that I need a formula in workdone column so it can reset, but depending on how it’s incremented, this could be a problem. This gets complicated to accomplish because of all the circular dependencies in the calculations. Maybe the thread I posted above can help you out. Otherwise, a script would probably do what you want. ---
**Author:** ![James\_Castleden](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/james_castleden/32/692_2.png) [@James\_Castleden](https://community.glideapps.com/u/James_Castleden)\ **Post date:** [October 30, 2019, 6:11am UTC](https://community.glideapps.com/t/google-formula/1492/8 "2019-10-30T06:11:06Z")
Hi Jeff I couldn’t get the calculations to stop even when I’d turned on the limited iterations. Thanks, James ---
**Author:** ![Doomba](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/doomba/32/1133_2.png) [@Doomba](https://community.glideapps.com/u/Doomba)\ **Post date:** [October 30, 2019, 6:35am UTC](https://community.glideapps.com/t/google-formula/1492/9 "2019-10-30T06:35:40Z")
Would somebody be manually changing the date or do you just have =TODAY() in a cell that automatically changes the next day? ---
**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:** [October 30, 2019, 8:10pm UTC](https://community.glideapps.com/t/google-formula/1492/10 "2019-10-30T20:10:35Z")
That may have depended on all of the other formulas you have in your sheet. I was only experimenting with 1 row of data in one sheet, so it was very basic. Like I had said before, I don’t know the full repercussions of doing something like that. Kind of new and experimental for me.