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
Los beneficios de comprar resúmenes en Stuvia estan en línea:
Garantiza la calidad de los comentarios
Compradores de Stuvia evaluaron más de 700.000 resúmenes. Así estas seguro que compras los mejores documentos!
Compra fácil y rápido
Puedes pagar rápidamente y en una vez con iDeal, tarjeta de crédito o con tu crédito de Stuvia. Sin tener que hacerte miembro.
Enfócate en lo más importante
Tus compañeros escriben los resúmenes. Por eso tienes la seguridad que tienes un resumen actual y confiable.
Así llegas a la conclusión rapidamente!
Preguntas frecuentes
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.
100% de satisfacción garantizada: ¿Cómo funciona?
Nuestra garantía de satisfacción le asegura que siempre encontrará un documento de estudio a tu medida. Tu rellenas un formulario y nuestro equipo de atención al cliente se encarga del resto.
Who am I buying this summary 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 this summary for 9,74 €. You're not tied to anything after your purchase.