Smartsheet Certification Exam_ 2023/ 2024 Update_ Questions and Verified Answers| 100% Correct_ Grade A

Smartsheet Certification Exam_ 2023/ 2024

Update_ Questions and Verified Answers|

100% Correct_ Grade A

Q: Which is used when writing a formula to automate checking a box, raising a flag, or filling

in of a star?

Answer:

1

Q: Which column type would be best for assigning tasks to individual team members?

Answer:

Contact List column

Q: What symbols must be placed around a column name in a formula if the name includes a

space, special characters, or numbers?

Answer:

[ ] Square brackets

Q: Which view must include two date columns in order to be displayed?

Answer:

Gantt

Q: What level of hierarchy should the CHILDREN() function should be placed on?

Answer:

Parent row

Q: Which column type would be best for visually representing the status of a row item?

Answer:

Symbols column

Q: Which is one of the three column types that are required to enable Card View?

Answer:

Contact List column

Q: Which function can be used in conjunction with another function such as COUNT() to

reference all the cells directly indented under a parent row?

Answer:

CHILDREN()

Q: When hierarchy is applied to a row, where will it be visible?

Answer:

Primary column

Q: Which column type would be best for tracking when a row was added to a sheet?

Answer:

Created (Date) System column