Application Questions and Answers «Google Spreadsheet»
Problems with the work of formulas and conditional formatting in the table after deleting the script
After adding a script that controlled the transfer of the number from one sheet to another, and then removing it, the table had problems with the f...
finalize the option "do not update business process and process status after download"
please complete the automatic action "Import data from Google spreadsheets (Google Spreadsheet)" so that when updating processes (the "Search by pr...
Apps Script in Google Sheets for inserting values into empty cells
Please help me create a script for Apps Script in Google Sheets, which inserts a certain value (for example a dot) into empty cells in a certain co...
Export to Google tables depending on the value of the additional field
There was such a problem when I simply export any process fields to Google Sheets, everything works fine. But as soon as I set the condition for wh...
Import from google tables
There was such a problem when I import some non-existent data from google tables, new business processes are created. In the tables for the test, I...
Calculation formula with condition
Hi all! And a huge thank you to whoever helps me tweak the formula. There are several columns, in the first we select the type of payment (cash or ...
Setting up the unloading of warehouse balances in Google Spreadsheets
After configuring the unloading of warehouse balances into the Google OB table, the following error appears: { "error": { "code": 403, "message": "...
Formulas for searching and substituting under the name of all other data
I have a table that contains the first name, last name, department, code and date of employment of employees. I need to enter a formula in a separa...
Help finding a formula
Is it possible to choose a formula so that it can calculate how many "Failed" transactions were made only before the first "Completed"? All other t...
SUMIF function not working
In a cell, the SUMIF function with a date does not work, perhaps this is due to the fact that the date is not entered manually, but is triggered us...
Copyright © OneBox 2024
