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
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
