Download ✅ Smartsheet Certification Test | 100% Correct Answers | Verified 2025/2026 and more Exams Software Project Management in PDF only on Docsity!
Smartsheet Certification Test | 100% Correct
Answers | Verified | Latest Version
What can be added to a dashboard to help users understand the data on a dashboard? - ✔✔Text labels Which option would allow someone to view a report if they are not shared to the underlying sheet(s)? - ✔✔Add the report to a dashboard by using the Report Widget Which file type cannot be uploaded using the image widget? - ✔✔PDF Which two views of a row report can be displayed on a dashboard using the report widget? - ✔✔Grid, Gantt What is the default label for the data in a metric widget? - ✔✔Column name Which dashboard widget type would be best to show a live updating budget number of a project? - ✔✔Metric How is embedding a form on a dashboard via the web content widget effective? - ✔✔It allows an individual to complete a form submission without leaving the dashboard Which widget behavior will allow the user to open the underlying sheet or report? - ✔✔Open the data source What symbol notes the beginning of a formula? - ✔✔= Which formula is the most scalable way to count the indented rows under "Carl Jackson", knowing that you will be adding additional rows within this hierarchy? - ✔✔=COUNT(CHILDREN())
I am adding a field called "Budget Total" in the Sheet summary of a sheet. What is the syntax to reference the "Budget Total" field in a formula? - ✔✔[Budget Total]# When adding a cell link to a sheet, which can be the source of the data? - ✔✔Cell(s) in a sheet When viewing a sheet, you want to have certain rows grab your attention, visually, if the task is at risk or past its due date. You can accomplish this by using which feature? - ✔✔Conditional formatting Which is used when writing a formula to automate checking a box, raising a flag, or filling in of a star? - ✔✔ 1 Which column type would be best for assigning tasks to individual team members? - ✔✔Contact List column What symbols must be placed around a column name in a formula if the name includes a space, special characters, or numbers? - ✔✔[ ] Square brackets Which view must include two date columns in order to be displayed? - ✔✔Gantt What level of hierarchy should the CHILDREN() function should be placed on? - ✔✔Parent row Which column type would be best for visually representing the status of a row item? - ✔✔Symbols column Which is one of the three column types that are required to enable Card View? - ✔✔Contact List column Which function can be used in conjunction with another function such as COUNT() to reference all the cells directly indented under a parent row? - ✔✔CHILDREN() When hierarchy is applied to a row, where will it be visible? - ✔✔Primary column
Which two options enable you to add more columns to your report? - ✔✔1) In the toolbar, click "Columns", then add additional columns 2) Right-click on any column header in the report and select "Add Column" What is the lowest permission level you need to create a form? - ✔✔Admin Which form field option allows you to input a default value so that the form can input sheet data without requiring the form submitter to create it or see the field? - ✔✔Hidden What Forms feature lets you reveal specific fields in a form based on the answers to other questions? - ✔✔Conditional Logic What is the best approach to providing a collaborator viewer access to only a subset of data that is tracked on a sheet? - ✔✔Publish a report and give them the link What is the reason to create a current user report? - ✔✔The Current User filter allows collaborators to see only the tasks they are assigned to Which of the following is a way to provide access to a form? - ✔✔Email the form directly from Smartsheet Which feature in a sheet allows you to set criteria to only show certain rows while hiding all others? - ✔✔Filters How can a user modify a report to get different results? - ✔✔Change the filter criteria A user has opened a report that you shared to them but does not see any data. Which is a reason why that might occur? - ✔✔The user is not shared to any sheets that the report is pulling data from Which allows you to quickly identify and review the changes that have been made to a sheet? - ✔✔Highlight changes
Which is helpful when you need to share a number of items with the same group of people? - ✔✔Workspace The "Send..." action, available from the row menu, allows you to provide a view-only version of one or more rows to anyone you specify. Which two options can be customized? - ✔✔Columns included & custom message to recipient What information is tracked for each attachment? - ✔✔Date attached, File Name, Name of the individual who attached the file When adding a new collaborator to a sheet or workspace, what should be customized to help the new collaborator understand why they are being added and how they should use the information? - ✔✔Personal message When viewing cell history, which three actions are displayed? - ✔✔When the change was made, What information was entered in the cell, Who made a change What is the minimum permission level you need to add or edit the options available in the Column Properties section of a dropdown list column? - ✔✔Admin Which type of user can create or own a sheet in Smartsheet? - ✔✔Licensed user You can share a collaborator to which two of the following? - ✔✔Sheet, Workspace Which feature allows licensed collaborators with proper permissions to audit and export changes made to the sheet? - ✔✔Activity log Both sharing and publishing are features that can be used to give view only access to a sheet. What is the difference between sharing a sheet as a viewer and sending a published link? - ✔✔Viewing a shared sheet requires a collaborator to log in, viewing a published sheet may not
Scenario: You've created a form to gather new customer interest information. When new submissions are made, you need to assign a member of your sales team as the lead, who will follow-up with the customer. Which one of the following workflows would be the most efficient way to quickly take action after a form submission is made? - ✔✔Create an automated update request to notify you of any new form submissions and lets you assign a lead immediately Which options describe the Notification Center? - ✔✔Displays a red icon when new notifications arrive, Allows a user to view and fulfill update requests
