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.
Notification when new State is added to list - unique list
I need to create a notification when we have an order shipped to a State we have not shipped that product to in the past.
The client's State is automatically added to the sheet from a workflow, and I need to get notified when ever we have a new State added to the list.
I think one way to do is this is to create a new formula that triggers the alert when new data is added. Is there a formula that will identify a "unique" State and add the State name to the column?
Or is there an easier way to create this notification?