Skip to main content
All CollectionsGooglesheets
How to Refresh Custom Functions (aka Formulas) in Googlesheets
How to Refresh Custom Functions (aka Formulas) in Googlesheets

You can easily refresh a single or multiple Cryptosheets custom functions and their data anytime with a simple checkbox

C
Written by Chris Ware
Updated over 4 years ago

Follow the steps listed below & shown in the video to refresh any Cryptosheets custom function (aka formula) in Googlesheets

  1. You can easily refresh a single or multiple Cryptosheets custom functions and their data anytime with a simple checkbox

  2. All you need to do is add the cell with the checkbox value as a global argument reference to the end of any of your Cryptosheets custom functions


​
πŸ‘‰ Setup a simple example in your Googlesheets using =CSPRICE to test updating data with a checkbox

​

​

πŸ‘‰ Use the last part of your Googlesheets formulas known as global arguments to reference a refresh cell

​

​

TAGS:
refresh, update, automatically, new data, live, live prices, latest, stale, old, won't refresh, CS.TIME, trigger, Google formulas, old data, wrong price
​


​
​

​

​

​

​

Did this answer your question?