SMARTSHEETS PRODUCT CERTIFICATION PART 1 QUIZ WITH VERIFIED SOLUTIONS.

A row report can be displayed on a dashboard using the report widget in which two of the following views? Gantt Calendar Grid Card Gantt Card What Forms feature lets you reveal specific fields in a form based on the answers to other questions? Form Elements Conditional Logic Fields Settings Conditional Logic To quickly identify and review the changes that have been made to a sheet, use _________ Symbols column type Highlight changes Conditional formatting Format painter Highlight changes When writing a formula, what symbol do you type to make either a column or row reference absolute? ( ) Parentheses $ Dollar sign # Pound sign [ ] Square brackets $ Dollar sign Which column type would be best for assigning tasks to individual team members? Contact List column Created by System column Text/Number column Dropdown List Contact List column Scenario: You want to surface a count of at-risk tasks on a dashboard. You determine one option for doing so would be to use a drop-down column to mark a task at-risk. Question: Which one of the following column types can also be utilized to mark at-risk items that could be counted and displayed on a dashboard? System Generated Column Duration Column Date Column Symbol Column Symbol Column Indenting rows will add hierarchy and create relationships between rows. The hierarchy is applied to the entire row, but will only be visible in what part of the sheet? Leftmost column in grid view System column Primary column Row action indicators column Primary column Which of the following views must include two date columns in order to be displayed? Calendar Gantt Grid Card Gantt Which one of the following Automation Permissions settings only allows the users that are shared to a sheet to receive notifications and requests from the sheet? Limited Unrestricted Restricted Unlimited Restricted When adding a cell link to a sheet, which of the following can be the source of the data? Column names Metric widget on a dashboard Cell(s) in a sheet Cell(s) in a report Cell(s) in a sheet In order to enable Card View, your sheet must have at least one of three specific column types. Two of those columns types are Dropdown List and Symbol. What is the third column type? System Generated column Text/Number column Contact List column Date column Contact List column Which feature allows licensed collaborators [with at least Editor permissions] to audit and export changes made to the sheet? Conditional formatting Activity log Highlight changes View cell history Activity log Based on the settings shown above, what permission level would Don Miller have on the sheet? Owner Editor Admin Viewer Editor Scenario: Valentino created an alert to notify a contact in the "assigned to" column if their task is past due and incomplete. Valentino realized that one of his external contractors did not receive the notification when this occurred. Question: What is a likely reason an external collaborator does not receive an automated notification? The user must first be in your personal My Smartsheet Contacts list in order to receive the notification The Automation Permissions is not set to unrestricted so external collaborators would not receive the notification Valentino needed to create an approval request rather than an alert Alerts can only be sent to people in your account. You must send a request, to your System Administrator, that the collaborator be added to the account contact list The Automation Permissions is not set to unrestricted so external collaborators would not receive the notification Scenario: Joy is the director of a sales team that manages its pipeline in Smartsheet. Every time an opportunity status is marked as "Closed Lost", reps should provide detail in a column called "Reason Won/Lost". Question: What is an automated way for Joy to ask reps to fill out the "Reason Won/Lost" column if they do not initially do so? Set up a workflow that sends an automated Update Request when the opportunity status changes to "Closed Lost" and the "Reason Won/Lost" column is blank Create a Conditional Formatting rule that sends a request when a task is marked as "Closed Lost" Automate the workflow via a formula Set up an automated Approval Request any time the "Reason Won/Lost" column is left blank Set up a workflow that sends an automated Update Request when the opportunity status changes to "Closed Lost" and the "Reason Won/Lost" column is blank Which of the following is used when writing a formula to automate the checking of a box, raising a flag, or filling in of a star? 1 100% Return Yes 1 When you create a new form for a sheet in Smartsheet, the form is automatically populated with fields based on which sheet element? Primary column Drop-down list Columns Rows Columns The Notification Center: (select the two options that apply) Allows a user to forward a notification to a different user Displays a red icon when new notifications arrive Allows a user to create new alerts Allows a user to view and fulfill update requests Allows a user to view and fulfill update requests Displays a red icon when new notifications arrive Which type of cell link gets its value from a cell in another sheet? Source Destination Outbound Inbound Inbound You can share a collaborator to which two of the following? Workspace Folder Resource View Sheet Workspace Sheet Scenario: Shauna, a sheet level Admin, is receiving too many notifications from an established workflow. Shauna still wants to receive notifications from this workflow, but not as often. Question: Which one of the following options would reduce the number of notifications sent for a given workflow without changing the triggers? Add a conditional formatting rule to the alert Lock the row after the first notification is sent Change the frequency by editing the "Run workflow" settings Replace the rule with an update request Change the frequency by editing the "Run workflow" settings As the owner of a sheet, you would like to provide an external collaborator the ability to update their tasks regularly, but not have access to the underlying sheet. Which of the below actions meets this requirement? Send a row Schedule a recurring update request Share them to the sheet as a viewer Publish a "Edit by anyone" link Schedule a recurring update request Which three of the following functions does Drag-fill allow you to accomplish? Easily populate text in random cells Copy and paste text in sequential rows or columns Select and drag text formatting from one cell to the next Quickly apply a formula to multiple rows Copy and paste text in sequential rows or columns Select and drag text formatting from one cell to the next Quickly apply a formula to multiple rows Which one of the following is not an option to share a form? Add the form to a workspace and share the workspace Copy the form URL Email the form directly from Smartsheet Copy the form embed code and add it to a dashboard or webpage Add the form to a workspace and share the workspace To assign a task to multiple contacts within a single cell, you must enable multiple contacts. In what location can this functionality be enabled? In the Automation Permission Settings On the sheet summary Within your Personal Settings Within the column properties for a contact list column Within the column properties for a contact list column How is tagging a shared collaborator, in a comment via an @mention, an effective means of collaboration? It shares that collaborator a published view of the sheet so they can view the comment It adds the @mentioned individual to your My Smartsheet Contacts It instantly sends the @mentioned individual a notification with the comment It begins keeping track of the @mentioned individual within activity log It instantly sends the @mentioned individual a notification with the comment