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

What sets workdone to a value other than 0, or maybe a better explanation of what you are trying to do?

So you want the date change to set workdone to 0 and a value other than 0? I’m confused.

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

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…

Hi Jeff I couldn’t get the calculations to stop even when I’d turned on the limited iterations. Thanks, James

Would somebody be manually changing the date or do you just have =TODAY() in a cell that automatically changes the next day?

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.

Google Formula

Ask for Help

Jeff_Hager October 30, 2019, 1:38am 2

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.

Topic		Replies	Views
'Snapshot' of a cell's contents (similar to copy->paste values)? Ask for Help	5	540	October 22, 2019
Reset values daily Ask for Help	21	6221	August 11, 2020
=Today() Report a Bug	5	806	June 1, 2020
Setting a daily number Ask for Help	3	228	January 17, 2024
Make date calculations in a math column Feature Requests	3	644	May 21, 2020

Google Formula

Related topics