Hello.
I am wanting to set up an automation rule that will turn all of the information in these cells to 0 at 6AM each morning. I also do not want it to ruin the conditional formatting on each cell.
The columns go all the way up to a count of 532. As you can see, 0=green, yellow=1, and 3>= red. As mentioned, I would like to know if their is an automation I can use to change all of these numbers into zeros at 6AM each morning without changing the conditional formatting for the cells. For clarity the values in each cell get pulled into a dashboard.
Thanks!