Problem with alerts related to changing dates

Mary Farmer

A default date of 01/01/00 is used in the "Decert Date" field. We want users to be alerted when the 01/01/00 date changes to 'something else'. However, we DO NOT want users to be alerted when the 'something else' changes to 'something yet again'. I used the below setup but still received unwanted alerts. Any recommendations?

JamesB

@Mary Farmer Create a helper column and use the following formula.

=IF([Decert Date 00JS]@row="01/01/00",1,0)

Then create your automation to trigger when the helper column = 1. Then when it changes from that date, the helper will change to 0 and stay there unless it goes back to 01/01/00.

JamesB

@Mary Farmer Create a helper column and use the following formula.

=IF([Decert Date 00JS]@row="01/01/00",1,0)

Then create your automation to trigger when the helper column = 1. Then when it changes from that date, the helper will change to 0 and stay there unless it goes back to 01/01/00.

Mary Farmer

Thanks! Worked great!