Data Sheet

the data sheet provides a list view of your organization, which is helpful when you need to customize how you see your organization's data or edit the data for multiple employees at once you can use the data sheet as a source of truth for all the job and people data within your organization this page gives you the ability to create a customized view of your data for all of your planning needs you can control what data displays on the page by customizing the columns you need and sorting by a particular column you can also use filters to refine which employees and jobs are included in the list taking action on a person or job to access the actions like edit job, edit person or terminate, you can either click on the action button (button with three dots) right click on the row click on the expand button (button with diagnal opposing arrows) and select actions from the buttons on the side panel adding & removing columns you can quickly add a new column by clicking the ➕ in the last column header or any column header click the column header to and click "hide column" to remove it from the data sheet view you are still able to use the select columns menu to manage columns as well sorting columns click the column header then select "sort ascending" or "sort descending" to sort a column sorting columns new functionality column details hover over a header to view information about the field in the colum including type (icon) name field code sensitivity description summary calculated columns you can add any calculation to your sheet by inserting a new column with that calculation think of it like a formula in a spreadsheet that is applied to the whole column this data point can optionally be saved as a smart calculation field or can just exist within the context of the sheet copy + paste copy from charthop — select then copy any content, paste it onto a spreadsheet like excel or google sheets ✨ magic paste into charthop — copy data from another spreadsheet then paste it into the data sheet if the cells are editable for you and the values are valid, it will paste in then you can adjust or save the changes edit to edit a cell in the data sheet, either click the edit button (pencil icon) in the top right double click on a cell you wish to edit once you are done making edits, click save and review changes bulk edit to edit more than one person or job at a time, select multiple rows and right click on the selected rows and select bulk edit saving and restoring the data sheet to save the data sheet or restore it to the original state, rollover the data sheet tab at the top of the data sheet to select one of those options save and restore exporting and syncing the new data sheet and additional options above the data sheet on the right side, you will see a row of icons these options are edit mode (pencil icon) add multiple columns (column icon) add open job (plus icon) export and sync (download icon) copy all data & headers export to csv sync to excel/sheets https //www charthop com/pricing/ basic basic | | headcount planning headcount planning | compensation reviews compensation reviews | performance performance | engagement engagement | hris