Smartsheet Formulas Basics Quizsolved 100% Guaranteed

=SUM() - Answer- Which function can you use to add up numerical values? =IF() - Answer- 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?