Formulas & Functions
When writing a formula, what symbol do you type to make either a column or row reference absolute?
$ Dollar Sign
This is helpful when you need to share a number of items with the same group of people.
Workspace
Which feature allows licensed collaborators [with at least Editor permissions] to audit and export changes made to the sheet?
Activity Log
How can a user modify a report to get different results?
Change the filter criteria
Which column type would be best for tracking when a row was added to a sheet?
Created (Date) System Column
The CHILDREN() function should be placed on which level of hierarchy?
Parent Row
What two elements can a collaborator be shared?
Sheet and Workspace
As the owner of a sheet, you would like to provide an external collaborator the ability to update their tasks regularly, but not have access to the underlying sheet. What action meets this requirement?
Schedule a reoccurring update request
Which Smartsheet feature allows you to compile information from multiple sheets and show only items that meet the criteria you specify?
Reports
Which column type would be best for visually representing the status of a row item?
Symbols Column
When entering formulas in Smartsheet, cell references use the syntax of column name and row number. What symbols must be placed around a column name when it includes a space, special characters, or numbers?
Which dashboard widget type would be best to show a live updating budget number of a project?
Metric
What permission level is able to add or edit the options available in a dropdown list column in a sheet?
Admin
When creating a form, what field allows you to input a default value into a column on a sheet without requiring the form submitter to create it.
Hidden
When a task becomes at-risk, the project manager wants the individual assigned to the task to be immediately notified. How could the project manager achieve this goal?
Create an alert to notify the assignee when a task is marked as at-risk
What is used when writing a formula to automate the checking of a box, raising a flag, or filling in of a star?
What is the default label for the data in a metric widget?
Column Name
An update request provides one-time Editor access. What feature could be used to allow information to be included in an update request, but restrict the recipient from making changes?
Lock Column
When you create a new form for a sheet in Smartsheet, the form is automatically populated with fields based on which sheet element?
Columns
When adding a cell link to a sheet, where does the source of the data come from?
Cell(s) in another sheet
Auto-fill is automatically applied by Smartsheet within every sheet. What two functions does auto-fill perform?
Continues pattern of formatting and applies formulas and adjusts cell formation to adjacent rows
Which dashboard widget type would be best to show a live updating budget number of a project?
Metric
A snapshot of a sheet or report can be shared via email using the "Send as Attachment..." action. The sheet can be sent once or on a recurring basis. What two file formats can the attachment can be sent as?
PDF or Excel
What Form Submission option allows form users to submit multiple entries one after the other?
Reload the same form for another entry
Which feature would you use to change the visual styling of a sheet based on an identified trigger?
Conditional Formatting