Spreadsheet.com's standard action types let you automatically update data in your worksheets when automations are triggered.
In Spreadsheet.com, Automations consist of two necessary parts (Triggers and Actions), and may also include Conditions. Triggers tell your automations when to be activated, while actions determine what Spreadsheet.com does. Spreadsheet.com can both take a standard action on an existing worksheet or an integration action with applications outside of Spreadsheet.com.
Standard action types are a great way to add or update data when other users make a change. For example, you can create a row in a personal tasks worksheet when your project manager adds new tasks in the team's project plan and assigns them to you, or update rows in your team's customer service ticket tracker when customers submit new tickets.
Once you've defined a trigger, you can define your action from the Action block by clicking the blue Add an action button.
Standard action types are those that occur within Spreadsheet.com and not integrated third-party services. Let's take a closer look at each standard action type.
With this action, you can automatically create a new row in a specified worksheet when the automation is triggered. Click the Worksheet button to specify the worksheet where the row will be created.
The Create row action can be used to create new rows in different worksheets than the one where the automation is triggered.
After selecting the desired worksheet, click the Row button to configure the new row that will be created. This will open the Create row dialog from where you can map columns from the source worksheet to the target worksheet.
Use the fields to type values manually, or click the plus icon in each row to select columns from the source worksheet.
With this action, you can automatically update a row in the same worksheet where the automation is triggered.
Click the Column button to select the column that will be updated, and the Value button to specify the column's new value. The cell that will be updated is the one in specified column of the same row that triggers the automation.
The Value button allows you to manually specify a new value for the updated row, or pull data from elsewhere in the row into the updated cell.
Columns with the Date or Date & time data type support the Current Date or Current Date & Time token actions, respectively. The Current Date & Time token auto populates a designated cell with the date and time at which an automation was triggered.
When you click the Value button, click on the plus icon to the right of the field and select Current Date or Current Date & Time from the dropdown.
These tokens can only be assigned to columns which are using the Date or Date & time data types. If you have not assigned one of these data types to the column in which your automation is being applied, neither action will be available within the actions dialog. For more information about data types, check out our Introduction to Data Types guide.
With this action, you can copy the row in which the automation occurs to the same or a different worksheet. Click Worksheet to select the destination where the row will be copied.
Similar to the Create row action, clicking the Row button will let you map columns from the source worksheet to the target worksheet
With this action, you can move the row in which the automation occurs to the same or a different worksheet. Click Worksheet to select the destination where the row will be moved.
Moving a row will remove it from its original worksheet.