Get Sheet Module with Filter Rows - Smartsheet Bridge

Hi everyone,

I'm building a Smartsheet Bridge workflow to get the activated rows from my contact sheet and update another sheet.

I'm using the Get Sheet module to retrieve all row details, but it pulls in every row — including the ones I don't need.

To solve this, I tried using the JavaScript module to filter the rows, but I couldn't get it to work.

My goal is to filter the rows so that I only get those marked as active in the Status column.

Could someone guide me on how to achieve this?"

Thanks in advance!

Find more posts tagged with

Bridge

javascript

Accepted answers

All comments

KlausNoah

A good way to filter rows right in the get sheet module in smartsheet bridge is by using the ‘filters’ section to pull only the rows that match what’s needed. Like just the active ones in the status column. That way no extra scripting is needed and everything stays clean.

irel

Thanks for the suggestion! But the filter option in the Get Sheet module works a bit differently, it requires specifying a list of Row IDs or Row Numbers to include in the result, which means the output is static, i want to filter rows based on a column value (like 'active' in the status column).

irel

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.