Automatically update status when field is blank formula

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered
I need help writing a formula for:

When the field Assembly Hours is left blank, the Status of Change Order (which is a drop-down text field) goes to Awaiting Manufacturing 

When the field Material Hours is left blank, the Status of Change Order (which is a drop-down text field) goes to Awaiting Materials 


Thank you
Photo of SkyTriv

SkyTriv

  • 212 Points 100 badge 2x thumb

Posted 9 months ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
Try playing with dynamic form rules to accomplish this. 

If those fields are not visible for whatever reason, you can add this logic to an "Action" or a webhook to make the appropriate updates.