Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Field/Column Alert
Is there a way to set up an "on screen" alert when a specific text/number is added to a particular column? We use Smartsheet to manage client's jobs as well as deadlines. Some of our client's have a specific template that they would like for us to use and it can be a bit overwhelming when we deal with hundreds of clients. Ideally, I would like to be able to enter in the first portion as the client's ID (e.g.: 100555-), followed by the second portion of the number that pertains job ID (e.g.: 100555-XXXXXX). I would like an alert displayed when the Client ID numbers (100555-) were entered. Any and all replies will be great appreciated.
Thank you,
Steven
Comments
-
Steven,
You could use conditional formatting and contains "100555". Then highlight the whole row, or just the one customer ID cell.
Shawn
-
Thank you!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives