Tool to edit a formula column in a Gigasheet dataset. Use when you need to update an existing formula column with a new formula, rename it, or reposition it. The column must already exist and be a formula column created previously.
columnRequiredstringColumn identifier or name of the existing formula column to edit. This can be a column letter (e.g., 'J', 'K') or column name. The column must already exist and be a formula column.
handleRequiredstringUnique identifier (handle) of the dataset containing the formula column to edit. This is typically returned by file upload actions or can be found in the Gigasheet web app URL. Format: lowercase letters a-f, numbers, and underscores (e.g., 'f2ce9f7d_f429_402a_b0a0_5e5587feb608').
formulastringNew formula expression using column letters (e.g., 'G * 3', 'A + B'). This is the formula that will be applied to the column. Must be a valid Gigasheet formula expression.
columnNamestringNew name for the formula column. If not provided, the column name remains unchanged.
afterColumnIdstringColumn ID after which to position the edited formula column. If not provided, the column position remains unchanged.
literalFormulastringHuman-readable formula using actual column names instead of letters (e.g., 'Price * 3', 'Quantity * Rate'). This provides better readability and documentation of the formula logic.
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.