1|Page
SMARTSHEETS PRODUCT CERTIFICATION EXAM
2025/2026– COMPLETE QUESTION BANK WITH VERIFIED
ANSWERS | REAL EXAM QUESTIONS | FREQUENTLY
TESTED | EXPERT STUDY GUIDE | GUARANTEED PASS
||GRADED A+||
What can be added to a dashboard to help users understand the data on a
dashboard? - ANSWER-Text labels
Which option would allow someone to view a report if they are not shared
to the underlying sheet(s)? - ANSWER-Add the report to a dashboard by
using the Report Widget
Which file type cannot be uploaded using the image widget? - ANSWER-
PDF
Which two views of a row report can be displayed on a dashboard using
the report widget? - ANSWER-Grid, Gantt
What is the default label for the data in a metric widget? - ANSWER-
Column name
Which dashboard widget type would be best to show a live updating budget
number of a project? - ANSWER-Metric
How is embedding a form on a dashboard via the web content widget
effective? - ANSWER-It allows an individual to complete a form submission
without leaving the dashboard
Which widget behavior will allow the user to open the underlying sheet or
report? - ANSWER-Open the data source
, 2|Page
What symbol notes the beginning of a formula? - ANSWER-=
Which formula is the most scalable way to count the indented rows under
"Carl Jackson", knowing that you will be adding additional rows within this
hierarchy? - ANSWER-=COUNT(CHILDREN())
I am adding a field called "Budget Total" in the Sheet summary of a sheet.
What is the syntax to reference the "Budget Total" field in a formula? -
ANSWER-[Budget Total]#
When adding a cell link to a sheet, which can be the source of the data? -
ANSWER-Cell(s) in a sheet
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? - ANSWER-Conditional formatting
Which is used when writing a formula to automate checking a box, raising a
flag, or filling in of a star? - ANSWER-1
Which column type would be best for assigning tasks to individual team
members? - ANSWER-Contact List column
What symbols must be placed around a column name in a formula if the
name includes a space, special characters, or numbers? - ANSWER-[ ]
Square brackets
Which view must include two date columns in order to be displayed? -
ANSWER-Gantt
What level of hierarchy should the CHILDREN() function should be placed
on? - ANSWER-Parent row
Which column type would be best for visually representing the status of a
row item? - ANSWER-Symbols column
Which is one of the three column types that are required to enable Card
View? - ANSWER-Contact List column
SMARTSHEETS PRODUCT CERTIFICATION EXAM
2025/2026– COMPLETE QUESTION BANK WITH VERIFIED
ANSWERS | REAL EXAM QUESTIONS | FREQUENTLY
TESTED | EXPERT STUDY GUIDE | GUARANTEED PASS
||GRADED A+||
What can be added to a dashboard to help users understand the data on a
dashboard? - ANSWER-Text labels
Which option would allow someone to view a report if they are not shared
to the underlying sheet(s)? - ANSWER-Add the report to a dashboard by
using the Report Widget
Which file type cannot be uploaded using the image widget? - ANSWER-
Which two views of a row report can be displayed on a dashboard using
the report widget? - ANSWER-Grid, Gantt
What is the default label for the data in a metric widget? - ANSWER-
Column name
Which dashboard widget type would be best to show a live updating budget
number of a project? - ANSWER-Metric
How is embedding a form on a dashboard via the web content widget
effective? - ANSWER-It allows an individual to complete a form submission
without leaving the dashboard
Which widget behavior will allow the user to open the underlying sheet or
report? - ANSWER-Open the data source
, 2|Page
What symbol notes the beginning of a formula? - ANSWER-=
Which formula is the most scalable way to count the indented rows under
"Carl Jackson", knowing that you will be adding additional rows within this
hierarchy? - ANSWER-=COUNT(CHILDREN())
I am adding a field called "Budget Total" in the Sheet summary of a sheet.
What is the syntax to reference the "Budget Total" field in a formula? -
ANSWER-[Budget Total]#
When adding a cell link to a sheet, which can be the source of the data? -
ANSWER-Cell(s) in a sheet
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? - ANSWER-Conditional formatting
Which is used when writing a formula to automate checking a box, raising a
flag, or filling in of a star? - ANSWER-1
Which column type would be best for assigning tasks to individual team
members? - ANSWER-Contact List column
What symbols must be placed around a column name in a formula if the
name includes a space, special characters, or numbers? - ANSWER-[ ]
Square brackets
Which view must include two date columns in order to be displayed? -
ANSWER-Gantt
What level of hierarchy should the CHILDREN() function should be placed
on? - ANSWER-Parent row
Which column type would be best for visually representing the status of a
row item? - ANSWER-Symbols column
Which is one of the three column types that are required to enable Card
View? - ANSWER-Contact List column
