Dynamic View: Create and manage views of your data

Dynamic View allows you to share sections of your sheet or report without sharing the underlying source sheet.

Who can use this?

Plans:

  • Business
  • Enterprise
  • Smartsheet Advance Package
  • Smartsheet Gov

Permissions:

Dynamic View Admins have the highest level of view access.

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

Dynamic View allows you to surface specific data for others to view and edit.  

Before you begin

Create the sheet or report to use as the source of your Dynamic View.

A sheet or report must exist before starting a Dynamic View.

Create a new view

There are two different ways to create Dynamic Views.

From Dynamic View home

  1. Select the Launcher icon and then select Dynamic View.
Dynamic View Details panel
  1. Start the view creation process by selecting Create View in the upper-right area of the screen or selecting the Plus icon  Start a new project, program, or process.  in the left navigation bar. The Create View window appears.
  2. Select the source sheet or report for your view in the Create View window. Then select Create.

The Settings window for your new view appears.

If you select the wrong source item, create another new view. You can't go back and select a different source item.

From the source item

In your source sheet, you can access Dynamic View from both Table and Grid views.

Table view
  1. Go to the main toolbar in your sheet.
  2. Select More tools > Dynamic View > Create Dynamic View.
Create dynamic view from table view
Grid view
  1. Select Dynamic View in the menu at the top of your sheet or report.
  2. Select Create Dynamic View. 
Dynamic View Details panel

The Settings window for your new view appears.

Configure your view

In the Settings > General tab for your view, you can name your view, set what people can see, allow people to add new items, and more.

Here are some key settings:

  • Review view by current user: Filter a user's view on their assigned tasks via the Contact List column. 
  • Restrict view by sheet filter: Sheet filters determine the data that appears in a sheet. Share sheet filters for multiple users to use the same filter. 
  • New Item Submission: You can allow users to create new entries. If your source is a report, specify the underlying sheet—not just the report. 

If you gather information from a wide range of users, you may find it useful to create an intake form instead of using New Item Submission. A form makes your data consistent, and it's another way to ensure everyone uses their view correctly.

Select the fields to display

In the Settings > View Display tab, you can select specific fields to show in your view.

  1. Select the View Display tab.
  2. In the Available fields section, select the fields you want to display in the view.
  3. To filter data on specific fields, add any dropdown or symbol fields from your source data. 
  4. Optional: Add attachments or comments with the following settings:  
    • Attachments
      • Display attachments
      • Users can add attachments
    • Comments
      • Display comments
      • Users can add comments

The fields you select in this step appear as columns in your Dynamic View rows. If you want to show fields only when certain conditions apply, don't add them in the Visible fields section. Instead, set the conditions or logic in the Details Panel tab.

Configure the Details panel 

In the Settings > Details Panel tab, you can customize the Details panel content that appears for users when they select a row in the Dynamic View. You can use the details pane to gather information and provide details. 

  1. From the Add Field section on the left, drag the fields to the Details Panel Layout section.
  2. (Optional) Switch on the Details panel description to enter instructions for your users. They see your instructions when they open the Details panel for a row in your view. 
  3. Select a tab to focus on when the Details panel appears. Here are the tabs:
    1. Data
    2. Attachments (if enabled)
    3. Comments (if enabled) 
  4. Edit properties or logic for each field. Field properties define the field, and logic allows you to apply conditional logic to the field. 
    • On the right-hand bar, select the Field Properties icon.
      When you select a field in the Details Panel Layout section, the Field Properties panel appears.
    • To edit the field logic, select the Field Logic icon in the right-hand bar.

Field properties

Use the following

To do the following

Notes

Custom label

Create a custom label for the field. 

To add a custom label, expand the Custom label box.

Field options:

  • Required
  • Read-only
  • Hide

Set a field's level of importance.

The field becomes optional and editable if you turn off all these options. 

Display as

Fine-tune the field size.

Select an option: 

  • Single Line
  • Multiple Line

Initial value

Set a default value in a field. 

If you allow new submissions to the View, the value you add in this field becomes the default value. 

Read-only field

Some fields may not be editable depending on their data type or the information in the cell. The following conditions make a field read-only in Dynamic View:

  • Field is from a System Column
  • Field is from a Gantt End Date Column
  • Field is the End date column in the date range display of the project settings
  • Field is from a Gantt Predecessor Column
  • Cell in source sheet contains a formula
  • Cell in source sheet contains an inbound cell-link
  • Cell in source sheet contains a hyperlink

Field logic

When you add field logic, your view shows or hides fields. This logic is based on the conditions or changes on the Smartsheet item or in Dynamic View.

Field logic relies on dropdown lists and symbol columns. You need a dropdown or symbol column in your source sheet to name and save your field logic rules.

If your source is a report with multiple sheets, the dropdown values in a given column must be consistent across all sheets. You can't use a value in your field logic if a sheet is missing a value in the column properties.

  1. In the Field Logic panel, select + Logic. 
  2. Assign a name for your field logic. 
  3. In the When section, identify the column and the values to trigger the logic. 
  4. In the Action section, select what happens when the View detects the trigger. You can: 
    • Hide selected fields.
    • Show selected fields as read-only.
    • Show selected fields as editable.
    • Show selected fields as required.
  5. Choose the fields that appear in or disappear from the View; then select Save.

Visibility permissions defined here appear in the Details panel. To access the Details panel, select a row in the View.

It's possible to create rules with conflicting actions. Dynamic View favors the rule with the lowest permission level.

Share your Dynamic View

Use the Settings > Sharing tab to set up who can see and edit the view. 

Refer to Share your Dynamic View for details.