I have a text field with an 'Auto-Enter' calculation this is based on the content of another field. It's set to replace existing value.
Act field (this is the field with the auto-enter option)
When the record is created, a value is entered into this field.
Status (this is the field Act is based on)
This field has a value list with a number of entries:
The calculation currently changes the 'Act' field if Omit, or On Hold are selected. However, if CBB, or Final are selected the contents of the Act field is deleted. I would to update the script, so If the status is changed to CBB, or Final it does nothing...
Here's my script -
If ( Shot Status = "Omit" ; "Omitted" ; If ( Shot Status = "On Hold" ; "On Hold" ))