Google Sheets Script. Overwrite Query function on a daily basis when column is filled

$30-250 USD

Imekamilika

Imechapishwa

over 6 years ago

$30-250 USD

Kulipwa wakati wa kufikishwa

Hi, I have a query function in a column that gets a currency exchange value from a date in column A. I would like a script that overwrites the query function in this column and control pastes special values of the data when the query function has been activated. The reason for this is there are about 40 entries per day in this column. Ive noticed the query function sometimes glitches so i would like it to override with the the value of that cell every day. But not override the rest of the data in the column. The screenshot is from a test sheet.

Google App Engine

Scripting

Kitambulisho cha mradi: 15416521

Kuhusu mradi

3 mapendekezo

Mradi wa mbali

Inatumika 7 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

Imetolewa kwa:

@ioanaprof

Dear Sir or Ms. I am John, pleased to meet you. All your requirements are achievable. Relevant Skills and Experience I'm well experienced in Google Apps Script and G Suite. Please, take a look at my portfolio in my profile. Thank you for your time ! John Proposed Milestones $30 USD - final deliverable

$30 USD ndani ya siku 3

5.0

(8 hakiki)

4.2

3 wafanyakazi huru wana zabuni kwa wastani $99 USD kwa kazi hii

@aanvikm

Hello Sir, I am an excellent Google Sheet developer and can certainly help you here with this project. Thanks Aanvik

$166 USD ndani ya siku 3

5.0

(1 hakiki)

1.8

@ketas

Dear, I have done many scripts/tool with Google Script. Could help you on this request. High quality guarantee ! Regards, Relevant Skills and Experience Google App Script / Google Sheet Proposed Milestones $100 USD - Finish

$100 USD ndani ya siku 2