I have a custom function I'm using in Google Sheets that follows the following command order: VAR('API-reference','API-variable','date','refresh-cell'). I am wanting to autofill the date so that I can avoid manually typing in the date in each cell. However, when I try linking to a pre-made column of dates, the VAR function doesn't acknowledge the linked date.

How do I either change my VAR function to accept the linked columns or auto-fill the third variable within my function?

  • Looks like your function should be modified to accept at array of values instead of a single value. A simple example is here – user135384 Apr 8 '18 at 15:54
  • Please add input/output sample date as well how do you expect to write the formula. – Rubén Apr 8 '18 at 20:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.