Applies to
- Business
- Enterprise
Capabilities
Who can use this capability
Dynamic View is an add-on capability for Business and Enterprise plans.
Dynamic View Admins have the highest level of view access.
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.
You can surface information on a row with a vendor, allowing them to view and edit that data – and only that data. Dynamic View ensures the vendor won't have access to data you don't want them to see.
To create a highly personalized experience, embed a Dynamic View in a Smartsheet dashboard using the web content widget.
Before you create views in Dynamic View
- Make sure you have all the Dynamic View app essentials in place.
- Create the source sheets and reports to hold your process and set permissions for view creators.
Start a new view
- Sign in to Dynamic View with your Smartsheet credentials.
- In the upper-right area of the screen, select Create View. You will see the sheets and reports available to create new Dynamic Views.
- Select the item to create your View from, and select Create. If you selected the wrong source item, create another new view. You can't go back and select a different source item.
Name your View and set overall permissions
Enter a name for the View, set what people can view, and if they can add new items to a source sheet.
Here are a few things to know about the settings in this step:
- Review by current user: You can filter a user's View on the tasks assigned to them via the Contact List column.
- Restrict View by sheet filter: Sheet filters help you refine what data appears in the View.
- New Item Submission: You can allow users to create new entries. When defining your sources, if you allow new item submissions and 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 a form instead. A form will ensure your data is consistent – and it's another way to ensure everyone uses their View correctly.
Select which fields appear in the grid
- In the Available fields section, select the fields you want to display in the View.
- To filter data on specific fields, add any dropdown or symbol fields from your source data. For example, if you want to filter your View by the status of tasks, you must first add the status field to Visible fields.
- Optional: Add attachments or comments with the following settings:
- Attachments
- Display attachments
- Users can add attachments
- Comments
- Display comments
- Users can add comments
- Attachments
The fields you select in this step will appear as columns and rows in the Dynamic View. 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 on the Details Panel tab.
Configure the details pane
When the user selects a row in the Dynamic View, the details pane appears and you can decide what appears in it.
Use the details pane to gather more information and provide more details. You can select attachments and comments to appear and set specific fields to be editable.
- From the Available fields section, drag the fields you want to add to the Details Panel Layout section.
- (Optional) Toggle Details panel description and enter instructions for your users. They'll see your message when they open the details view from within a Dynamic View.
- Select the tab you want to appear first when your users open the Dynamic View: data, attachments, or comments.
- Select the field you want to configure.
- Edit the field properties or logic. Field properties define the field – required, read-only, hide, where field 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 pane will open by default. - To edit the field logic, select the Field Logic icon in the right-hand bar.
- On the right-hand bar, select the Field Properties icon.
Field properties
Use this |
To do this |
Notes |
---|---|---|
Custom label |
Create a custom label for the field. |
To add a custom label, expand the Custom label box. |
Field options:
|
Set a field's level of importance. |
If you turn off all these options, the field will be optional and editable. |
Display as |
Fine-tune the field size. |
Select an option:
|
Initial value |
Set a default value in a field. |
If you allow new submissions to the View, the value you add in this field will be the default value. |
Field logic
When you add field logic, your View will show or hide fields based on the conditions or changes that happened either on the Smartsheet item or in Dynamic View.
Field logic relies on dropdown lists and symbol columns. You'll 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, ensure the dropdown values in a given column are consistent across all sheets in the report's scope. If a sheet is missing a value in the column properties for that dropdown, you may not be able to use that value in your field logic.
- In the Field Logic pane, select + Logic.
- Assign a name for your field logic.
- In the When section, identify the column and the value(s) which will trigger the logic.
- In the Action section, select what will happen 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.
- Choose the field(s) that will appear in or disappear from the View; then select Save.
Visibility permissions defined here appear in the Details pane. To access the Details pane, 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 or transfer a view
On the Sharing tab, you can
- Transfer ownership of the View
- Identify users and groups, and domains you want to have access to the View
- Specify administrators who can see and edit source data from the View and edit the view settings.
Admins can edit all settings for the View, including what other people will be able to view and access. Limit your number of view Admins to people who are responsible for changing your process.
Why is a field read-only?
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