1|Page
SMARTSHEET CERTIFICATION DETAILED COMPLETE QUESTIONS
AND ANSWERS EXAM A+ GRADED ||JUST OUT!!!
What is a key benefit to embedding a form on a dashboard via
the web content widget?
It provides increased efficiency as an individual can complete a
form submission without leaving the dashboard itself.
Users no longer need to be shared to the form to complete a
form submission.
It automatically captures who completed a form submission in
the dashboard's activity log.
Using an interaction setting, you can provide instant access to
the underlying sheet. - ANSWER-It provides increased efficiency
as an individual can complete a form submission without
leaving the dashboard itself.
Which type of user has the ability to create new items in
Smartsheet?
Free Collaborator
Unlicensed User
Licensed User
System Administrator - ANSWER-Licensed User
,2|Page
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 a conditional formatting rule to notify individuals when a
task is marked at-risk
Send the activity log to all shared users of a sheet
Use the send row functionality to send a row when the task is
marked as at-risk.
Create an alert to notify the assignee when a task is marked as
at-risk. Send the alert to the assigned to ( - ANSWER-Create an
alert to notify the assignee when a task is marked as at-risk.
Send the alert to the assigned to (Contact List column) right
away
Which function will determine the total number of items in a
specified range?
COUNT()
SUM()
AVG()
CHILDREN() - ANSWER-Count()
, 3|Page
When writing a formula, what symbol do you type to make
either a column or row reference absolute?
$ dollar sign
[ ] square brackets
( ) parenthesis
# pound sign - ANSWER-$ dollar sign
How is tagging a shared collaborator in a comment, via the use
of @mention, an effective means of collaboration?
It shares that collaborator a published view of the sheet so they
can view the comment.
It instantly sends the @mentioned individual an alert with the
comment.
It begins keeping track of the @mentioned individual within
activity log.
It adds the @mentioned individual to your My Smartsheet
Contacts - ANSWER-It instantly sends the @mentioned
individual an alert with the comment.
SMARTSHEET CERTIFICATION DETAILED COMPLETE QUESTIONS
AND ANSWERS EXAM A+ GRADED ||JUST OUT!!!
What is a key benefit to embedding a form on a dashboard via
the web content widget?
It provides increased efficiency as an individual can complete a
form submission without leaving the dashboard itself.
Users no longer need to be shared to the form to complete a
form submission.
It automatically captures who completed a form submission in
the dashboard's activity log.
Using an interaction setting, you can provide instant access to
the underlying sheet. - ANSWER-It provides increased efficiency
as an individual can complete a form submission without
leaving the dashboard itself.
Which type of user has the ability to create new items in
Smartsheet?
Free Collaborator
Unlicensed User
Licensed User
System Administrator - ANSWER-Licensed User
,2|Page
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 a conditional formatting rule to notify individuals when a
task is marked at-risk
Send the activity log to all shared users of a sheet
Use the send row functionality to send a row when the task is
marked as at-risk.
Create an alert to notify the assignee when a task is marked as
at-risk. Send the alert to the assigned to ( - ANSWER-Create an
alert to notify the assignee when a task is marked as at-risk.
Send the alert to the assigned to (Contact List column) right
away
Which function will determine the total number of items in a
specified range?
COUNT()
SUM()
AVG()
CHILDREN() - ANSWER-Count()
, 3|Page
When writing a formula, what symbol do you type to make
either a column or row reference absolute?
$ dollar sign
[ ] square brackets
( ) parenthesis
# pound sign - ANSWER-$ dollar sign
How is tagging a shared collaborator in a comment, via the use
of @mention, an effective means of collaboration?
It shares that collaborator a published view of the sheet so they
can view the comment.
It instantly sends the @mentioned individual an alert with the
comment.
It begins keeping track of the @mentioned individual within
activity log.
It adds the @mentioned individual to your My Smartsheet
Contacts - ANSWER-It instantly sends the @mentioned
individual an alert with the comment.
