WorksheetsWeek 2 Quiz
Total questions: 15
Worksheet time: 11mins
Which among these are the components of an automated workflow?
Trigger
Condition
Filter
Action
______ are used on the Gantt View in Smartsheet to automatically calculate and adjust dates and duration
Dependencies
Time
Dependent
Formulas
If you remove a field on a form, how will it affect the column headers on the sheet?
The column headers will be removed from the sheet
The data on the sheet will be removed
The form fields are locked and cannot be deleted
The column headers will remain on the sheet
What is the best approach to providing a collaborator viewer access to only a subset of data that is tracked on a sheet?
Share them to the report but not the sheet
Share them to a summary report
Share them to both the report and the sheet
Publish a report and give them the link
You can share a collaborator to which two of the following?
Folder
Workspace
Sheet
Resource View
Which dashboard widget type would be best to show a live updating budget number of a project?
Shortcut
Metric
Rich Text
Hyperlink
Select the correct formula to automate the "Status" column value based on "% Complete" column value.
Tasks marked: 0% are "Not Started,"
> 0% and < 100% are "In Progress"
100% are "Complete"
=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row > 0, "In Progress", "Not Started"))
=COUNTIFS([Status]@row = 1, "Complete", IF([% Complete]@row > 0, "In Progress", "Not Started"))
=SUMIFS([% Complete]@row = 1, "Complete", ([% Complete]@row > 0, "In Progress", "Not Started"))
Formula results can still be viewed in reports, but they can't contain standalone formulas.
TRUE
FALSE
You can view any sheet or report that contains at least two ________ in Gantt View
Date Columns
Contact List
Text Column
Sign Column
Never copy and paste notes or information from the escalation resource directly into your communications with the customer unless specifically directed to do so by a representative.
TRUE
FALSE
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. Which of the below actions best meets this requirement?
This is not possible in Smartsheet
Share them to the sheet as a viewer
Schedule a recurring update request
The owner can check the sheet and email the collaborators everyday
Which file type cannot be uploaded using the image widget?
GIF
JPEG
PNG
If a case needs to be escalated, there's no need to email the customer about it.
TRUE
FALSE
What happens to my formulas if I use the "Move to Another Sheet" or "Copy to Another Sheet" commands to move or copy a row containing a formula to another sheet?
Formulas won't be preserved when you use these commands to move or copy rows
Nothing will change
Select the copy formula option
A problem which impairs or prevents the functions of a product.
Limits
Function
Bug
Feature
