samedi 3 juin 2017

Making google sheets random numbers or choices not update after a certain date or condition

I'm using RANDBETWEEN to choose a random item from a list in Google Sheets.

After a certain condition is true, such as after DATEDIFF is <= 0, I want the random choice that was made to be locked in and not change on refresh.

But I want other values, for future dates, to change (in case the list of choices changes).




Aucun commentaire:

Enregistrer un commentaire