Smartsheet Core Product Certification Exam
(New 2023/ 2024 Update) Questions and
Verified Answers| 100% Correct| Graded A
QUESTION
John wants to have his health column display a red symbol if a task is past its due date. Which
formula can he use?
Answer:
=IF([Due Date]@row < T...
Smartsheet Core Product Certification Exam
(New 2023/ 2024 Update) Questions and
Verified Answers| 100% Correct| Graded A
QUESTION
John wants to have his health column display a red symbol if a task is past its due date. Which
formula can he use?
Answer:
=IF([Due Date]@row < TODAY(), "Red")
QUESTION
What level of hierarchy should the CHILDREN() function be placed on?
Answer:
Parent row
QUESTION
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?
QUESTION
Which field type is available in a sheet summary?
Answer:
Contact List
,QUESTION
Olga added a field called "Budget Total" in their sheet summary. What is the syntax to reference
the "Budget Total" field in a formula?
Answer:
[Budget Total]#
QUESTION
What symbols must you use when referencing another sheet?
Answer:
{ } Braces
QUESTION
Marcos wrote a formula to check the box in a Complete checkbox column when the %
Complete is 100%. What is the recommended way to apply his formula to the rest of the
column?
Answer:
Convert it to a column formula
QUESTION
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." Which formula should
she use?
Answer:
=JOIN(ANCESTORS())
, QUESTION
What symbols must you place around a column name in a formula if the name includes a space,
special characters, or numbers?
Answer:
[ ] Square brackets
QUESTION
How do you reference the red ball in a symbol column in a formula?
Answer:
"Red"
QUESTION
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?
QUESTION
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?
Answer:
Duplicate the existing workflow
QUESTION
Valentino created an alert to notify a contact in the Assigned To column if their task is past due
and incomplete. He realized that one of his external contractors did not receive the notification
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller ace_it. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.49. You're not tied to anything after your purchase.