Forum Discussion

AndreonnaGarret's avatar
AndreonnaGarret
Qrew Assistant Captain
8 years ago

Change a Status Automatically

I have a [Status] field that is a normal text field, with a list inside it. I have a checkbox that automatically checks if an estimate has been open for more than 30 days without becoming an order. This checkbox is the indication that the estimate should be marked expired in the status field. 

How do I make the status automatically change when that box is checked. Form rule didn't work because you would have to go in to edit each estimate first.  I need it to automatically mark the estimate as expired.  

Thanks!
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    You would need to make your 'status' field be a formula as well.  

    Most people handle this by having a "master Status" and a "manual" status.  

    That way the formula will update based on dates and other criteria that you define, while still allowing for manual overrides.