I
I
int1002022-03-03 14:02:04
css
int100, 2022-03-03 14:02:04

How to make a cell add itself every month on a given date in Google Sheets?

It is necessary to make it so that, for example, there is an amount of 1000 in the cell. And a month later, she added 1000 to herself. In total, to get 2000 in this cell. Is it possible to do this?
Help those in the know.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
S
Sergey Goryachev, 2016-04-19
@by_roXe

So take any slider with a preview.
You have an event - transition to the next slide.
And attach the logo change to the event.
Basically a simple problem.
It can be implemented on bxSlider, it has a callback.

G
Grigory Boev, 2022-03-03
@int100

Make a trigger that will take a value and add 1000 to it

function trigger(){
  const delta = +1000;
  let range = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Лист1").getRange("A1");
  let oldValue = range.getValue() || 0;
  range.setValue(delta+oldValue);
};

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question