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.

Triggering a notification based on the dates of two rows

Christian Jensen
Christian Jensen ✭
edited 12/09/19 in Archived 2017 Posts

I would like to create a notification to let me know a task will be finishing late, which will impact the start of another.

 

IF the 'Finish Date' of task 'Narrative' is greater than the "Start Date' of task 'Review' send notification

 

You can see in the screen shot that Hillary is going to be impacted on starting her work because 'Narrative' is going to finish late.

 

Smartsheet-DateNotification.PNG

Tags:
· Share on FacebookShare on Twitter

Comments

  • Alex Vorobiev
    Alex Vorobiev ✭✭✭✭✭

    Christian - great use case, thanks for sharing it.  Support for conditional notifications is coming out very soon (targeting late Feb), but it won't yet include an ability to compare column values to each other.  Comparing values across different rows would be even tricker.

     

    You might be able to accomplish this, however, by using a formula in a different column and then triggering your notification off that column.  Stay tuned for conditional notifications and you will be able to experiment with it as soon as they are out!

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories