Search by Term

Searches the specified sheet for a specific value based on a text string input, returns the first match it finds. The search can be a partial or exact match, but will return the first matching record.

Options

  • Your Smartsheet sheets (dropdown list): a list of all available Smartsheet sheets associated with your account.

Input Fields

  • Term (text): The term that you want to locate in the sheet.

Output Fields

  • id (text): returns the ID of the object that was searched for.

  • type (text): the type of the object where it found a match. The following types are possible results:

    • row
    • attachment
    • discussion
    • sheet