Tool to create a new column based on a formula input in a Gigasheet dataset. Use when you need to calculate values based on existing columns. This action creates a new column with values computed from a formula. You must reference columns by letter (e.g., 'A', 'B', 'C') using th…
handleRequiredstringUnique identifier (handle) of the dataset to which the formula column should be added. Example: 'f2ce9f7d_f429_402a_b0a0_5e5587feb608'
formulastringFormula expression using column letters (e.g., 'G * 2', 'A + B'). Use column letters like 'A', 'B', 'C' to reference columns. This field is required if you want to create a formula column.
columnNameRequiredstringName for the new formula column that will be created in the dataset.
afterColumnIdstringColumn identifier after which to insert the new formula column. If not specified, the column will be appended at the end.
literalFormulastringHuman-readable formula using actual column names for documentation purposes (e.g., 'Price * 2'). This should be provided alongside 'formula' for better readability. Cannot be used alone without 'formula'.
dataRequiredData from the action execution
errorstringError if any occurred during the execution of the action
successfulRequiredbooleanWhether or not the action execution was successful or not
API key connection. Risk level 2 of 5.
Free Action
No published Skills explicitly reference this Action yet.