Smartsheet Certification

Which column type would be best for visually representing the status of a row item?

•  Text/Number column

• Emoji column

• Symbols column

• Dropdown List column

When hierarchy is applied to a row, where will it be visible?

• Leftmost column in grid view

• System column

• Primary column

• Row action indicators column

Which column type would be best for assigning tasks to individual team members?

• Created by System column
• Dropdown List column
• Contact List column
• Text/Number column

When adding a cell link to a sheet, which can be the source of the data?

• Column names
• Cell(s) in a sheet
• Cell(s) in a report
• Metric widget on a dashboard

Which column type would be best for tracking when a row was added to a sheet?

• Created by System column
• Auto-Number column
• Created (Date) System column
• Date column

Which feature would you use to change the visual styling of a sheet based on an identified trigger?

• Function
• Highlighting tool
• Format painter
• Conditional formatting

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#
• [Budget Total]#
• #Budget Total
• #[Budget Total]

Which view must include two date columns in order to be displayed?

• Gantt
• Calendar
• Grid
• Card

Which conditional formatting rule takes priority in this situation?

• The one at the bottom
• None
• The one on the top
• Both

Which formula would you use to add up sales opportunities for the Western region?

• =COUNTIF(Region:Region, "Western", [Opportunity Value]:[Opportunity Value])
• =COUNTIF( [Opportunity Value]:[Opportunity Value], Region:Region, "Western")
• =SUMIF([Opportunity Value]:[Opportunity Value], Region:Region, "Western")
• =SUMIF(Region:Region, "Western", [Opportunity Value]:[Opportunity Value])