Smartsheet Certification Exam | Questions and Verified Answers| 100% Correct| Graded A (2023/ 2024
Smartsheet Certification Exam | Questions
and Verified Answers| 100% Correct| Graded
A (2023/ 2024 Update)
QUESTION
Which Form Submission option allows form users to submit multiple entries one after the other?
Answer:
Reload the same form for another entry
QUESTION
What is the lowest permission level you need to edit data from a report?
Answer:
Editor
QUESTION
What will happen to the column headers on the sheet when form fields are removed from the
form?
Answer:
The column headers will remain on the sheet
QUESTION
Forms can be used to collect information from individuals inside or outside your organization.
Which two use cases could a form support?
Answer:
Survey Responses & Marketing Requests
QUESTION
Which two options enable you to add more columns to your report?
Answer:
1) In the toolbar, click “Columns”, then add additional columns 2) Right-click on any column
header in the report and select “Add Column”
QUESTION
What is the lowest permission level you need to create a form?
Answer:
Admin
QUESTION
Which form field option allows you to input a default value so that the form can input sheet data
without requiring the form submitter to create it or see the field?
Answer:
Hidden
QUESTION
What Forms feature lets you reveal specific fields in a form based on the answers to other
questions?
Answer:
Conditional Logic
QUESTION
What is the best approach to providing a collaborator viewer access to only a subset of data that
is tracked on a sheet?
Powered by https://learnexams.com/search/study?query=
What can be added to a dashboard to help users understand the data on a dashboard?
Text labels
Which option would allow someone to view a report if they are not shared to the underlying sheet(s)?
Add the report to a dashboard by using the Report Widget
Which file type cannot be uploaded using the image widget?
PDF
Which two views of a row report can be displayed on a dashboard using the report widget?
Grid, Gantt
What is the default label for the data in a metric widget?
Column name
Which dashboard widget type would be best to show a live updating budget number of a project?
Metric
How is embedding a form on a dashboard via the web content widget effective?
It allows an individual to complete a form submission without leaving the dashboard
Which widget behavior will allow the user to open the underlying sheet or report?
Open the data source
What symbol notes the beginning of a formula?
Which formula is the most scalable way to count the indented rows under “Carl Jackson”, knowing that you will be adding additional rows within this hierarchy?
=COUNT(CHILDREN())
I am adding a field called “Budget Total” in the Sheet summary of a sheet. What is the syntax to reference the “Budget Total” field in a formula?
[Budget Total]#
When adding a cell link to a sheet, which can be the source of the data?
Cell(s) in a sheet
When viewing a sheet, you want to have certain rows grab your attention, visually, if the task is at risk or past its due date. You can accomplish this by using which feature?
Conditional formatting
Which is used when writing a formula to automate checking a box, raising a flag, or filling in of a star?
1
Which column type would be best for assigning tasks to individual team members?
Contact List column
What symbols must be placed around a column name in a formula if the name includes a space, special characters, or numbers?
[ ] Square brackets
Which view must include two date columns in order to be displayed?
Gantt
What level of hierarchy should the CHILDREN() function should be placed on?
Parent row
Which column type would be best for visually representing the status of a row item?
Symbols column
Which is one of the three column types that are required to enable Card View?
Contact List column
Which function can be used in conjunction with another function such as COUNT() to reference all the cells directly indented under a parent row?
CHILDREN()
When hierarchy is applied to a row, where will it be visible?
Primary column
Which column type would be best for tracking when a row was added to a sheet?
Created (Date) System column
Which feature would you use to change the visual styling of a sheet based on an identified trigger?
Conditional formatting
Which formula would you use to add up sales opportunities for the Western region?
=SUMIF(Region:Region, “Western”, [Opportunity Value]:[Opportunity Value])
Scenario: Juan is currently managing the development of a new product. He has a team of four individuals with whom he assigns various tasks. Juan wants to quickly see tasks assigned to each person and reassign tasks as needed.
Question: Which one of the options below would be the most efficient way for Juan to accomplish this?
Juan needs to utilize Card View to view tasks by the “assigned to” contact column. He could then reassign tasks accordingly.
What is the lowest permission level needed to modify the criteria of the report?
Admin
When you create a new form for a sheet in Smartsheet, the form is automatically populated with fields based on which sheet element?
Columns
Which Form Submission option allows form users to submit multiple entries one after the other?
Reload the same form for another entry
What is the lowest permission level you need to edit data from a report?
Editor
What will happen to the column headers on the sheet when form fields are removed from the form?
The column headers will remain on the sheet
Forms can be used to collect information from individuals inside or outside your organization. Which two use cases could a form support?
Survey Responses & Marketing Requests
Which two options enable you to add more columns to your report?
1) In the toolbar, click “Columns”, then add additional columns 2) Right-click on any column header in the report and select “Add Column”
What is the lowest permission level you need to create a form?
Admin
Which form field option allows you to input a default value so that the form can input sheet data without requiring the form submitter to create it or see the field?
Hidden
What Forms feature lets you reveal specific fields in a form based on the answers to other questions?
Conditional Logic
What is the best approach to providing a collaborator viewer access to only a subset of data that is tracked on a sheet?
Publish a report and give them the link
What is the reason to create a current user report?
The Current User filter allows collaborators to see only the tasks they are assigned to
Which of the following is a way to provide access to a form?
Email the form directly from Smartsheet
Which feature in a sheet allows you to set criteria to only show certain rows while hiding all others?
Filters
How can a user modify a report to get different results?
Change the filter criteria
A user has opened a report that you shared to them but does not see any data. Which is a reason why that might occur?
The user is not shared to any sheets that the report is pulling data from
Which allows you to quickly identify and review the changes that have been made to a sheet?
Highlight changes
Which is helpful when you need to share a number of items with the same group of people?
Workspace
The “Send…” action, available from the row menu, allows you to provide a view-only version of one or more rows to anyone you specify. Which two options can be customized?
Columns included & custom message to recipient
What information is tracked for each attachment?
Date attached, File Name, Name of the individual who attached the file
When adding a new collaborator to a sheet or workspace, what should be customized to help the new collaborator understand why they are being added and how they should use the information?
Personal message
When viewing cell history, which three actions are displayed?
When the change was made, What information was entered in the cell, Who made a change
What is the minimum permission level you need to add or edit the options available in the Column Properties section of a dropdown list column?
Admin
Which type of user can create or own a sheet in Smartsheet?
Licensed user
You can share a collaborator to which two of the following?
Sheet, Workspace
Which feature allows licensed collaborators with proper permissions to audit and export changes made to the sheet?
Activity log
Both sharing and publishing are features that can be used to give view only access to a sheet. What is the difference between sharing a sheet as a viewer and sending a published link?
Viewing a shared sheet requires a collaborator to log in, viewing a published sheet may not
Which is a possible use-case for establishing an alert with a date as the trigger?
You want to be sent an email five days before the start of each task so that you can check in with key collaborators
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 Automation Permissions is not set to unrestricted so external collaborators would not receive the notification
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?
Change the frequency by editing the “Run workflow” settings
Which option serves as a trigger for an automated workflow?
When a date is reached
Which Automation Permissions setting only allows the users that are shared to a sheet to receive notifications and requests from the sheet?
Restricted
To dynamically add cell data in the subject and body of automated request messages, the column name must be wrapped inside which one as a placeholder?
{{ }} Double curly brackets
When a task becomes at-risk, the project manager wants the individual assigned to the task to be immediately notified. How could the project manager achieve this goal?
Create an alert to notify the assignee when a task is marked as at-risk
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
Scenario: You’ve created a form to gather new customer interest information. When new submissions are made, you need to assign a member of your sales team as the lead, who will follow-up with the customer.
Which one of the following workflows would be the most efficient way to quickly take action after a form submission is made?
Create an automated update request to notify you of any new form submissions and lets you assign a lead immediately
Which options describe the Notification Center?
Displays a red icon when new notifications arrive, Allows a user to view and fulfill update requests
sources;
https://www.gcu.edu/
https://yaveni.com/
https://www.rasmussen.edu/
https://www.chamberlain.edu/