Content Preview

Smartsheet Formulas Basics Quiz 2025 Questions and 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 How do you reference the red ball in a symbol column in a formula? ....ANSWER ...-"Red" Reginald is managing requests for his IT team using a sheet with a form. Employees can request the completion date in the "Date Need By" column. The team member assigned to the work enters a date in the "Estimated Completion Date" column. He wrote a formula to show if requests are on track. The formula will display On Time or the …FOR STUDENTS ONLY…©️2025 ALL RIGHTS RESERVED… 1