SMARTSHEET CERTIFICATION EXAM
VERSION 2 2025 QUESTIONS AND
CORRECT ANSWERS
Pamela is creating a form to collect requests for her marketing
creative services team. In order to complete any request, she needs to
know which cost center to bill for the work. How can she ensure that
each request will contain the cost center? - ANSWER-Make the field
required
Which column records when a form was submitted? -
ANSWER-Created (Date)
What is the most efficient way to change the order that fields are
displayed on a form? - ANSWER-Drag-and-drop the fields on the form
builder
Which setting must you enable to automatically track who makes form
submissions? - ANSWER-Require people to log in to Smartsheet
Sergei has a sheet with a form to collect requests for his IT team. He
,wants every new submission to be assigned a Status of Not Started.
What is the recommended way for him to accomplish this? - ANSWER-
Assign a default value of Not Started and hide the Status field
Which column type can be displayed on a form as radio buttons?
- ANSWER-Dropdown (Single Select)
Reginald is managing requests for his IT team using a sheet with a form.
Employees can request the completion date in the "Date Need By"
column. The team member assigned to the work enters a date in the
"Estimated Completion Date" column.He wrote a formula to show if
requests are on track. The formula will display On Time or the number
of days late. The formula displays an error, #UNPARSEABLE.
Reginald's formula:=IF(([Estimated Completion Date]1 - [Date Need
By]1) = 0, On Time, ([Estimated Completion Date]1 - [Date Need
By]1))
Which section of the formula does Reginald need to correct? -
ANSWER-The value if true
Tricia has a task sheet where she is tracking both % Complete and
Status. Which function can she use to change the symbol in the Status
column based on the value in the % Complete column? - ANSWER-IF()
, Which function can you use to add up numerical values? -
ANSWER-SUM()
Guillermo owns a project tracking sheet. His sheet uses a hierarchy with
all tasks being children of a phase. He created a filter to help his team
see only their tasks. They are reporting that it is difficult to understand
the phase as there are tasks with the same name in multiple phases. To
help them understand the phase, he has added a column titled "Phase."
What function can he combine with JOIN() to show this information? -
ANSWER- ANCESTORS()
John wants to have his health column display a red symbol if a task is
past its due date. Which formula can he use? - ANSWER-
=IF([Due Date]@row < TODAY(), "Red")
What level of hierarchy should the CHILDREN() function be placed on?
- ANSWER-Parent row
Jennifer is building a sheet to calculate commissions for her sales team.
They earn a fixed percentage of each sale they make. She has entered the
commission rate in a cell on her sheet.
Which formula can Jennifer copy and paste into each row to correctly
calculate her team's commissions? - ANSWER-
VERSION 2 2025 QUESTIONS AND
CORRECT ANSWERS
Pamela is creating a form to collect requests for her marketing
creative services team. In order to complete any request, she needs to
know which cost center to bill for the work. How can she ensure that
each request will contain the cost center? - ANSWER-Make the field
required
Which column records when a form was submitted? -
ANSWER-Created (Date)
What is the most efficient way to change the order that fields are
displayed on a form? - ANSWER-Drag-and-drop the fields on the form
builder
Which setting must you enable to automatically track who makes form
submissions? - ANSWER-Require people to log in to Smartsheet
Sergei has a sheet with a form to collect requests for his IT team. He
,wants every new submission to be assigned a Status of Not Started.
What is the recommended way for him to accomplish this? - ANSWER-
Assign a default value of Not Started and hide the Status field
Which column type can be displayed on a form as radio buttons?
- ANSWER-Dropdown (Single Select)
Reginald is managing requests for his IT team using a sheet with a form.
Employees can request the completion date in the "Date Need By"
column. The team member assigned to the work enters a date in the
"Estimated Completion Date" column.He wrote a formula to show if
requests are on track. The formula will display On Time or the number
of days late. The formula displays an error, #UNPARSEABLE.
Reginald's formula:=IF(([Estimated Completion Date]1 - [Date Need
By]1) = 0, On Time, ([Estimated Completion Date]1 - [Date Need
By]1))
Which section of the formula does Reginald need to correct? -
ANSWER-The value if true
Tricia has a task sheet where she is tracking both % Complete and
Status. Which function can she use to change the symbol in the Status
column based on the value in the % Complete column? - ANSWER-IF()
, Which function can you use to add up numerical values? -
ANSWER-SUM()
Guillermo owns a project tracking sheet. His sheet uses a hierarchy with
all tasks being children of a phase. He created a filter to help his team
see only their tasks. They are reporting that it is difficult to understand
the phase as there are tasks with the same name in multiple phases. To
help them understand the phase, he has added a column titled "Phase."
What function can he combine with JOIN() to show this information? -
ANSWER- ANCESTORS()
John wants to have his health column display a red symbol if a task is
past its due date. Which formula can he use? - ANSWER-
=IF([Due Date]@row < TODAY(), "Red")
What level of hierarchy should the CHILDREN() function be placed on?
- ANSWER-Parent row
Jennifer is building a sheet to calculate commissions for her sales team.
They earn a fixed percentage of each sale they make. She has entered the
commission rate in a cell on her sheet.
Which formula can Jennifer copy and paste into each row to correctly
calculate her team's commissions? - ANSWER-
