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.
Alert notification for when column goes from blank to...not blank?
Looking for a way to receive a notification for the first instance in which a cell goes from blank to filled. We need the date on which a designer is assigned for any given "GRS" project - but that designer may change over time. We are only concerned about the FIRST update. Any ideas on how to set up this kind of notification?
Have tried the following:
When: Designer changes to anything
In: any row where Tactic name contains GRS and Designer is blank
Email: Jaye Tatone right away
The way I took that was that I'll be notified when any blank Designer cell gets edited to contain anything other than a blank. However, I'm not receiving any notifications at all now.
Sure, I can set up an alert to notify me anytime it changes to anything, but then we need to cross-reference the project to see if we've already noted the first date a designer was assigned.
Hope that makes sense and would appreciate any workarounds!