Back

Search for rows

This query returns rows from a Smartsheet sheet matching a keyword search across all column values.

Developer info

API endpoint slug: smartsheet.search_for_rows
Runtime method: performQuery("smartsheet.search_for_rows"}

Query fields

Sheet Dropdown list

Label: Sheet
Helper text: Choose the sheet to search.
Slug: sheet
Required: true
Can have default value: false

Search query Text input > Other

Label: Search query
Helper text: Keyword or value to search for across all columns.
Slug: search_query
Required: true
Can have default value: true

Ingredients

Row

Slug: row_id
Filter code: Smartsheet.searchForRows.RowId
Type: String
Example: 8901234567890123

Sheet

Slug: sheet_id
Filter code: Smartsheet.searchForRows.SheetId
Type: String
Example: 1234567890123456

Sheet name

Slug: sheet_name
Filter code: Smartsheet.searchForRows.SheetName
Type: String
Example: Q2 Roadmap

Row number

Slug: row_number
Filter code: Smartsheet.searchForRows.RowNumber
Type: String
Example: 42

Matched column name

Slug: matched_column_name
Filter code: Smartsheet.searchForRows.MatchedColumnName
Type: String
Example: Task

Matched value

Slug: matched_value
Filter code: Smartsheet.searchForRows.MatchedValue
Type: String
Example: Ship v2

Row summary

Slug: row_summary
Filter code: Smartsheet.searchForRows.RowSummary
Type: String
Example: Task: Ship v2 | Owner: jane@example.com | Status: In Progress

Row url

Slug: row_url
Filter code: Smartsheet.searchForRows.RowUrl
Type: Web URL
Example: https://app.smartsheet.com/sheets/1234567890123456?rowId=8901234567890123

Applets using this Query