Operation

Description

Replace with a specific value

Replaces the existing value with one that you enter here.

Erase existing value

For numeric fields, sets them to zero. For checklist fields removes all checked values. For all other field types, erases them (sets them to blank).

Add values to list

For checklist fields only, adds additional checked items to the existing list of checked values.

Remove values from list

For checklist fields only, removes these items to the existing list of checked values.

Number/date add

For numeric fields, adds this value to the existing one. For date fields, adds this number of days to the existing value.

Number/date subtract

For numeric fields, subtracts this value to the existing one. For date fields, subtracts this number of days from the existing value.

Number multiply

Multiplies the current value by the one you enter.

Search and replace

For text and memo fields, does a simple search for existing text values, then replaces the matching value with the new value, which can be blank.

Append text

Adds text to an existing string or memo field.

Assign the value of another field

Copies the value from another field to this one, only fields of the same or compatible type will be shown as options.

Assign a new time value only

For date/time fields like "Start" for assignments, changes only the time portion of the existing value to the one you select.

Assign a new date value only

For date/time fields like "Start" for assignments, changes only the date portion of the existing value to the one you select.