UpdateRow()

Info

The UpdateRow() function is a useful action formula for updating data in specific cells of a Google Sheets.

Guide

Like any other action formula, this formula is designed to be used in buttons, create a new button and find the ‘Update Row’ function under the Packs category, or you can drag and drop it from the Insert menu. Fill out the parameters as needed and you’re set!

Demo Gif

⁠

⁠

Parameters

SpreadsheetId : The unique id associated with your spreadsheet. The ID can be found in the URL of the spreadsheet. This value will autocomplete by searching for the docs name. Example: https://docs.google.com/spreadsheets/d/1k9leEZ2IrrMi-O_J2rhB6Ch8QHYaqHaVG4Zqt81ohSM/edit#gid=0

SheetId : The unique id of the ‘tab’ within the spreadsheet. The first sheet is always 0 . The value will be availble for autocompletion after the SpreadsheetId is filled out. Example: https://docs.google.com/spreadsheets/d/1k9leEZ2IrrMi-O_J2rhB6Ch8QHYaqHaVG4Zqt81ohSM/edit#gid=120526743

Row Range : the range of cells in typical A1Notation. If you want to update a single cell, just give the coordinate, such as B3. This action only supports updates on a single row ex: A1:E1 or a single column A1:A5 .

Values : a list of values to replace the values found within the Range. Values will be replaced left to right, or top to bottom depending on the data orientation.

Example

See

Updating Rows⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.