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	542	October 22, 2019
Reset values daily Ask for Help	21	6230	August 11, 2020
=Today() Report a Bug	5	807	June 1, 2020
Setting a daily number Ask for Help	2	234	May 24, 2021
Make date calculations in a math column Feature Requests	3	646	May 21, 2020

Google Formula

Related topics