Formula or field update question


#1

Is there a method to update or clear a numeric data entered field based on the value of another field. That is, field 1 is RED and field 2 is 456 … if I change field 1 to BLUE, is there a method to clear field 2 (remember its a data entry field). Essentially, saving a step to clear field 2 manually.

If checked Zapier, and doesn’t appear that could be used either.