Smartsheet Certification Exam |
Questions and Verified Answers|
100% Correct| Graded A (2023/
2024 Update)/Smartsheet
Certification.
By lw
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? - CORRECT ANSWERS-The user is not shared to
any sheets that the report is pulling data from
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? - CORRECT ANSWERS-Viewing a shared sheet requires a collaborator
to log in, viewing a published sheet may not
Forms can be used to collect information from individuals inside or outside your
organization. Which two use cases could a form support? - CORRECT ANSWERS-
Survey Responses & Marketing Requests
How can a user modify a report to get different results? - CORRECT ANSWERS-
Change the filter criteria
How is embedding a form on a dashboard via the web content widget effective? -
CORRECT ANSWERS-It allows an individual to complete a form submission without
leaving the dashboard
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? - CORRECT ANSWERS-
[Budget Total]#
, 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? - CORRECT ANSWERS-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: 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? - CORRECT ANSWERS-Juan needs to utilize Card View to view tasks
by the "assigned to" contact column. He could then reassign tasks accordingly.
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? - CORRECT ANSWERS-
Change the frequency by editing the "Run workflow" settings
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? - CORRECT ANSWERS-The Automation Permissions is not set
to unrestricted so external collaborators would not receive the notification
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? - CORRECT ANSWERS-Create an automated
update request to notify you of any new form submissions and lets you assign a lead
immediately
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? - CORRECT ANSWERS-Columns included & custom message to
recipient
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? - CORRECT
ANSWERS-{{ }} Double curly brackets
Questions and Verified Answers|
100% Correct| Graded A (2023/
2024 Update)/Smartsheet
Certification.
By lw
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? - CORRECT ANSWERS-The user is not shared to
any sheets that the report is pulling data from
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? - CORRECT ANSWERS-Viewing a shared sheet requires a collaborator
to log in, viewing a published sheet may not
Forms can be used to collect information from individuals inside or outside your
organization. Which two use cases could a form support? - CORRECT ANSWERS-
Survey Responses & Marketing Requests
How can a user modify a report to get different results? - CORRECT ANSWERS-
Change the filter criteria
How is embedding a form on a dashboard via the web content widget effective? -
CORRECT ANSWERS-It allows an individual to complete a form submission without
leaving the dashboard
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? - CORRECT ANSWERS-
[Budget Total]#
, 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? - CORRECT ANSWERS-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: 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? - CORRECT ANSWERS-Juan needs to utilize Card View to view tasks
by the "assigned to" contact column. He could then reassign tasks accordingly.
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? - CORRECT ANSWERS-
Change the frequency by editing the "Run workflow" settings
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? - CORRECT ANSWERS-The Automation Permissions is not set
to unrestricted so external collaborators would not receive the notification
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? - CORRECT ANSWERS-Create an automated
update request to notify you of any new form submissions and lets you assign a lead
immediately
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? - CORRECT ANSWERS-Columns included & custom message to
recipient
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? - CORRECT
ANSWERS-{{ }} Double curly brackets
