# Google Formula **URL:** \ **Category:** Ask for Help\ **Created:** [October 29, 2019, 7:35pm UTC](https://community.glideapps.com/t/google-formula/1492 "2019-10-29T19:35:10Z")\ **Posts on this page:** 1\ **Showing post:** 2
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 30, 2019, 1:38am UTC](https://community.glideapps.com/t/google-formula/1492/2 "2019-10-30T01:38:59Z")
Take a look at this thread. It’s something I tried that seemed to work. It involves turning on iterative calculations in the sheet. Maybe this would work for you with some modification to the formula. > [@'Snapshot' of a cell's contents (similar to copy-\>paste values)?](https://community.glideapps.com/t/snapshot-of-a-cells-contents-similar-to-copy-paste-values/1315): > > A2’s value is constantly changing. I’d like a ‘snapshot’ of A2 taken as soon as C2 is ticked. I’ve been told that this is only possible with VBA. Is that really true? --- _[View the full topic](https://community.glideapps.com/t/google-formula/1492)._