Skip to main content

Sheets

Understanding Sheets in PeopleGlass

Updated over 2 weeks ago

PeopleGlass Sheets enable users to display and interact with Salesforce data in a spreadsheet-like view with incredible ease.

Sheets are designed to be lightning quick and intuitive, which means anyone can get started creating powerful reports on their CRM data in no time!

You can start by either creating custom Sheets from Salesforce objects such as Accounts, Leads, and Opportunities, or by pulling in existing Salesforce Lists to use as templates.

Tip: Any updates to Salesforce fields made in Sheets affect real data in real time. As a result of this, there is no 'undo' functionality.

Anatomy of a Sheet

sheet2.png
  1. Existing Sheets: Any Sheets that you've created and/or opened in the past will be listed here. From this list, you can delete and duplicate Sheets by right-clicking on a Sheet's title.

  2. Create New Sheet: Build a Sheet from scratch or choose from a list of existing reports.

  3. Sheet Information: This is where key information about the currently loaded Sheet will be listed, including Sheet name, owner, and creation date.

  4. Filters: Use filters to refine your data down to exactly what you're interested in. Filters can be created using standard and/or custom CRM fields.

  5. Sorting: Use the sorting option to select by which columns, and in what order you'd like to display your data.

  6. Column Details: Use this dropdown menu to hide or delete a column, and add/clear a sort, filter, or freeze.

  7. Add Column: Choose from any available standard or custom CRM field to add to your Sheet.

  8. Share: Share your Sheet with the world! Use the sharing button to copy a shareable link to your Sheet, or set your Sheet to private.

  9. Manage Columns: Use the manage columns button to add or delete Sheet columns in one convenient view.

  10. Duplicate/Delete Sheet: Use this menu to either delete or duplicate your Sheet.

Key Features

  • Viewing Records

    PeopleGlass displays Salesforce records in a row format. Each row is a unique record in Salesforce. Salesforce fields are displayed in a column format. Each column is a unique field in Salesforce.

    Image_2022-07-26_at_16.40.23.png

  • Inline Updates

    Quickly make updates to data directly in PeopleGlass by double-clicking on a cell. Any changes made will get saved and automatically synced back to Salesforce.

    Image_2022-07-26_at_16.44.35.png

  • Filters

    Filters enable you to narrow down the scope of your data and create customized views based on what's important.
    Within PeopleGlass, you can easily create Sheets of "My Opportunities", "My Team's Accounts", and more by first applying a filter to determine scope and applying additional filters as needed.

    Image_2022-07-26_at_16.41.37.png

  • Sorting

    Sort multiple columns at once by either clicking on the Sort icon at the top left of the sheet next to the "Filters" icon, clicking on the three dots at the column header, or simply clicking on the column name.

    Image_2022-07-26_at_16.47.39.png

  • Search for Records

    Search for specific records on a Sheet by typing in keywords from any field on the sheet.

    Image_2022-07-26_at_16.48.53.png

  • Adding/Removing Fields

    Easily add and remove fields on a sheet based on what data is most important.
    If you do not see the fields that you want, add them to your Sheet by clicking the + button at the far right of your sheet.
    Alternatively, if there are fields you do not need, click on the three dots at the top of each column header to remove them.

    Image_2022-07-26_at_16.51.17.png

  • Comments

    Comments enable teams to work asynchronously and stay up-to-date on the latest changes to their pipelines. To add a comment, right-click on any field and click the Comment button.
    Users can also tag and mention their team members by typing @name in the comment thread. When doing so, please ensure the tagged teammate has access to your Sheet.

    Image_2022-07-26_at_16.57.50.png

  • Custom Columns

    Custom columns are PeopleGlass fields that are unique to the Sheets you create, and do not sync back to Salesforce. You can create custom columns to record private notes, allocate team resources, set alerts for upcoming meetings, and much more.

    Image_2022-07-27_at_11.26.05.png

  • Duplicate Sheets

    Click the three vertical dots at the top-right of a Sheet and click the Duplicate sheet option.

    Image_2022-07-27_at_11.29.04.png


    You can also right-click the title of your Sheet from the left-most navigation menu. Once a Sheet gets duplicated, it will open up a new Sheet titled, Copy of [Sheet Name].

    Image_2022-07-27_at_11.29.17.png

  • Delete Sheets

    Delete sheets that are no longer needed by right-clicking the title of the Sheet from the navigation menu and selecting Delete Sheet.
    Once a sheet gets deleted, it will be permanently removed from your content section in the sidebar. Please know that if the deleted Sheet was shared with any collaborators, they'll lose access unless they've duplicated the Sheet before deletion.

    Image_2022-07-27_at_11.42.44.png

  • Share Sheets

    Sheets can be shared in one of two ways: by sending a copy of the sheet directly to someone, or by copying the link to a clipboard and sending it more directly to a user for collaboration.

  • Bulk Edit

    To select the records you'd like to edit in bulk, click the top-most checkbox found to the left of your first column, or click individual records' checkboxes.
    Once the desired records are selected, use the panel on the right-hand side to select the field and value to update.
    Once done, this change will propagate into CRM in near-real time!

    Image_2022-07-27_at_12.18.23.png

  • Creating Sheets with Custom Objects

    To access a custom object, click the + sign next to My Content to add a new sheet. A drop-down menu with recommended objects will open; however, users can also search for custom objects by beginning to type the name of the custom object. Once found, click the object and choose which option fits best. For example, All Records, My Records, or start from scratch.

    Screen_Recording_2022-11-28_at_10.32.25_AM.gif

FAQ

  • How can I see Contacts from an Account Sheet view?
    To view the Contact related to Accounts from an Account Sheet, simply add a column and search for the Contact object. Once added, related Contacts will be displayed in this column.

  • How do I enter multiple lines of text in one cell?
    Press CMD+Enter (Mac) or CTRL+Enter (Windows) to go to the following line within the same text box.

    Image_2022-07-27_at_12.12.39.png


    This would only be supported for fields/columns that are in the "multi-line capable. The text box will expand when clicked twice. Please know that this functionality is only supported for the Long Text Area field type in Salesforce.

  • Is it possible to mass delete records using PeopleGlass?
    It's not currently possible to delete records from PeopleGlass. This must be done directly in CRM.

Have any questions? Drop us a line at support@people.ai.

Did this answer your question?