Smartsheet Certification Complete Bundle: Core & Advanced Exam Prep 2025

Page 1 of 72


Smartsheet Certification Complete Bundle; All

Correct & Verified

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

,Page 2 of 72


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

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

,Page 3 of 72


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

, Page 4 of 72


Which is one of the three column types that are required to

enable Card View? .....ANSWER.....Contact List column

Which function can be used in conjunction with another function

such as COUNT() to reference all the cells directly indented

under a parent row? .....ANSWER.....CHILDREN()

When hierarchy is applied to a row, where will it be visible?

.....ANSWER.....Primary column

Which column type would be best for tracking when a row was

added to a sheet? .....ANSWER.....Created (Date) System column

Which feature would you use to change the visual styling of a

sheet based on an identified trigger? .....ANSWER.....Conditional

formatting

Which formula would you use to add up sales opportunities for

the Western region? .....ANSWER.....=SUMIF(Region:Region,

"Western", [Opportunity Value]:[Opportunity Value])