bitter_dandelion 🌟
2026-02-10 17:18 🇺🇸
If you're familiar with Google Sheets formulas, here is the formula I use for the counter (assuming the counter is in cell A2):
=IF(A1=TRUE, 0, IF(A2+1>3, 1, A2+1))
This first checks to see if A1, a tickbox used for resetting the animation and keeping it from updating, is ticked. If it is, it sets the counter to 0 until it's unticked.
If the reset box is unticked, it checks to see if incrementing the counter will go above the number of frames in the animation (in this case, 3). If it does, the counter is reset to 1, letting the animation loop.
Finally, if both above conditions are false, it increments itself by 1.
=IF(A1=TRUE, 0, IF(A2+1>3, 1, A2+1))
This first checks to see if A1, a tickbox used for resetting the animation and keeping it from updating, is ticked. If it is, it sets the counter to 0 until it's unticked.
If the reset box is unticked, it checks to see if incrementing the counter will go above the number of frames in the animation (in this case, 3). If it does, the counter is reset to 1, letting the animation loop.
Finally, if both above conditions are false, it increments itself by 1.
2