Add specific text to a row, if a condition is met in another column in the same row?

Hello,

I would like to have Smart Sheet add the words "Bad Index" in the status column if index column is "647373". I can use conditional formatting to highlight the row, but when I try to use an automation trigger the whole column displays "Bad Index".

This is my workflow.

When I run the automation it marks the entire status column as "Bad Index" instead of the specific row.

I only want row 20 to show "Bad Index".

Find more posts tagged with

Support

Solution Center

Automations

Accepted answers

All comments

Paul Newcome

Include a condition of the column being equal to "647373". When you use the Run Now feature with automations, it will ignore triggers and only evaluate conditions. Since you have no condition listed, the Run Now feature will trigger on every row.

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.