Application Questions and Answers «Google Spreadsheet»
Does not export data to Google Sheets
Congratulations! They made the settings, as if everything is ok. We don't understand what else is needed because the data is not exported to Google...
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...
Copyright © OneBox 2024
