Smartsheet formulas 2023 - Study guides, Class notes & Summaries

Smartsheet Certification Questions with correct Answers 2023 How is tagging a shared collaborator in a comment, via the use of @mention, an effective means of collaboration? It shares that collaborator a published view of the sheet so they can view the comment. It instantly sends the @mentioned individual an alert with the comment. It begins keeping track of the @mentioned individual within activity log. It adds the @mentioned individual to your My Smartsheet Contacts It instantly sends ...

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

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

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

Smartsheet Certification Correct Answers 100% Approved Revised questions 2023/2024 How is tagging a shared collaborator in a comment, via the use of @mention, an effective means of collaboration? It shares that collaborator a published view of the sheet so they can view the comment. It instantly sends the @mentioned individual an alert with the comment. It begins keeping track of the @mentioned individual within activity log. It adds the @mentioned individual to your My Smartsheet Conta...

Smartsheet Certification All Possible Questions and Answers 2023 with complete solution How is tagging a shared collaborator in a comment, via the use of @mention, an effective means of collaboration? It shares that collaborator a published view of the sheet so they can view the comment. It instantly sends the @mentioned individual an alert with the comment. It begins keeping track of the @mentioned individual within activity log. It adds the @mentioned individual to your My Smartsheet ...

Smartsheet Certification All Possible Questions and Answers 2023 with complete solution How is tagging a shared collaborator in a comment, via the use of @mention, an effective means of collaboration? It shares that collaborator a published view of the sheet so they can view the comment. It instantly sends the @mentioned individual an alert with the comment. It begins keeping track of the @mentioned individual within activity log. It adds the @mentioned individual to your My Smartsheet ...

Smartsheet Certification Complete Questions and Answers 2023 Already Graded A+. How is tagging a shared collaborator in a comment, via the use of @mention, an effective means of collaboration? It shares that collaborator a published view of the sheet so they can view the comment. It instantly sends the @mentioned individual an alert with the comment. It begins keeping track of the @mentioned individual within activity log. It adds the @mentioned individual to your My Smartsheet Contacts -...

Smartsheet Certification Complete Questions and Answers 2023 Already Graded A+. How is tagging a shared collaborator in a comment, via the use of @mention, an effective means of collaboration? It shares that collaborator a published view of the sheet so they can view the comment. It instantly sends the @mentioned individual an alert with the comment. It begins keeping track of the @mentioned individual within activity log. It adds the @mentioned individual to your My Smartsheet Contacts -...