Smartsheet Certification 2023 | Domain One Sheets
VERIFIED Questions and Answers

1. Primary Column
   ANS: – is mandatory

• required to use #s or text
• cannot be deleted

1. Configurable Columns
   ANS: text/number, contact list, date, dropdown, symbols
2. System generated columns
   ANS: who did what and when it was done
3. Image rules
   ANS: – one image per cell

• formats allowed: PNG, GIF, JPJ
• maximum file size: 30 MB

1. Changing Language Date Format
   ANS: 1. Click Account > Personal Settings
2. Click settings in left pane
3. Under regional preferences, select the desired value from drop down list
4. Who can add columns?
   ANS: Admin and owners
5. Sheet Summary
   ANS: provides a standard location to define, organize, and reporton custom
   project, business, and summary level information
6. Summary FieldTypes
   ANS: text/number, contact list, date, dropdown list, checkbox,symbols
7. Who can create conditional formatting rule?
   ANS: only owner or admin
8. Conditional formatting
   ANS: allows you to create rules on your sheet, whereby theformatting of one cell
   of entire rows will update when certain criteria is met
9. Steps to creating conditional format rule
   ANS: 1. Click set condition
10. Define custom criteria

Smartsheet Certification Exam 2023
50 VERIFIED Questions and Answers (Solved)

1. How is tagging a shared collaborator in a comment, via the use of @men-tion,
   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
   ANSWER: It instant-ly sends the @mentioned individual an alert with the
   comment.
2. I have a handful of tasks that are falling behind schedule and I want to quickly
   view which items are marked “Red” in my project status column.Toidentify this
   information WITHOUT having to leave the sheet, I should:
   Turn on highlight changes
   Write a formula
   Create a filter
   Send an update request to my collaborators
   ANSWER: Create a filter
3. Date based alerts help keep collaborators aware of key project dates. Date
   based alerts can be triggered on a specific date or based off a date in any date
   column. Which of the following is a possible use case for establishing a date
   based alert?
   Samuel wants to automatically inform his boss when the status of a task

becomes at-risk
Samuel wants to notify all collaborators when a task is over budget Samuel
wants to be sent an email five days before the start of each task sohe can check
in with key collaborators
Samuel wants to automatically let external vendors know when a task is not
complete
ANSWER: Samuel wants to be sent an email five days before the start of each
task so he can check in with key collaborators

4. Auto-fill is automatically applied by Smartsheet within every sheet. Whichtwo of
   the following functions does auto-fill perform?
   Copy manual update requests to generate recurring updates
   Continue patterns of formatting
   Apply formulas and adjust cell references to adjacent rows
   Generate a numeric value based on conditional formatting rules
   ANSWER: Continue
   patterns of formatting
   Apply formulas and adjust cell references to adjacent rows
5. The widget uses a URL or embed code to surface interactive
   content on a dashboard.
   Title
   Report
   Image
   Web Content
   ANSWER: Web Content
6. In order to enable Card View, your sheet must have a least one of three
   specific column types.Two of those columns are dropdown list and symbol.What
   is the third column type?

Date column
Text/Number column
System Generated column
Contact List column
ANSWER: Text/Number column

7. Changes in cell formatting can be used to capture the attention of a user.
   Which of the following features allows collaborators to see updates since they
   last viewed the sheet?
   Conditional formatting
   Format painter Symbol
   column type
   Highlight changes
   ANSWER: Highlight changes
8. What information is tracked in the Attachments Summary? (select thethree
   that apply)
   File name
   Date attached
   Name of the individual who attached the file
   Number of downloads
   ANSWER: File name
   Date attached
   Name of the individual who attached the file
9. When entering formulas in Smartsheet, cell references use the syntax of
   column name and row number. What symbol must be placed around a column
   name when it includes a space, special character, or number?

Smartsheet Formulas Basics Quiz (Latest 2023 / 2024)
Questions and Answers Included

1. Which function can you use to add up numerical values?
   ANS: =SUM()
2. 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?
   ANS: =IF()
3. 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
   commission rate in a cell on her sheet. Which formula can Jennifer copy and
   paste into each row to correctly calculate her team’s commissions?
   ANS: –
   =SUM([Opportunity Value]@row * [Commission Rate]$1)
4. What symbols must you use when referencing another sheet?
   ANS: {} Braces
5. How do you reference the red ball in a symbol column in a formula?
   ANS: “Red”
6. Reginald is managing requests for his IT team using a sheet with a form.
   Employees can request the completion date in the “Date Need By” column.The
   team member assigned to the work enters a date in the “Estimated Completion

Date” column. He wrote a formula to show if requests are on track. The formula
will display On Time or the number of days late. The for- mula displays an error,

UNPARSEABLE. Reginald’s formula

ANS: =IF(([EstimatedCompletion Datejl – [Date Need By]1) = 0, On Time,
([Estimated Completion Date]1 – [Date Need By]1)) Which section of the formula
does Reginald needto correct?: The value if true

7. Yoko created a report to show collaborators on her project their assignedtasks.
   They have told her that many tasks from different areas of the projectplan look
   the same in the report.To solve the problem, she wants to add the parent name
   to the row in the report.” Which formula should she use?
   ANS: –
   =JOIN(ANCESTORS())
8. Olga added a field called “Budget Total” in their sheet summary. What is the
   syntax to reference the “Budget Total” field in a formula?
   ANS: [Budget Total]#
9. Which field type is available in a sheet summary?
   ANS: Contact List
10. Guillermo owns a project tracking sheet. His sheet uses a hierarchy withall
    tasks being children of a phase. He created a filter to help his team see only their
    tasks.They are reporting that it is difficult to understand the phaseas there are
    tasks with the same name in multiple phases. To help them understand the
    phase, he has added a column titled “Phase.” What functioncan he combine with
    JOIN() to show this information?
    ANS: =ANCESTORS()

Smartsheet Practice 2023
Questions and Answers (Solved)

1. Which takes priority when a sheet has 2 conditional formatting rules?
   ANS: Therule on the top
2. Which program files can you import into Smartsheet to create a new
   sheet?
   ANS: Excel
3. What permission is required to hide and unhide columns?
   ANS: Admin
4. You are building a sheet to keep track of opportunities for your sales team.
   You want a column to show which of the 4 regions each opportunity isassigned
   to.Which column type would be best?
   ANS: Dropdown (Single Select)
5. Which file type can you insert in a cell?
   ANS: .gif
6. Which formatting option is possible?
   ANS: Change the background color of a row
7. Tyrone created a project plan sheet and is adding tasks. He added thefirst
   task, then moved to the next row to add his second task. What will

automatically be copied down to the new row?
ANS: Formatting

8. Alex is building a sheet to keep track of her tasks on a website project. She
   must perform the same set of tasks for each webpage. She listed eachwebpage
   on her sheet and has written out the tasks for the first one.What isthe fastest way
   for her to add the tasks to the remaining webpages?
   ANS: Copy the rows with tasks, then paste them under each webpage
9. Which column type tracks when a row was added to a sheet?
   ANS: Created(Date) column
10. Where can you see the hierarchy in a row?
    ANS: Primary column
11. What can you customize when you insert a hyperlink in a cell?
    ANS: Displaytext
12. Which view must include 2 date columns in order to be displayed?
    ANS: Gantt
13. Which are the 3 column types that can enable Card View?
    ANS: Contact List,Dropdown (Single Select), Symbol
14. Which type of user can create or own a sheet in Smartsheet?
    ANS: Licensed

Smartsheet Services 2023 | Operations Specialist
Questions and Answers

1. Tell me about yourself: Career
   ANSWER: At present an Enterprise CSM at Instructure,APAC CX team.
   Previously held Project Manager/Officer and Operations lead rolesat UTS. Prior to
   this, I worked in PR/Advertising.
   Interests: Value centricity, CX, Operations, workflow automation, process optimisation
   Values: Honesty, collaboration, empathy, impact
2. Tell me about your current role
   ANSWER: – Helping customers achieve their goals

• Manage profile oh high-value relationships across APAC
• Drive product and service adoption
• Delivery impactful experiences
• Develop deep understanding of client business to provide meaningful solutions
• Be the customer advocate to govern product feature prioritisation and improvements
• Work crossfunctionally with sales, support, product, Engineering to deliver customer success

1. Walk me through your career journey
   ANSWER: – Graduated PR/Advertising, workedin marketing land

• Head hunted to work at UTS and found my love for tech and Project/Operations
  Management
• Overtime my transdisciplinary skillset evolved to combine my interests in CX/people experience and I landed the job I have now in a SaaS company

1. What do you know about Smartsheet and our product?
   ANSWER: – Founded in 2005,public in NY in 2018

• Based in Bellevue Washington US
• Over 3000 staff
• Currently used by 76,000 domain-based customers in 190 countries, including
  96 of Fortune 100
• A leading work management platform that empowers organisations to plan,
  capture, track, automate and report on work at scale, resulting in more efficient
  processes and business outcomes

1. Why do you want to work for Smartsheet?
   ANSWER: – Affinity with the vision/missionto ’empower everyone, everywhere to
   change the way the world works’, and to ’empower anyone to drive meaningful
   change’.

• In anything I’ve ever done I believe in doing things in the best possible way, value
  centric and driving solutions with empathy
• My impact has been optimising experiences & processes, driving meaningful
  change this way
• I am also excited out Smartsheets growth as a business and customer value
  potential as its use cases/business model scale and evolve

1. What is the Smartsheet way?
   ANSWER: Vision: Togetjer we are creating the dynamicplatform to empower
   everyone, everywhere to change the way the world works.
   Mission: We exist to empower anyone to drive meaningful change.
   Core values: We are collectively commited to… seizing opportunity, winning with
   integrity, prioritizing “we” before “me” and pursing progress
   Core competencies: At our best we… drive results, take accountability, earn trust,
   value and leverage differences and continuously learn and adapt

Smartsheet Support Glossary TEST BANK (Latest 2023 / 2024)
150 + Questions and Answers Included

1. 509 Certificate
   ANSWER: [SAML] 509 is a public key infrastructure and the certificate, in
   SAML, is where this key is located. In practice, the only part of the certificate
   that matters is the public key. The public key is bound to a signing certificate in
   the metadata. The private key is securely held by the party that signs the XML
   message. For Smartsheet, this key allows us to authenticate the data being sent
   to us.
2. Accelerator(s)
   ANSWER: [Control Center] Pre-packaged deployments of SCC with mini-mal
   engagement from Smartsheet Consulting team.
3. AccessToken
   ANSWER: [Internal] a set of characters generated by a user’s account thatallows
   them to access the Smartsheet API. Used in the Authentication header
4. Account
   ANSWER: [Internal, OpsCon, Salesforce] A unique profile in Smartsheet as
   defined by an email address. Accounts can be licensed users, non-licensed users,
   or free collaborators.
5. Addition Leads
   ANSWER: [Control Center] Other users other than the PMO Lead that can make
   changes to the existing program or blueprints. These users do not needto be
   shared to the config sheet.
6. Agile
   ANSWER: [Connector, Product] Let’s you view your issue on your Scrum or
   Kanbanboard.
7. API Client ID
   ANSWER: [Product] The specific ID shown in OpsCon Grid Load Logs andother
   resources (Kibana, Dev Tools, etc.) will help identify which applications are
   accessing/updating sheets. Also, see the API Client ID Report in Smartsheet to
   help as a reference.
8. API_RATE_LIMIT
   ANSWER: [OpsCon] This sets the number of requests that can come in from the
   user to an individual API App Server per minute. There is a fleet of 10API App
   Servers and each one gets this rate limit. Requests will come into the fleet and in most cases, they go to a new server each time, but in some cases, they may be
   sent to the same server.This rate limit per server helps to ensure theusers won’t
   get clipped by the Rate Limits early. It is controlled by the Long valueand the
   default is 100. Decreasing it below 100 has no effect and it should NOT be
   increased beyond 200.
9. App Log / Client Errors
   ANSWER: [OpsCon] These can be reviewed just as one would for
   troubleshooting Smartsheet application errors. Switching the Session Type to
   REST will show only errors from the API.You can also switch between the Log Type
   for App Log (Smartsheet Server Side Errors) and Client Log (API Client Making
   Request Errors).
10. APP_DEVELOPER
    ANSWER: [OpsCon] Determines if a user has the Developer Toolsenabled on
    their account. This is only necessary if someone will be creating thirdparty apps

and will be implementing an OAuth flow. This is controlled by the Boolean value
at either true or false. Default is false.

11. Application Programming Interface (API)
    ANSWER: [Product] The mechanism by which someone interacts with data
    programmatically instead of via a mouse andkeyboard.
12. Approval Column
    ANSWER: [Control Center] Column on the Intake sheet that marks the project as
    approved and ready for SCC to provision. The Blueprint settings onthe Config
    sheet state which column this is and what the value needs to be in orderto be seen in SCC.
13. Approval Value
    ANSWER: [Control Center] The value in the Approval Column that willallow the
    project to be available in SCC to be provisioned.
14. Assertion
    ANSWER: [Product] XML version of the work being done to authenticate
    between SP and IdP; Contains packets of information that supply one or more
    statements made by a SAML authority
15. Assertion Consumer Service URL (ACS)
    ANSWER: [Product] the endpoint on our sidethat the customers IdP will send
    information to. For Smartsheet, the ACS url
16. Assignee
    ANSWER: [Connector, Product] The person to whom the issue is currently
    assigned.
17. Attribute (Claim)
    ANSWER: [Product] Specific set of data within the XML (metadata or
    assertion) that is being asked for (such as email address, persistent ID, or
    given name) Smartsheet requires only two claims: the PersistentID (also known
    as NameID) and the Email Address. Read more on them here.
18. Attributes
    ANSWER: [Product] The parts of the JSON object that label the pieces of data
    being returned or sent in the body. Ex: In this object { “name” : “Mary” } the name
    is the attribute with Mary being the value
19. Authentication Configuration (in OpsCon)
    ANSWER: [OpsCon, Product] This is a section found in the Organization’s
    OpsCon page. Clicking this will take you into the organization’s settings for
    authentication (logging in). In the part of this page with the same name, all login
    options will be shown and have a red X or a green checkmark. Checkmarks are
    enabled login options and red Xs are the options thatwill not be available to users
20. Authorization (Auth)
    ANSWER: [OpsCon, Product] a process by which verification isdone to ensure
    that someone is whom they claim to be
21. Auto Approval
    ANSWER: [Control Center] Also called “auto provisioning.” In the UI, it’scalled
    “Automation.” Auto Approval is managed in the SCC-Admin Permissions
    Database. This tool sets up a rule that when a row on the Intake Sheet meets the
    criteria of the rule, the project is automatically provisioned.
22. Auto-Provisioned Domain
    ANSWER: [OpsCon] “A setting that enables a domain (e.g.lbl.gov) to