1|Page
Smartsheet Certification Exam Version 1|| QUESTIONS
AND CORRECT DETAILED ANSWERS|| VERIFIED
EXAM!!!(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
,2|Page
met. - ANSWER-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.
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.
,3|Page
Juan needs to build a report for each person on his team.
From each of the reports, Juan would reassign tasks.
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
You want to know when new attachments are added to
your sheet without opening the sheet. Which of the
following is the best way to achieve this goal?
Create a conditional formatting rule to highlight rows with
new attachments
Audit Activity Log daily
, 4|Page
Create an alert to notify you when an attachment is added
or changed
Instruct collaborators to @mention you in the comments
after an attachment has been uploaded - ANSWER-Create
an alert to notify you when an attachment is added or
changed
A snapshot of a sheet or report can be shared via email
using the "Send as Attachment..." action. The sheet can
be sent once or on a recurring basis. Select the two file
formats the attachment can be sent as.
CSV
PNG
Excel
PDF - ANSWER-Excel
PDF
Scenario: You are using Smartsheet to plan, track, and
manage a project. In creating your sheet, you are
assigning tasks to collaborators. You need to make a
decision on whether to use several single Contact List
columns or enable multiple contacts to be assigned within
a single cell.
Question: In which one of the following scenarios is it best
to use several Contact List columns?
Smartsheet Certification Exam Version 1|| QUESTIONS
AND CORRECT DETAILED ANSWERS|| VERIFIED
EXAM!!!(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
,2|Page
met. - ANSWER-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.
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.
,3|Page
Juan needs to build a report for each person on his team.
From each of the reports, Juan would reassign tasks.
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
You want to know when new attachments are added to
your sheet without opening the sheet. Which of the
following is the best way to achieve this goal?
Create a conditional formatting rule to highlight rows with
new attachments
Audit Activity Log daily
, 4|Page
Create an alert to notify you when an attachment is added
or changed
Instruct collaborators to @mention you in the comments
after an attachment has been uploaded - ANSWER-Create
an alert to notify you when an attachment is added or
changed
A snapshot of a sheet or report can be shared via email
using the "Send as Attachment..." action. The sheet can
be sent once or on a recurring basis. Select the two file
formats the attachment can be sent as.
CSV
PNG
Excel
PDF - ANSWER-Excel
Scenario: You are using Smartsheet to plan, track, and
manage a project. In creating your sheet, you are
assigning tasks to collaborators. You need to make a
decision on whether to use several single Contact List
columns or enable multiple contacts to be assigned within
a single cell.
Question: In which one of the following scenarios is it best
to use several Contact List columns?
