Smartsheet Certification Practice Exam V1 (2023/ 2024 Update) Questions And Verified Answers| 100% Correct

Which column type would be best for tracking when a row was added to a sheet? a. Date column b. Created (Date) System column c. Created by System column d. Auto-Number {Ans: b. Created (Date) System column (standard date column may be used to refer to the date of the data for that row, not necessarily when the row was created)}Which function can be used in conjunction with another function such as COUNT() to reference all the cells directly indented under a parent row? a. IF() b. CHILDREN() c. PARENT() d. RANGE() {Ans: b. CHILDREN() (all rows under a parent row are considered children rows)}Scenario: Juan is currently managing the development of a new product. He has a team of four individuals with whom he assigned various tasks. Juan wants to quickly see tasks assigned to each person and reassign tasks as needed. Question: Which one of the options below would be the most efficient way for Juan to accomplish this? a. Juan needs to *utilize Card View* to view tasks by the "assigned to" contact column. He could then reassign tasks accordingly. b. Juan needs to *build a report* for each person on his team. From each