Smartsheet formulas basic - Study guides, Class notes & Summaries

Which function can you use to add up numerical values? - correct 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? - correct 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...

Smartsheet Formulas Basics exam 2024 Which function can you use to add up numerical values? - correct 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? - correct 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 rat...

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

Smartsheet Formulas Basics exam 2024 Which function can you use to add up numerical values? - correct 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? - correct 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 rat...

Smartsheet Formulas Basics Quiz Questions and answers latest update 2024

Smartsheet Formulas Basics Quiz with Complete Solutions (1) 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...

Smartsheet Formulas Basics Quiz (From the Course) Answered Correctly!! Which function can you use to add up numerical values? =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? =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 ...

Smartsheet Formulas Basics Quiz (From the Course) Answered Correctly!!

Which function can you use to add up numerical values? correct 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? correct 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...