SMARTSHEET CERTIFICATION PRACTICE TEST-63 QUESTIONS AND ANSWERS 2024

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 Brainpower Read More 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 column type would be best for tracking when a row was added to a sheet? Created (Date) System column Which feature would you use to change the visual styling of a sheet based on an identified trigger? Conditional formatting Which formula would you use to add up sales opportunities for the Western region? =SUMIF(Region:Region, "Western", [Opportunity Value]:[Opportunity Value]) Scenario: Juan is currently managing the development of a new product. He has a team of four individuals with whom he assigns various tasks. Juan wants to quickly see tasks assigned to each person and reassign tasks as needed. Question: Which one of the options below would be the most efficient way for Juan to accomplish this? Juan needs to utilize Card View to view tasks by the "assigned to" contact column. He could then reassign tasks accordingly. What is the lowest permission level needed to modify the criteria of the report? Admin When you create a new form for a sheet in Smartsheet, the form is automatically populated with fields based on which sheet element? Columns Which Form Submission option allows form users to submit multiple entries one after the other? Reload the same form for another entry What is the lowest permission level you need to edit data from a report? Editor What will happen to the column headers on the sheet when form fields are removed from the form? The column headers will remain on the sheet Forms can be used to collect information from individuals inside or outside your organization. Which two use cases could a form support? Survey Responses & Marketing Requests 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