Effective Collaboration in Smartsheet
UPDATED ACTUAL Questions And
CORRECT Answers
@mention - CORRECT ANSWER- ✔✔Tagging a shared collaborator in a comment to share
a published view of the sheet, send an alert, track in activity log, and add to contacts.
Highlight changes - CORRECT ANSWER- ✔✔Feature to identify 'Red' items in a project
status column without leaving the sheet.
Date based alerts - CORRECT ANSWER- ✔✔Notifying collaborators of key project dates
triggered on specific or date-based column dates.
Auto-fill - CORRECT ANSWER- ✔✔Automatically continuing formatting patterns and
adjusting cell references in Smartsheet.
Web Content widget - CORRECT ANSWER- ✔✔Uses URL or embed code to display
interactive content on a dashboard.
Contact List column - CORRECT ANSWER- ✔✔One of three specific column types
required to enable Card View in Smartsheet.
Attachments Summary - CORRECT ANSWER- ✔✔Tracks file name, date attached, and
name of the individual who attached the file.
Square brackets - CORRECT ANSWER- ✔✔Symbol placed around a column name with
spaces, special characters, or numbers in Smartsheet formulas.
Personal Message - CORRECT ANSWER- ✔✔Customization when adding a new
collaborator to help them understand their addition and usage.
Multiple contact list columns - CORRECT ANSWER- ✔✔Best for creating a filter for each
individual in Smartsheet.
, Admin permission - CORRECT ANSWER- ✔✔Required for adding additional options to a
dropdown list column in a sheet.
Hidden field - CORRECT ANSWER- ✔✔Allows input of default values in a column on a
sheet without the form submitter creating it.
Children() - CORRECT ANSWER- ✔✔Function leveraging sheet hierarchy to reference
rows indented below another row in Smartsheet.
Card View - CORRECT ANSWER- ✔✔Efficient way to view and reassign tasks by assigned
contacts in Smartsheet.
Grid and Gantt - CORRECT ANSWER- ✔✔Views available for display in the report widget
in Smartsheet.
Workspace and Sheet - CORRECT ANSWER- ✔✔Options to share a collaborator in
Smartsheet.
An update request - CORRECT ANSWER- ✔✔Allows a one-time change to a sheet without
sharing the recipient as a collaborator.
Created (Date) System column - CORRECT ANSWER- ✔✔Best column type for tracking
when a row was added to a sheet in Smartsheet.
Create an alert - CORRECT ANSWER- ✔✔Best way to keep track of new attachments
added to a sheet in Smartsheet.
MS Project, Excel, Trello, Google Sheets - CORRECT ANSWER- ✔✔File types that can be
imported as a new sheet in Smartsheet.
MS Project (XML), PDF, Google Sheet, Excel, Gantt to image (PNG) - CORRECT
ANSWER- ✔✔Formats in which a sheet can be exported in Smartsheet.
UPDATED ACTUAL Questions And
CORRECT Answers
@mention - CORRECT ANSWER- ✔✔Tagging a shared collaborator in a comment to share
a published view of the sheet, send an alert, track in activity log, and add to contacts.
Highlight changes - CORRECT ANSWER- ✔✔Feature to identify 'Red' items in a project
status column without leaving the sheet.
Date based alerts - CORRECT ANSWER- ✔✔Notifying collaborators of key project dates
triggered on specific or date-based column dates.
Auto-fill - CORRECT ANSWER- ✔✔Automatically continuing formatting patterns and
adjusting cell references in Smartsheet.
Web Content widget - CORRECT ANSWER- ✔✔Uses URL or embed code to display
interactive content on a dashboard.
Contact List column - CORRECT ANSWER- ✔✔One of three specific column types
required to enable Card View in Smartsheet.
Attachments Summary - CORRECT ANSWER- ✔✔Tracks file name, date attached, and
name of the individual who attached the file.
Square brackets - CORRECT ANSWER- ✔✔Symbol placed around a column name with
spaces, special characters, or numbers in Smartsheet formulas.
Personal Message - CORRECT ANSWER- ✔✔Customization when adding a new
collaborator to help them understand their addition and usage.
Multiple contact list columns - CORRECT ANSWER- ✔✔Best for creating a filter for each
individual in Smartsheet.
, Admin permission - CORRECT ANSWER- ✔✔Required for adding additional options to a
dropdown list column in a sheet.
Hidden field - CORRECT ANSWER- ✔✔Allows input of default values in a column on a
sheet without the form submitter creating it.
Children() - CORRECT ANSWER- ✔✔Function leveraging sheet hierarchy to reference
rows indented below another row in Smartsheet.
Card View - CORRECT ANSWER- ✔✔Efficient way to view and reassign tasks by assigned
contacts in Smartsheet.
Grid and Gantt - CORRECT ANSWER- ✔✔Views available for display in the report widget
in Smartsheet.
Workspace and Sheet - CORRECT ANSWER- ✔✔Options to share a collaborator in
Smartsheet.
An update request - CORRECT ANSWER- ✔✔Allows a one-time change to a sheet without
sharing the recipient as a collaborator.
Created (Date) System column - CORRECT ANSWER- ✔✔Best column type for tracking
when a row was added to a sheet in Smartsheet.
Create an alert - CORRECT ANSWER- ✔✔Best way to keep track of new attachments
added to a sheet in Smartsheet.
MS Project, Excel, Trello, Google Sheets - CORRECT ANSWER- ✔✔File types that can be
imported as a new sheet in Smartsheet.
MS Project (XML), PDF, Google Sheet, Excel, Gantt to image (PNG) - CORRECT
ANSWER- ✔✔Formats in which a sheet can be exported in Smartsheet.
