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