1|Page
SMARTSHEET CERTIFICATION EXAM|| QUESTIONS
AND CORRECT DETAILED ANSWERS (VERIFIED
ANSWERS) |ALREADY GRADED A+||NEWEST EXAM!!!
Which of the following can be inserted into a formula to
automate the checking of a box, raising of a flag or filling
in of a star?
1
"Return"
100%
"Yes" - ANSWER-1
You've created a form to gather new customer information.
When new submissions are made, you must go into the
sheet and assign a member of your sales team as the
lead, who will then follow-up with the customer.
Which of the following workflows best addresses your
need to quickly take action after a form submission is
made?
Use the "Send as Attachment" feature to send yourself a
daily email with directions to assign a lead.
,2|Page
Create an alert to notify you when anything on the sheet
changes.
Send - ANSWER-Create an alert to notify yourself when a
new row has been added to the sheet.
The "Send..." action, available from the row menu, allows
you to provide a view-only version of one or more rows to
anyone you specify. Which two of the following options can
be customized?
File format of the rows (PDF or Excel)
Custom message to recipient
Delivery recurrence (once, every hour, every day, etc.)
Columns included - ANSWER-Custom message to
recipient and columns included
Which feature allows licensed collaborators [with at least
Editor permissions] to audit changes made to the sheet?
Conditional formatting
Activity log
View cell history
Highlight changes - ANSWER-Activity Log
, 3|Page
How can a user modify a report to get different results?
Add/delete rows from the report
Apply conditional formatting to the report
Change the criteria in the Report Builder
Select Edit Report from the File menu - ANSWER-Change
the criteria in the Report Builder
What is a key benefit to embedding a form on a dashboard
via the web content widget?
It provides increased efficiency as an individual can
complete a form submission without leaving the
dashboard itself.
Users no longer need to be shared to the form to complete
a form submission.
It automatically captures who completed a form
submission in the dashboard's activity log.
Using an interaction setting, you can provide instant
access to the underlying sheet. - ANSWER-It provides
increased efficiency as an individual can complete a form
submission without leaving the dashboard itself.
SMARTSHEET CERTIFICATION EXAM|| QUESTIONS
AND CORRECT DETAILED ANSWERS (VERIFIED
ANSWERS) |ALREADY GRADED A+||NEWEST EXAM!!!
Which of the following can be inserted into a formula to
automate the checking of a box, raising of a flag or filling
in of a star?
1
"Return"
100%
"Yes" - ANSWER-1
You've created a form to gather new customer information.
When new submissions are made, you must go into the
sheet and assign a member of your sales team as the
lead, who will then follow-up with the customer.
Which of the following workflows best addresses your
need to quickly take action after a form submission is
made?
Use the "Send as Attachment" feature to send yourself a
daily email with directions to assign a lead.
,2|Page
Create an alert to notify you when anything on the sheet
changes.
Send - ANSWER-Create an alert to notify yourself when a
new row has been added to the sheet.
The "Send..." action, available from the row menu, allows
you to provide a view-only version of one or more rows to
anyone you specify. Which two of the following options can
be customized?
File format of the rows (PDF or Excel)
Custom message to recipient
Delivery recurrence (once, every hour, every day, etc.)
Columns included - ANSWER-Custom message to
recipient and columns included
Which feature allows licensed collaborators [with at least
Editor permissions] to audit changes made to the sheet?
Conditional formatting
Activity log
View cell history
Highlight changes - ANSWER-Activity Log
, 3|Page
How can a user modify a report to get different results?
Add/delete rows from the report
Apply conditional formatting to the report
Change the criteria in the Report Builder
Select Edit Report from the File menu - ANSWER-Change
the criteria in the Report Builder
What is a key benefit to embedding a form on a dashboard
via the web content widget?
It provides increased efficiency as an individual can
complete a form submission without leaving the
dashboard itself.
Users no longer need to be shared to the form to complete
a form submission.
It automatically captures who completed a form
submission in the dashboard's activity log.
Using an interaction setting, you can provide instant
access to the underlying sheet. - ANSWER-It provides
increased efficiency as an individual can complete a form
submission without leaving the dashboard itself.
