Smart Sheet Exam Q & A Study Guide
Which field type is available in a sheet summary?
Correct Answer:
Contact List
How do you reference the red ball in a symbol column in a formula?
Correct Answer:
"Red"
Kai is building a sheet to track opportunities for his sales team. For each opportunity, the salesperson enters their Region and the Opportunity Value.Kai wants to know the total value of all opportunities in the Western region.Which formula should Kai use to add sales opportunities for the Western region?
Correct Answer:
=SUMIF(Region:Region, "Western", [Opportunity Value]:[Opportunity Value])
What level of hierarchy should the CHILDREN() function be placed on?
Correct Answer:
Parent Row
- / 3
Jennifer is building a sheet to calculate commissions for her sales team. They earn a fixed percentage of each sale they make. She has entered the commission rate in a cell on her sheet.Which formula can Jennifer copy and paste into each row to correctly calculate her team's commissions?
Correct Answer:
=SUM([Opportunity Value]@row * [Commission Rate]$1)
John wants to have his health column display a red symbol if a task is past its due date.
Correct Answer:
=IF([Due Date]@row < TODAY(), "Red")
Which function can you use to add up numerical values?
Correct Answer:
SUM()
What symbols must you use when referencing another sheet?
Correct Answer:
{ } Braces
What symbols must you place around a column name in a formula if the name includes a space, special characters, or numbers?
Correct Answer:
[ ] Square brackets
- / 3
Yoko created a report to show collaborators on her project their assigned tasks.They have told her that many tasks from different areas of the project plan look the same in the report. To solve the problem, she wants to add the parent name to the row in the report."
Correct Answer:
=JOIN(ANCESTORS())
Which option serves as a trigger for an automated workflow?
Correct Answer:
When a date is reached
Sandra has an alert workflow that notifies a sales manager when an opportunity in their region is Closed-Won. A manager for a different region learned of this and wants one for their region.What is the most efficient way for Sandra to start the new workflow?
Correct Answer:
Duplicate the existing row
Which action allows you to add additional actions after it within the same workflow?
Correct Answer:
Request an approval
- / 3