Smartsheet Certification Exam 2025 | Smartsheet
Product Certification Exam | Smartsheet Test Bank
| Updated Questions and Correct Answers |
Graded A+
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? ---------CORRECT 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? ---------CORRECT
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? ---------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? ---------CORRECT ANSWER-----------------IF()
Which function can you use to add up numerical values? ---------CORRECT
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? ---------CORRECT 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? ---------CORRECT ANSWER-----------------=IF([Due
Date]@row < TODAY(), "Red")
What level of hierarchy should the CHILDREN() function be placed on? ---------
CORRECT 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? ---------CORRECT ANSWER----------------
-=SUM([Opportunity Value]@row * [Commission Rate]$1)
What can you customize when you insert a hyperlink in a cell? ---------CORRECT
ANSWER-----------------Display text
Which takes priority when a sheet has 2 conditional formatting rules? ---------
CORRECT ANSWER-----------------The rule on the top
Which type of user can create or own a sheet in Smartsheet? ---------CORRECT
ANSWER-----------------Licensed
What permission is required to hide and unhide columns? ---------CORRECT
ANSWER-----------------Admin
Vivian uses a sheet to track the status of a project that she is managing. Several
cells are cell linked to a sheet that the IT director uses to track all IT projects.
Vivian updates her sheet.
When do the linked cells on the director's sheet update? ---------CORRECT
ANSWER-----------------When Vivian's sheet is saved
, Which column type tracks when a row was added to a sheet? ---------CORRECT
ANSWER-----------------Created (Date) column
Which are the 3 column types that can enable Card View? ---------CORRECT
ANSWER-----------------Contact List, Dropdown (Single Select), Symbol
Tyrone created a project plan sheet and is adding tasks. He added the first task,
then moved to the next row to add his second task.
What will automatically be copied down to the new row? ---------CORRECT
ANSWER-----------------Formatting
Which view must include 2 date columns in order to be displayed? ---------
CORRECT ANSWER-----------------Gantt
Which file type can you insert in a cell? ---------CORRECT ANSWER-----------------.gif
Alex is building a sheet to keep track of her tasks on a website project. She must
perform the same set of tasks for each webpage. She listed each webpage on her
sheet and has written out the tasks for the first one.
Product Certification Exam | Smartsheet Test Bank
| Updated Questions and Correct Answers |
Graded A+
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? ---------CORRECT 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? ---------CORRECT
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? ---------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? ---------CORRECT ANSWER-----------------IF()
Which function can you use to add up numerical values? ---------CORRECT
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? ---------CORRECT 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? ---------CORRECT ANSWER-----------------=IF([Due
Date]@row < TODAY(), "Red")
What level of hierarchy should the CHILDREN() function be placed on? ---------
CORRECT 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? ---------CORRECT ANSWER----------------
-=SUM([Opportunity Value]@row * [Commission Rate]$1)
What can you customize when you insert a hyperlink in a cell? ---------CORRECT
ANSWER-----------------Display text
Which takes priority when a sheet has 2 conditional formatting rules? ---------
CORRECT ANSWER-----------------The rule on the top
Which type of user can create or own a sheet in Smartsheet? ---------CORRECT
ANSWER-----------------Licensed
What permission is required to hide and unhide columns? ---------CORRECT
ANSWER-----------------Admin
Vivian uses a sheet to track the status of a project that she is managing. Several
cells are cell linked to a sheet that the IT director uses to track all IT projects.
Vivian updates her sheet.
When do the linked cells on the director's sheet update? ---------CORRECT
ANSWER-----------------When Vivian's sheet is saved
, Which column type tracks when a row was added to a sheet? ---------CORRECT
ANSWER-----------------Created (Date) column
Which are the 3 column types that can enable Card View? ---------CORRECT
ANSWER-----------------Contact List, Dropdown (Single Select), Symbol
Tyrone created a project plan sheet and is adding tasks. He added the first task,
then moved to the next row to add his second task.
What will automatically be copied down to the new row? ---------CORRECT
ANSWER-----------------Formatting
Which view must include 2 date columns in order to be displayed? ---------
CORRECT ANSWER-----------------Gantt
Which file type can you insert in a cell? ---------CORRECT ANSWER-----------------.gif
Alex is building a sheet to keep track of her tasks on a website project. She must
perform the same set of tasks for each webpage. She listed each webpage on her
sheet and has written out the tasks for the first one.
