How to save the first entry in cell in Google spreadsheets?

Hello, I need Your help here will briefly explain the problem. There are three columns: AMOUNT, cost, RESULT. In the AMOUNT column, the values will be moved automatically from other sheets. The value in the PRICE column will change constantly, and in the RESULT column the formula will be: SUM/PRICE. Example: AMOUNT - 100; PRICE 2; the Result is 50. But, if the price change, the result accordingly is another, and I need to save the first result, in order to work with him. How it can be implemented, and something I was stuck on this place. Please help to understand.
March 20th 20 at 11:19
1 answer
March 20th 20 at 11:21
With formulas it can be done.
But I think you can use scripts. The documentation is voluminous, never dealt with such, so the example can't show :(
the logic necessary to create a script that would using the trigger to run once every how many minutes or hours and just record the date in one cell and the value in another https://developers.google.com/apps-script/referenc... - Aylin_Herzog31 commented on March 20th 20 at 11:24

Find more questions by tags Google Sheets