Smartsheets Product Certification Part 1 Quiz with Complete Solutions

Smartsheets Product Certification Part 1 Quiz with Complete Solutions A _________ is helpful when you need to share a number of items with the same group of people. Workspace A manager wants to automatically ask a team member to add status comments to a row every week. What is the best way to achieve this? Ask the team member to cell link their comments into the sheet. Set the update frequency, for the cell link, to refresh weekly Create a filter for each team member and send the filtered view on a weekly basis Send a weekly recurring Update Request Send the comments thread directly to team members, on a weekly basis Send a weekly recurring Update Request A row report can be displayed on a dashboard using the report widget in which two of the following views? Gantt Calendar Grid Card Gantt Card 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. Select the two file formats the attachment can be sent as. CSV PNG Excel PDF Excel PDF Alerts with date-based triggers help keep collaborators aware of key dates. Which of the following is a possible use-case for establishing an alert with a date as the trigger? You want to notify all collaborators when a task is over budget You want to be sent an email five days before the start of each task so that you can check in with key collaborators You want to automatically let external vendors know when a task is not complete You want to automatically inform your boss when the status of a task becomes at-risk You want to be sent an email five days before the start of each task so that you can check in with key collaborators 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? Change sharing permissions Lock column Conditional formatting Filters Lock column 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 meets this requirement? Send a row Schedule a recurring update request Share them to the sheet as a viewer Publish a "Edit by anyone" link Schedule a recurring