Problem with alerts related to changing dates


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?


Best Answer

  • JamesB
    JamesB ✭✭✭✭✭✭
    Answer ✓

    @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.