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
- 66K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives