Add, edit, and delete rows in a table using the inline grid editor, then commit your changes with a single click.
Required permission: Edit Table Data. This permission is available to Finance Users and Admins by default. Business Users can open a table but always see it in read-only mode.
Edit rows in the grid
- In the Workspace side navigation, select Tables.
- Select the table you want to edit.
- Edit a cell by selecting it and entering a new value. The grid enforces the column's data type as you type.
- Add a row by selecting Add Row and entering values.
- Delete a row by highlighting the row, then clicking Backspace on your keyboard
- Select Save to save your changes.
Note: Tables use a save-on-click model. Your edits are not saved live. If you navigate away from the table without selecting Save, your unsaved changes are discarded.
Note: Number columns reject non-numeric input, date columns present a date picker, dropdown columns present their defined options, and calculated columns cannot be edited.
Sort rows
- Select a column header.
- Select ascending or descending order.
Sorting does not change your data or affect other users. Calculated columns sort by their computed values.
Switch scenarios
- In View Mode, open the scenario dropdown above the grid.
- Select the scenario you want to view or edit.
The column structure stays the same across scenarios. Row data reloads for the selected scenario, and calculated columns recompute using that scenario's data. Edits in one scenario do not affect another.
Example
An HR Business Partner opens the Employee Roster table, adds a new hire as a row, and updates a termination date on an existing row. The Monthly Salary calculated column fills in automatically. She selects Save, and the data is immediately available to finance users who toggle that scenario building headcount models in their spreadsheets.