Smartsheet Formulas Basics Questions with correct answers
Which function can you use to add up numerical values? Answer =SUM() 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? Answer =IF() 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) What symbols must you use when referencing another sheet? Answer {} Braces
Escuela, estudio y materia
- Institución
- Smartsheet
- Grado
- Smartsheet
Información del documento
- Subido en
- 16 de julio de 2023
- Número de páginas
- 3
- Escrito en
- 2022/2023
- Tipo
- Examen
- Contiene
- Preguntas y respuestas
Temas
-
smartsheet formulas basics questions with correct
Documento también disponible en un lote