Smartsheet Formulas Basics UPDATED Exam Questions and CORRECT Answers
=SUM() - ANS Which function can you use to add up numerical values? =IF() - ANS Tricia has a task sheet where she is tracking both % Complete and Status. Which function can she use to change the symbol in the Status column based on the value in the % Complete column? =SUM([Opportunity Value]@row * [Commission Rate]$1) - ANS 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? {} Braces - ANS What symbols must you use when referencing another sheet?
Escuela, estudio y materia
- Institución
- Smartsheet
- Grado
- Smartsheet
Información del documento
- Subido en
- 7 de junio de 2024
- Número de páginas
- 6
- Escrito en
- 2023/2024
- Tipo
- Examen
- Contiene
- Preguntas y respuestas
Temas
- smartsheet formulas
- smartsheet
-
smartsheet formulas basics
Documento también disponible en un lote