Change a Status Automatically

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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!
Photo of Andreonna

Andreonna

  • 1,040 Points 1k badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
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.