Field/Column Alert

Steven B.

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

SmSulli

Steven,

You could use conditional formatting and contains "100555".  Then highlight the whole row, or just the one customer ID cell.

Shawn

 

 

Steven B.

Thank you!