Content Preview

Smartsheet Formulas Basics Quiz 2025 Questions and Answers =SUM() - ....ANSWER =IF() - ....ANSWER ...-Which function can you use to add up numerical values? ...-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) - ....ANSWER ...- 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 - ....ANSWER ...-What symbols must you use when referencing another sheet? "Red" - ....ANSWER ...-How do you reference the red ball in a symbol column in a formula? The value if true - ....ANSWER ...-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 number of days late. The formula …FOR STUDENTS ONLY…©️2025 ALL RIGHTS RESERVED… 1