Smartsheet Certification Practice Exam
Questions and Answers 100% Pass
Which is used when writing a formula to automate a checking a box, raising a flag,
or filling in of a star?
a. 1
b. 100%
c. Return
d. Yes - ANSWER-a. 1
(stats - either 1 or 0)
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?
a. Alerts
©️COPYRIGHT 2025, ALL RIGHTS RESERVED. 1
, b. Format painter
c. Highlight changes
d. Conditional formatting - ANSWER-d. conditional formatting
(can set condition that IF x is past due/at risk, THEN set y format to row)
Which view must include two date columns in order to be displayed?
a. Card
b. Gantt
c. Calendar
d. Grid - ANSWER-b. Gantt
(Gantt needs the start and finish columns to display the full timeline between those
two dates)
When adding a cell link to a sheet, which can be the source of the data?
a. Cell(s) in a report
©️COPYRIGHT 2025, ALL RIGHTS RESERVED. 2
Questions and Answers 100% Pass
Which is used when writing a formula to automate a checking a box, raising a flag,
or filling in of a star?
a. 1
b. 100%
c. Return
d. Yes - ANSWER-a. 1
(stats - either 1 or 0)
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?
a. Alerts
©️COPYRIGHT 2025, ALL RIGHTS RESERVED. 1
, b. Format painter
c. Highlight changes
d. Conditional formatting - ANSWER-d. conditional formatting
(can set condition that IF x is past due/at risk, THEN set y format to row)
Which view must include two date columns in order to be displayed?
a. Card
b. Gantt
c. Calendar
d. Grid - ANSWER-b. Gantt
(Gantt needs the start and finish columns to display the full timeline between those
two dates)
When adding a cell link to a sheet, which can be the source of the data?
a. Cell(s) in a report
©️COPYRIGHT 2025, ALL RIGHTS RESERVED. 2