I want to have the randbetween function only return a random number until a specific day, then stop changing. Is there a way to accomplish this in googlesheets?
=IF(today()<F1,randbetween(1,10),)
I tried something like this, but it would just go blank if it's false.
Aucun commentaire:
Enregistrer un commentaire