• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 4 out of 33 pages
Exam (elaborations)

Smartsheet Core Product Certification

Document preview thumbnail
Preview 4 out of 33 pages

Smartsheet Core Product Certification

Content preview

SMARTSHEET CORE PRODUCT CERTIFICATION EXAM
100% SOLVED




1. Xiao zis ztrying zto zcreate za zmetrics zsheet zthat zwill zcalculate zthe
zhealth zof zall zthe z current z ongoing z campaigns z in z her z marketing

z portfolio. z She z has z a z Health

column zin zeach zcampaign's zsheet zand zis zusing zthe zSymbol zcolumn
ztype zto zindi- zcate zred, zyellow, zor zgreen zfor zthe zhealth zstatus. zWhich

zof zthe zfollowing zformulas zshould zXiao zuse zin zher zmetrics zsheet zto

zcalculate zhow zmany zcampaigns zhave za zhealth z status z of z red?:

z =COUNTIF({Portfolio zSummary zRollup zSheet zRange z1}, z"Red") zis zcorrect. zThis zformula zuses

zthe zCOUNTIF zfunction zto zcount zthe znumber zof zcampaigns zwith za zhealth zstatus zof zred zin za zparticular

zportfolio.

Formulas zthat zare zlooking zat zthe zSymbol zcolumn ztype, zsuch zas zthe zHealth zcolumn zin zthis zscenario,
zrequire zeach zsymbol's zcolor zto zbe zcapitalized.

2. Danielle z would z like z to z have z her z entire z department z review z a
1 z/
z33

,z report z weekly. zAdditionally, z even z though z there z are z a z few
z associates z who z don't z have z access z to zSmartsheet, zDanielle zwants

zto zensure zthat zeveryone zhas zaccess zto zan zup-to-date zversion z of z the

z report z at z any z time. z What z is z the z recommended z action z for

z Danielle zto ztake?: zSend zthe zreport zas zan zattachment zas za zweekly zrecurrence zand zinclude zthe

zpublished zlink zin zthe zbody zof zthe zmessage zis zcorrect. zReports zcan zbe zsent zto zany zemail zaddress zas

zan zattachment zon za zweekly zbasis zwithout zhaving zto zgive zanyone zaccess zto zthe zreport zitself. zPublishing

zthe zreport zand zincluding zthe zlink zin zthe zbody zof zthe zweekly znotification z allows zanyone zto zaccess zthe

zup-to-date-version zof zthe zreport zat zany ztime.

3. Celina zis zlooking zto zlock zin za zcolumn zvalue zin zthe zfollowing
zformula, zso zthat zshe zcould zapply zthe zformula zto zany zrow zand

zit zwould zstill zreference zthe zsame zcolumn:

=IF([%Complete]@row=1, z "Green", z "Yellow")
What zshould zCelina zadd zto zthe zformula?: z=IF($[%Complete]@row=1, z"Green",
z"Yellow") zis zcorrect. zThe z$ zis zan zabsolute zreference. zIn zthis zcase, zthe zabsolute zreference zshould

zappear zbefore zthe zcolumn z%Complete, zwhich zwill ztell zthe zformula zto zalways zreference zthe z

%Complete zcolumn zregardless zof zthe zcell zthe zformula zis zin.
4. Ken zis zbuilding zan zevent zschedule. zHe zwould zlike zeveryone zto
zsimultaneously zsee zthe zwhole zschedule zat zone ztime zbut zalso

zallow zeach zteam zmember zto zfocus zon ztheir zown ztasks

zimmediately.

Which zis zthe zmost zefficient zway zto zaccomplish zthis?: zCreate zconditional
zformatting zto zassign za zcolor zto zeach zteam zmember zis zcorrect. zIf zthe zsheet zhas zan zAssigned

zTo zcolumn zthat zlists zwhich zteam zmember zhas zbeen zassigned zto zeach ztask, zKen zcan zuse zconditional

zformatting zto zassociate zeach zteammate's zname zto za zcolor. zThis zway zeach zteammate zcan zsee zthe

zwhole zschedule zwhile zonly zfocusing zon ztheir zassigned zcolor.




2 z/
z33

,5. Carson z is z creating z a z form z to z collect z requests z for z IT z equipment
z and z software zsupport z from z employees z at z their z organization. z The

z source z sheet z has z the z fol- zlowing z columns: z Request z Type,

z Equipment, z Date z Needed, z Software, z and z Issue. zIf z an z employee

z selects z IT z Equipment z from z the z Request z Type z field, z they z need z to

zsubmit z answers z for z the z Equipment z and z Date z Needed z columns. z If

z they z select z IT zSoftware z Support z from z the z Request z Type z field,

z they z need z to z submit z answers z for z the z Software z and z Issue z fields.

z What z is z the z recommended z way z for z Carson z to zset zup ztheir zform

zto zensure zthey zcollect zthe zresponses zthey zneed?: zAdd zform zlogic zto zthe

zRequest zType zfield zis zcorrect. zCarson zshould zadd ztwo zrules zto zthe zlogic zfor zthe zRequest zType zfield:

6. Mary zis zsetting zup za zproject zschedule zwith zpredecessors zand
zhas zcreated zan zOverdue zcolumn zwith za zformula zthat zcalculates

zhow zmany zdays za ztask zis zoverdue. zNow zshe zwants zto zvisualize

zthe zseverity zof zthe zdelay, zdepending zon

how z many z days z a z task z is z overdue. z What z is z the z most z efficient
z way z to z accomplish zthis?: zCreate zconditional zformatting zrules zthat zassign za zcolor zto za zrow

zbased zon zhow zmany zdays za ztask zis zoverdue zis zcorrect. zCreating zconditional zformatting zrules zallows

zMary zto zassign za zditterent zcolor zfor zditterent zranges zof zdays zthat zeach ztask zis zoverdue.

7. Benjy z wants z his z associates z to z be z able z to z update z the z status z of
z their z tasks z on z a zreport z he z has z built. z He z also z wants z this

z updated z information z to z appear z on z the z underlying z sheets. z What

z does z Benjy z need z to z do z to z ensure z his z associates z can zupdate zboth

zthe zreport zand zthe zunderlying zsheets?: zGrant zall zassociates zEditor zor

zhigher zpermissions zon zthe zreport zand zthe zunderlying zsheets zis zcorrect. zUsers zmust zhave zat zleast

zEditor zpermissions zon zboth zthe zreport zand zthe zsource zsheet(s) zto zedit zinfo zin za zreport, zwhich zwill

zthen zpopulate zback zto zthe zsource zsheets.

8. Juan z is z looking z to z automate z the z symbols z that z are z produced z in
z his z Health zcolumn. z He z applies z a z nested z IF z formula, z but z the

z formula z is z returning z an z #UN- zPARSEABLE zresponse. zWhat zis zmost

zlikely zthe zcause zof zthe zerror zmessage?: zThe zformula zcontains za zmisspelling,

zuses zthe zwrong zcase zfor zcolumn znames, zor zmisapplies zquotation zmarks. zis zcorrect.

3 z/
z33

, An z#UNPARSEABLE zerror zis zdisplayed zwhen zthe zformula zhas za zproblem zwhich zprevents zit zfrom
zbeing zparsed zand zinterpreted. zThis zcan zhappen zfor zmany zreasons, zsuch zas zmisspelling, zincomplete

zoperators, zusing zthe zwrong zcase zfor za zcolumn zname, zor zusing zsingle zquotes zinstead zof zdouble

zquotes.

9. Benjamin z is z creating z an z IF z formula z to z display z specific z Health
z symbols z based zon z conditions z in z his z sheet. z When z a z task z has z a

z value z of z 100% z in z the z % z Complete zcolumn, z he z wants z to z show z the

z green z symbol. z He z is z sure z he z typed z in z the z correct




4 z/
z33

Document information

Uploaded on
September 20, 2025
Number of pages
33
Written in
2025/2026
Type
Exam (elaborations)
Contains
Questions & answers
$14.98

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
Registerednurse
2.0
(4)
Sold
39
Followers
3
Items
6083
Last sold
1 day ago




Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions