Getting Started

 View Only

Automation help - auto fill date when task status = available

  • 1.  Automation help - auto fill date when task status = available

    Posted 04-17-2020 14:34

    Hi there, 

    I think this is a simple automation but I was stuck here for a while. 

    I hope to set up an automation to update the "start date" of a task to "current date" when the task status is changed to "available".  I was able to set up the trigger (when "status" is changed and is equal to "available"), and a action ("start date" copy the value from the field "Current Date". ) 

    While this automation successfully updates the "start date" of a task to "current date" after I changed the status to "available", it updates something I don't want to --  it updates "start date" of other existing available tasks. 

    Result:
    Task 1 is changed to "available" on 4/10, and the "start date" is 4/10. 
    Task 2 is changed to "available" on 4/15, and the "start date" is 4/15. In addition, it updates Task 1's start date to 4/15 too. The second part is not what I want. 

    What did I missed here? Thank you very much. 

    Ning 
     




    ------------------------------
    Ning W
    ------------------------------