Smartsheet Core Product Certification
Exam | Questions and Answers Rated A+
| Latest Guide 2026/2027
Martha is an administrative clerk at Ajax Systems. She manages a sheet
tracking purchase requests. Each purchase request lives on its own row
and a Purchase Order must be attached as documentation. Smartsheet
is not allowing her to attach 150 purchase order documents to her sheet
at once. What is the most likely reason for this?
- Correct Answer - Martha has surpassed the quantity of files that can be
uploaded at once. is correct. The maximum upload quantity is 100 files
at a time.
Primary Column
- Correct Answer - Every sheet has a primary column, and its value
serves as the row's descriptor. By default, it will always be a
Text/Number field. You can't change its type or delete it.
Owner, Admin Permissions
- Correct Answer - Primary Column, Use Sheet Summary, Change
Column Details, Hiding & Unhiding Columns, Lock or unlock columns
and rows, Gantt View, Activate dependencies and use predecessors in
Gantt, Edit locked & unlocked received update request fields, Export
activity log, Edit or delete any comment or thread, Create and edit
,approval request rules, Use formulas to apply calculations to all rows in
a sheet, Create forms
What are the image formats supported?
- Correct Answer - PNG, GIF, JPEG
What is the maximum file size for images?
- Correct Answer - 30MB
What does cell history show for images?
- Correct Answer - It doesn't show the image but alt text.
When exporting to Excel, MS Project, or Google Sheets, what is
included?
- Correct Answer - Only alt text is included, not images.
When exporting to PDF, how many images are included?
- Correct Answer - The first 100 images are included.
What is the access level for update requests and edit row forms?
- Correct Answer - View Only
,Benjy wants his associates to be able to update the status of their tasks
on a report he has built. He also wants this updated information to
appear on the underlying sheets. What does Benjy need to do to ensure
his associates can update both the report and the underlying sheets?
- Correct Answer - Grant all associates Editor or higher permissions on
the report and the underlying sheets is correct. Users must have at least
Editor permissions on both the report and the source sheet(s) to edit info
in a report, which will then populate back to the source sheets.
Juan is looking to automate the symbols that are produced in his Health
column. He applies a nested IF formula, but the formula is returning an
#UNPARSEABLE response. What is most likely the cause of the error
message?
- Correct Answer - The formula contains a misspelling, uses the wrong
case for column names, or misapplies quotation marks. is correct. An
#UNPARSEABLE error is displayed when the formula has a problem
which prevents it from being parsed and interpreted. This can happen for
many reasons, such as misspelling, incomplete operators, using the
wrong case for a column name, or using single quotes instead of double
quotes.
Benjamin is creating an IF formula to display specific Health symbols
based on conditions in his sheet. When a task has a value of 100% in
the % Complete column, he wants to show the green symbol. He is sure
, he typed in the correct formula but gets an #UNPARSEABLE error
message. What is the most likely cause for the error message?
- Correct Answer - The cell reference of the % Complete in the formula
does not have square brackets. is correct. All cell references in formulas
must have square brackets if the column name consists of more than 1
word or includes special characters.
Priya is calculating profits for her small business. In her tracking sheet
for sales, she uses this formula to calculate the profit for each sale:
=[Quoted Amount]@row - [Actual Cost]@rowShe wants to ensure that
all future sales apply this formula automatically. What is the most
efficient way for her to accomplish this?
- Correct Answer - Make the formula a column formula is correct. To
ensure any new rows added to the sheet have this formula applied, Priya
should right-click a cell containing this formula, then choose Convert to
Column Formula from the menu options.
Bridget would like to group the tasks in her report based on the Assigned
To column, but that column is not shown as an option in the Group by
dropdown list. What is the most likely reason for this?
- Correct Answer - The Assigned To column is a multi select contact
column. is correct. Multi select columns cannot be used for grouping in
reports.
Damian has a dashboard tracking the status of several open IT tickets.
He wants to display the status of these tickets on a screen in the office
Exam | Questions and Answers Rated A+
| Latest Guide 2026/2027
Martha is an administrative clerk at Ajax Systems. She manages a sheet
tracking purchase requests. Each purchase request lives on its own row
and a Purchase Order must be attached as documentation. Smartsheet
is not allowing her to attach 150 purchase order documents to her sheet
at once. What is the most likely reason for this?
- Correct Answer - Martha has surpassed the quantity of files that can be
uploaded at once. is correct. The maximum upload quantity is 100 files
at a time.
Primary Column
- Correct Answer - Every sheet has a primary column, and its value
serves as the row's descriptor. By default, it will always be a
Text/Number field. You can't change its type or delete it.
Owner, Admin Permissions
- Correct Answer - Primary Column, Use Sheet Summary, Change
Column Details, Hiding & Unhiding Columns, Lock or unlock columns
and rows, Gantt View, Activate dependencies and use predecessors in
Gantt, Edit locked & unlocked received update request fields, Export
activity log, Edit or delete any comment or thread, Create and edit
,approval request rules, Use formulas to apply calculations to all rows in
a sheet, Create forms
What are the image formats supported?
- Correct Answer - PNG, GIF, JPEG
What is the maximum file size for images?
- Correct Answer - 30MB
What does cell history show for images?
- Correct Answer - It doesn't show the image but alt text.
When exporting to Excel, MS Project, or Google Sheets, what is
included?
- Correct Answer - Only alt text is included, not images.
When exporting to PDF, how many images are included?
- Correct Answer - The first 100 images are included.
What is the access level for update requests and edit row forms?
- Correct Answer - View Only
,Benjy wants his associates to be able to update the status of their tasks
on a report he has built. He also wants this updated information to
appear on the underlying sheets. What does Benjy need to do to ensure
his associates can update both the report and the underlying sheets?
- Correct Answer - Grant all associates Editor or higher permissions on
the report and the underlying sheets is correct. Users must have at least
Editor permissions on both the report and the source sheet(s) to edit info
in a report, which will then populate back to the source sheets.
Juan is looking to automate the symbols that are produced in his Health
column. He applies a nested IF formula, but the formula is returning an
#UNPARSEABLE response. What is most likely the cause of the error
message?
- Correct Answer - The formula contains a misspelling, uses the wrong
case for column names, or misapplies quotation marks. is correct. An
#UNPARSEABLE error is displayed when the formula has a problem
which prevents it from being parsed and interpreted. This can happen for
many reasons, such as misspelling, incomplete operators, using the
wrong case for a column name, or using single quotes instead of double
quotes.
Benjamin is creating an IF formula to display specific Health symbols
based on conditions in his sheet. When a task has a value of 100% in
the % Complete column, he wants to show the green symbol. He is sure
, he typed in the correct formula but gets an #UNPARSEABLE error
message. What is the most likely cause for the error message?
- Correct Answer - The cell reference of the % Complete in the formula
does not have square brackets. is correct. All cell references in formulas
must have square brackets if the column name consists of more than 1
word or includes special characters.
Priya is calculating profits for her small business. In her tracking sheet
for sales, she uses this formula to calculate the profit for each sale:
=[Quoted Amount]@row - [Actual Cost]@rowShe wants to ensure that
all future sales apply this formula automatically. What is the most
efficient way for her to accomplish this?
- Correct Answer - Make the formula a column formula is correct. To
ensure any new rows added to the sheet have this formula applied, Priya
should right-click a cell containing this formula, then choose Convert to
Column Formula from the menu options.
Bridget would like to group the tasks in her report based on the Assigned
To column, but that column is not shown as an option in the Group by
dropdown list. What is the most likely reason for this?
- Correct Answer - The Assigned To column is a multi select contact
column. is correct. Multi select columns cannot be used for grouping in
reports.
Damian has a dashboard tracking the status of several open IT tickets.
He wants to display the status of these tickets on a screen in the office
