100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Smartsheet Core Product Certification Exam (New 2023/ 2024 Update) Questions and Verified Answers| 100% Correct| Graded A $10.49   Add to cart

Exam (elaborations)

Smartsheet Core Product Certification Exam (New 2023/ 2024 Update) Questions and Verified Answers| 100% Correct| Graded A

3 reviews
 783 views  26 purchases
  • Course
  • Smartsheet Certification
  • Institution
  • Smartsheet Certification

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...

[Show more]

Preview 3 out of 21  pages

  • December 19, 2023
  • 21
  • 2023/2024
  • Exam (elaborations)
  • Questions & answers
  • smartsheet certification
  • Smartsheet Certification
  • Smartsheet Certification

3  reviews

review-writer-avatar

By: lindseymaloo10 • 3 months ago

review-writer-avatar

By: sherrygrimm • 3 months ago

review-writer-avatar

By: searcy404 • 3 months ago

avatar-seller
ace_it
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?


Answer:
=SUM([Opportunity Value]@row * [Commission Rate]$1)



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?


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



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

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

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

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.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

78998 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$10.49  26x  sold
  • (3)
  Add to cart