Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@TTATPuOT
Created March 2, 2019 06:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save TTATPuOT/e2f58b0bd2805d40180a436de7e9f397 to your computer and use it in GitHub Desktop.
Save TTATPuOT/e2f58b0bd2805d40180a436de7e9f397 to your computer and use it in GitHub Desktop.
Exemple of error "#UNPARSED" in SmartSheets API
/**
* this.tableId - class variable with id of sheet. 3878809494677380 - for exemple
* @param {number} rowId - id of row like 7933217256826756 from api respond
* @param {number} columnId - id of column for set formula
*/
async updateFormula(rowId, columnId) {
let body = [
{
id: rowId,
cells: [
{
columnId: columnId,
formula: `=IF(Правок${row.rowNumber} < 2; [Обработано кадров]${row.rowNumber} * 10 + [Из них с вырезкой]${row.rowNumber} * 10; ([Обработано кадров]${row.rowNumber} * 10 + [Из них с вырезкой]${row.rowNumber} * 10) * (1,1 - 0,1 * Правок${row.rowNumber}))`
},
],
}
];
return this.smartsheet.sheets.updateRow({sheetId: this.tableId, body: body});
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment