Smartsheet Core Product Certification Exam | 100% Correct Verified Answers | Graded A | New 2023/2024 Update

Smartsheet Core Product Certification
Exam | 100% Correct Verified Answers |
Graded A | New 2023/2024 Update

This 30-question exam assesses proficiency in Smartsheet's core features, focusing on
formulas (Questions 1-10), automation (Questions 11-20), and reporting (Questions 21-30).
Questions are designed to test practical application, troubleshooting, and best practices per
Smartsheet's 2023/2024 certification standards. Each includes four options (A–D), the correct
answer, and a rationale referencing official documentation or functionality.

Section 1: Formulas (Questions 1-10)
Question 1: Which formula shows a red symbol for overdue tasks in a project tracker?
A. =IF([Due Date]@row > TODAY(), "Red")
B. =IF([Due Date]@row < TODAY(), "Red")
C. =IF([Due Date]@row = TODAY(), "Red")
D. =IF([Due Date]@row <> TODAY(), "Red")
Correct Answer: B

Rationale: The formula evaluates if the due date precedes the current date (TODAY()), flagging
overdue items with "Red" for conditional formatting. Per Smartsheet 2023 formula guide, <
compares dates effectively for status symbols, enabling automated visual alerts.

Question 2: In a budget sheet, which formula calculates the total expenses across columns for
Row 5?
A. =SUM([Jan:Dec]5)
B. =SUM([Jan]5:[Dec]5)
C. =SUM(Jan5:Dec5)
D. =TOTAL([Expenses]5)
Correct Answer: B

Rationale: The range syntax [Jan]5:[Dec]5 sums adjacent columns in a row; 2024 Smartsheet
updates support this for dynamic cross-sheet references, ensuring accurate financial tracking
without manual entry.

Question 3: To count non-blank cells in a "Status" column, the appropriate formula is:
A. =COUNT([Status]@row)
B. =COUNTM([Status]:[Status])
C. =SUM([Status]@row)

, D. =IF(COUNT([Status]@row)>0,1,0)
Correct Answer: B

Rationale: COUNTM counts non-empty cells in a range; per 2023 Smartsheet function
reference, it's ideal for progress tracking, distinguishing from COUNT (numeric only) for versatile
reporting.

Question 4: Which formula links a cell value from Sheet A (Row 3, "Task" column) to the current
sheet?
A. =[Sheet A].Task3
B. ={Sheet A, Task3}
C. =INDEX({Sheet A Range},3,MATCH("Task",{Headers},0))
D. =LINK([Sheet A]Task3)
Correct Answer: A

Rationale: Simple cell linking uses [Sheet Name].ColumnRow syntax; 2024 cross-sheet updates
simplify this for real-time collaboration, avoiding complex INDEX/MATCH for basic references.

Question 5: For a conditional sum of sales >$1000 in a "Sales" column, use:
A. =SUMIF([Sales]:[Sales], >1000)
B. =SUMIFS([Sales]:[Sales], [Sales]:[Sales], >1000)
C. =SUM([Sales]:[Sales]) WHERE >1000
D. =IF([Sales]@row >1000, SUM([Sales]@row),0)
Correct Answer: B

Rationale: SUMIFS sums with criteria; 2023 Smartsheet criteria syntax (>1000) filters accurately,
supporting data-driven decisions in sales dashboards.

Question 6: To display "Complete" if a checkbox is checked in Row 10, the formula is:
A. =IF([Task]10=1,"Complete","Incomplete")
B. =IF([Task]10,"Complete","Incomplete")
C. =CHECK([Task]10,"Complete")
D. =IF(AND([Task]10=1),"Complete",0)
Correct Answer: B

Rationale: Checkboxes evaluate as TRUE/FALSE; implicit IF simplifies per 2024 formula best
practices, automating status columns for project visibility.

Question 7: Which formula averages values in a "Score" column excluding blanks?
A. =AVG([Score]:[Score])
B. =AVERAGEIF([Score]:[Score],"<>")
C. =SUM([Score]:[Score])/COUNT([Score]:[Score])
D. =MEAN([Score]:[Score])
Correct Answer: B