Reset on edit gives circular definitions error

Hi, I have a column called couriers, my requirement is to reset [couriers] when [status]=“Pending” for more than 5 days, the day [status] is set to pending is recorded in [Handover Date]. This is the expression I put in the reset on edit field:
[Status]=“Pending Delivery”,TODAY()>=[Handover date]+5
What is causing the issue and is there a possible work around. This expression already works as a filter in a slice to separate overdue deliveries in a view so I do not understand why it won’t work here.

Any help is greatly appreciated :smiley:

When Reset on edit? is ON, the Initial value expression may NOT reference its own column–you may not reference [couriers] in the couriers column Initial value expression.

1 Like