SMARTSHEET CORE PRODUCT EXAM |
QUESTIONS AND CORRECT ANSWERS
RATED A+ | 100% VERIFIED | 2026/2027
GUIDE
What is the most efficient way to change the order that fields are
displayed on a form? - Correct Answer - Drag-and-drop the fields on the
form builder
Which setting must you enable to automatically track who makes form
submissions? - Correct 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? - 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)
Which field type is available in a sheet summary? - Correct Answer -
Contact List
Olga added a field called "Budget Total" in their sheet summary. What is
the syntax to reference the "Budget Total" field in a formula? - Correct
Answer - [Budget Total]#
What symbols must you use when referencing another sheet? - Correct
Answer - { } Braces
QUESTIONS AND CORRECT ANSWERS
RATED A+ | 100% VERIFIED | 2026/2027
GUIDE
What is the most efficient way to change the order that fields are
displayed on a form? - Correct Answer - Drag-and-drop the fields on the
form builder
Which setting must you enable to automatically track who makes form
submissions? - Correct 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? - 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)
Which field type is available in a sheet summary? - Correct Answer -
Contact List
Olga added a field called "Budget Total" in their sheet summary. What is
the syntax to reference the "Budget Total" field in a formula? - Correct
Answer - [Budget Total]#
What symbols must you use when referencing another sheet? - Correct
Answer - { } Braces
