| Assign to All |
Assign a value to all cells in the specified range. |
| Single-field |
Use a field (Operation Field), a specified value (Operation Value) and an operator to compose an update expression. If you compose the expression SmID +100 to update a field. A cell within the update range will be updated to the SmID field value plus 100. |
| Double-field |
Use two fields, the Operation Field 1 and Operation Field 2, and an operator to compose an update expression. If you compose the expression SmID + SmUserID to update a field. A cell within the update range will be updated to the SmID field value plus the SmUserID value. |
| Function |
Use a field (Operation Field) and a function to compose an update expression. If you compose the expression Abs(SmID) to update a field. A cell within the update range will be updated to Abs(SmID). |