General Smartsheet Knowledge
Which of the following websites can you use to login to Smartsheet?
User A has 'Editor - Can Share' permissions on a document. Which of the following permissions can he grant a team member? Select all that apply.
a) Admin
b) Editor - Can Share
c) Editor - Cannot Share
d) Viewer
b) Editor - Can Share
c) Editor - Cannot Share
d) Viewer
User A would like to only view user information at 501 7th Avenue. What would be the most efficient solution?
a) Delete any rows that do NOT include 501 7th Avenue
b) Create a Filter to show rows containing Office Address: 501 7th Avenue
c) Conditionally format to highlight rows containing Office Address: 501 7th Avenue
d) Ctrl+F the document for rows containing: 501 7th Avenue
b) Create a Filter to show rows containing Office Address: 501 7th Avenue
TRUE OR FALSE
Smartsheet is a collaborative work management platform home to many TUG & CKNA key documents, such as calendars and project plans.
TRUE
User A would like to create an Agile Board. Which Smartsheet view would you recommend to User A?
a) Grid View
b) Gantt View
c) Card View
d) Calendar View
Card View
User A would like to collapse Subworkstream 1 underneath Workstream 1. What should User A do?
a) Outdent Workstream 1
b) Indent Subworkstream 1
c) Outdent Subworkstream 1
d) Indent Workstream 2
Fill in the blank. In Smartsheet, Reports/Sheets/Dashboards can be found in Workspaces or _______
Folders
Which of the following CANNOT be attached to a row?
a) Image
b) File Attachment
c) Comments
d) Link to a Smartsheet item
d) Link to a Smartsheet item
User A is unlicensed, but is an Editor - Cannot Share on Sheet A. Which of the following can User A do? Select all that apply.
a) Import an Excel file to automatically populate a Smartsheet document
b) Export an existing Smartsheet document as an PDF document
c) Send an Update Request to a teammate
d) Add a Comment for other document collaborators
b) Export an existing Smartsheet document as an PDF document
d) Add a Comment for other document collaborators
Unlicensed User A is a sheet Admin. Which of the following can User A do? Select all that apply.
a) Share sheet access with the Raw Materials team
b) Change Column 3's type from "Date" to "Contact"
c) Edit any cell EXCLUDING Column headers
d) None of the above
a) Share sheet access with the Raw Materials team
c) Edit any cell EXCLUDING Column headers
The goal plan "% Complete" pulls from the completion percentages of multiple project plans. Which of the below is the most efficient solution to ensure that the goal project plan "% Complete"?
a) Hyperlinking to the appropriate project plan's "% Complete" cell
b) Manually updating the goal plan % after each project plan update
c) Request that the Project Lead update the goal plan's "% Complete"
a) Hyperlinking to the appropriate project plan's "% Complete" cell
In the example, user A is trying to add Contacts to a cell, but Smartsheet does not recognize the contact. What could be the reason? Select all that apply.
a) Contact is not in our TUG & CKNA Smartsheet directory (user does not have Smartsheet account)
b) Contact does not have permissions to this specific Smartsheet document
c) Only Licensed users can add Contacts to a cell
d) The cell is not underneath the right Column type (Contact)
a) Contact is not in our TUG & CKNA Smartsheet directory (user does not have Smartsheet account)
d) The cell is not underneath the right Column type (Contact)
User A needs access to the CKU SP21 calendars. Who should they contact?
Andrew Presnal
Column "Smartsheet 101 Example 2" has three rows with the following cell content: 20%, 40%, 30%, in that order. The formula in Cell A is as follows: =AVG([Smartsheet 101 Example 2]1:[Smartsheet 101 Example 2]3)
What does Cell A display?
30%
In the example sheet, what formula could be used to display a Gray circle when % Complete=0, Yellow circle when % Complete 1-99%, and Green circle when % Complete 100%?
=IF([% Complete]1 = 0, "Gray", IF([% Complete]1 < 1, "Yellow", IF([% Complete]1 = 1, "Green")))