1|Page
Smartsheet Certification Exam Version 1||VERIFIED
EXAM!!|| QUESTIONS AND CORRECT DETAILED
ANSWERS(VERIFIED ANSWERS) |ALREADY GRADED
A+||NEWEST EXAM!!!
Which one of these functions can be used in conjunction
with another function such as COUNT() to reference all
the cells directly indented under a parent row?
ANCESTORS()
INDEX()
CHILDREN()
PARENT() - ANSWER-CHILDREN()
Which one of the following statements is untrue about
Conditional Logic in forms?
Editing the Column Type or Values of fields used in your
conditional logic may affect existing rules.
Target fields will only submit data to the sheet if they are
displayed when the form is submitted.
In order to submit the form, all required target fields must
be filled in, even if they aren't displayed due to logic on the
form.
Target fields will not be displayed by default, and they are
displayed when at least one of the source conditions are
met. - ANSWER-In order to submit the form, all required
,2|Page
target fields must be filled in, even if they aren't displayed
due to logic on the form.
What field type is not available in Sheet Summary?
Date
Text/Number
Contact List
Dropdown (Multi-Select) - ANSWER-Dropdown (Multi-
Select)
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 create and use a filter for each assignee
and then return to the sheet to reassign tasks.
Juan needs to utilize Card View to view tasks by the
"assigned to" contact column. He could then reassign
tasks accordingly.
Juan needs to build a report for each person on his team.
From each of the reports, Juan would reassign tasks.
,3|Page
Juan needs to publish the sheet to his team and allow
them to email ideas on how the tasks should be
reassigned. - ANSWER-Juan needs to utilize Card View to
view tasks by the "assigned to" contact column. He could
then reassign tasks accordingly.
Select which one of the following formats is not applicable
for exporting a sheet in Smartsheet.
Trello
PDF
Google Sheet
Excel
MS Project (XML)
Gantt to image (PNG) - ANSWER-Trello
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
Users no longer need to be shared to the form to complete
a form submission
Using an interaction setting, you can provide instant
access to the underlying sheet
It automatically captures who completed a form
submission in the dashboard's activity log - ANSWER-It
, 4|Page
allows an individual to complete a form submission without
leaving the dashboard
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?
Highlight changes
Conditional formatting
Format painter
Alerts - ANSWER-Conditional formatting
You want to use automated Alerts to alert someone
external to your organization who doesn't use Smartsheet.
Because the alert is for external collaborators you want to
safeguard the data on the sheet. Which option is the most
secure way to send an alert without providing access to
your data?
A
C
B - ANSWER-C
Which feature would you use to change the visual styling
of a sheet based on an identified trigger?
Smartsheet Certification Exam Version 1||VERIFIED
EXAM!!|| QUESTIONS AND CORRECT DETAILED
ANSWERS(VERIFIED ANSWERS) |ALREADY GRADED
A+||NEWEST EXAM!!!
Which one of these functions can be used in conjunction
with another function such as COUNT() to reference all
the cells directly indented under a parent row?
ANCESTORS()
INDEX()
CHILDREN()
PARENT() - ANSWER-CHILDREN()
Which one of the following statements is untrue about
Conditional Logic in forms?
Editing the Column Type or Values of fields used in your
conditional logic may affect existing rules.
Target fields will only submit data to the sheet if they are
displayed when the form is submitted.
In order to submit the form, all required target fields must
be filled in, even if they aren't displayed due to logic on the
form.
Target fields will not be displayed by default, and they are
displayed when at least one of the source conditions are
met. - ANSWER-In order to submit the form, all required
,2|Page
target fields must be filled in, even if they aren't displayed
due to logic on the form.
What field type is not available in Sheet Summary?
Date
Text/Number
Contact List
Dropdown (Multi-Select) - ANSWER-Dropdown (Multi-
Select)
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 create and use a filter for each assignee
and then return to the sheet to reassign tasks.
Juan needs to utilize Card View to view tasks by the
"assigned to" contact column. He could then reassign
tasks accordingly.
Juan needs to build a report for each person on his team.
From each of the reports, Juan would reassign tasks.
,3|Page
Juan needs to publish the sheet to his team and allow
them to email ideas on how the tasks should be
reassigned. - ANSWER-Juan needs to utilize Card View to
view tasks by the "assigned to" contact column. He could
then reassign tasks accordingly.
Select which one of the following formats is not applicable
for exporting a sheet in Smartsheet.
Trello
Google Sheet
Excel
MS Project (XML)
Gantt to image (PNG) - ANSWER-Trello
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
Users no longer need to be shared to the form to complete
a form submission
Using an interaction setting, you can provide instant
access to the underlying sheet
It automatically captures who completed a form
submission in the dashboard's activity log - ANSWER-It
, 4|Page
allows an individual to complete a form submission without
leaving the dashboard
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?
Highlight changes
Conditional formatting
Format painter
Alerts - ANSWER-Conditional formatting
You want to use automated Alerts to alert someone
external to your organization who doesn't use Smartsheet.
Because the alert is for external collaborators you want to
safeguard the data on the sheet. Which option is the most
secure way to send an alert without providing access to
your data?
A
C
B - ANSWER-C
Which feature would you use to change the visual styling
of a sheet based on an identified trigger?
