Spreadsheet Get Cell

Category: Spreadsheets

Reads one value from a complete spreadsheet row/column list using letters such as `A` or `AZ`, or a positive one-based number. `Not present`, `NOT_PRESENT`, `NONE`, an out-of-range column, and by default an empty cell return `defaultValue`. Use it with `spreadsheetForEachRow.rowVar` for explicit runtime column mapping without header inference.

Inputs

Input	Required	Value Kind	Types	Enum Values
row	yes	expression	—	—
column	yes	expression	—	—
defaultValue	no	expression	—	—
emptyAsDefault	no	expression	—	—

Notes

• Reads one cell from a complete row/column list using a runtime-selected column.
• Columns may be spreadsheet letters such as A or AZ, or positive one-based numbers. Not present, NOT_PRESENT, NONE, an out-of-range column, and by default an empty cell return defaultValue.
• Set emptyAsDefault to false only when an intentionally empty cell must remain distinguishable from a missing cell.
• This expression pairs with spreadsheetForEachRow.rowVar to implement explicit UI column mapping without guessing from header names.