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
Les avantages d'acheter des résumés chez Stuvia:
Qualité garantie par les avis des clients
Les clients de Stuvia ont évalués plus de 700 000 résumés. C'est comme ça que vous savez que vous achetez les meilleurs documents.
L’achat facile et rapide
Vous pouvez payer rapidement avec iDeal, carte de crédit ou Stuvia-crédit pour les résumés. Il n'y a pas d'adhésion nécessaire.
Focus sur l’essentiel
Vos camarades écrivent eux-mêmes les notes d’étude, c’est pourquoi les documents sont toujours fiables et à jour. Cela garantit que vous arrivez rapidement au coeur du matériel.
Foire aux questions
Qu'est-ce que j'obtiens en achetant ce document ?
Vous obtenez un PDF, disponible immédiatement après votre achat. Le document acheté est accessible à tout moment, n'importe où et indéfiniment via votre profil.
Garantie de remboursement : comment ça marche ?
Notre garantie de satisfaction garantit que vous trouverez toujours un document d'étude qui vous convient. Vous remplissez un formulaire et notre équipe du service client s'occupe du reste.
Auprès de qui est-ce que j'achète ce résumé ?
Stuvia est une place de marché. Alors, vous n'achetez donc pas ce document chez nous, mais auprès du vendeur ace_it. Stuvia facilite les paiements au vendeur.
Est-ce que j'aurai un abonnement?
Non, vous n'achetez ce résumé que pour €10,37. Vous n'êtes lié à rien après votre achat.
