Smartsheets Product Certification Part 1 Questions And Answers 100% Guaranteed Success.

Smartsheets Product Certification Part 1 Questions And Answers 100% Guaranteed Success. A row report can be displayed on a dashboard using the report widget in which two of the following views? Gantt Calendar Grid Card - correct answer. 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 - correct answer. 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 - correct answer. 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 - correct answer. $ 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 - correct answer. 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 - correct answer. 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 - correct answer. Primary column Which of the following views must include two date columns in order to be displayed? Calendar Gantt Grid Card - correct answer. 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 - correct answer. 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 - correct answer. 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 - correct answer. 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 - correct answer. Activity log Based on the settings shown above, what permission level would Don Miller have on the sheet? Owner Editor Admin Viewer - correct answer. 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 - correct answer. 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 - correct answer. 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 - correct answer. 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 - correct answer. 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 - correct answer. 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 - correct answer. Inbound You can share a collaborator to which two of the following? Workspace Folder Resource View Sheet - correct answer. 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 - correct answer. Change the frequency by editing the "Run workflow" settings