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".
Answers
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives