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:
AND(
[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

0 1 152
1 REPLY 1
Top Labels in this Space