Triggering a notification based on the dates of two rows

Christian Jensen

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.

 

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!