SMARTSHEET FORMULAS BASICS
QUIZ WITH COMPLETE SOLUTIONS
=SUM() n- ncorrect nanswers n-Which nfunction ncan nyou nuse nto nadd nup nnumerical
nvalues?
=IF() n- ncorrect nanswers n-Tricia nhas na ntask nsheet nwhere nshe nis ntracking nboth n%
nComplete nand nStatus. nWhich nfunction ncan nshe nuse nto nchange nthe nsymbol nin
nthe nStatus ncolumn nbased non nthe nvalue nin nthe n% nComplete ncolumn?
=SUM([Opportunity nValue]@row n* n[Commission nRate]$1) n- ncorrect nanswers n-
Jennifer nis nbuilding na nsheet nto ncalculate ncommissions nfor nher nsales nteam. nThey
nearn na nfixed npercentage nof neach nsale nthey nmake. nShe nhas nentered nthe
ncommission nrate nin na ncell non nher nsheet. nWhich nformula ncan nJennifer ncopy nand
npaste ninto neach nrow nto ncorrectly ncalculate nher nteam's ncommissions?
, {} nBraces n- ncorrect nanswers n-What nsymbols nmust nyou nuse nwhen nreferencing
nanother nsheet?
"Red" n- ncorrect nanswers n-How ndo nyou nreference nthe nred nball nin na nsymbol
ncolumn nin na nformula?
The nvalue nif ntrue n- ncorrect nanswers n-Reginald nis nmanaging nrequests nfor nhis nIT
nteam nusing na nsheet nwith na nform. nEmployees ncan nrequest nthe ncompletion ndate
nin nthe n"Date nNeed nBy" ncolumn. nThe nteam nmember nassigned nto nthe nwork
nenters na ndate nin nthe n"Estimated nCompletion nDate" ncolumn. nHe nwrote na nformula
nto nshow nif nrequests nare non ntrack. nThe nformula nwill ndisplay nOn nTime nor nthe
nnumber nof ndays nlate. nThe nformula ndisplays nan nerror, n#UNPARSEABLE.
nReginald's nformula: n=IF(([Estimated nCompletion nDatejl n- n[Date nNeed nBy]1) n= n0,
nOn nTime, n([Estimated nCompletion nDate]1 n- n[Date nNeed nBy]1)) nWhich nsection nof
nthe nformula ndoes nReginald nneed nto ncorrect?
=JOIN(ANCESTORS()) n- ncorrect nanswers n-Yoko ncreated na nreport nto nshow
ncollaborators non nher nproject ntheir nassigned ntasks. nThey nhave ntold nher nthat
nmany ntasks nfrom ndifferent nareas nof nthe nproject nplan nlook nthe nsame nin nthe
nreport. nTo nsolve nthe nproblem, nshe nwants nto nadd nthe nparent nname nto nthe nrow
nin nthe nreport." nWhich nformula nshould nshe nuse?
[Budget nTotal]# n- ncorrect nanswers n-Olga nadded na nfield ncalled n"Budget nTotal" nin
ntheir nsheet nsummary. nWhat nis nthe nsyntax nto nreference nthe n"Budget nTotal" nfield
nin na nformula?
Contact nList n- ncorrect nanswers n-Which nfield ntype nis navailable nin na nsheet
nsummary?
=ANCESTORS() n- ncorrect nanswers n-Guillermo nowns na nproject ntracking nsheet.
nHis nsheet nuses na nhierarchy nwith nall ntasks nbeing nchildren nof na nphase. nHe
ncreated na nfilter nto nhelp nhis nteam nsee nonly ntheir ntasks. nThey nare nreporting nthat
nit nis ndifficult nto nunderstand nthe nphase nas nthere nare ntasks nwith nthe nsame nname
nin nmultiple nphases. nTo nhelp nthem nunderstand nthe nphase, nhe nhas nadded na
ncolumn ntitled n"Phase." nWhat nfunction ncan nhe ncombine nwith nJOIN() nto nshow nthis
ninformation?
Convert nit nto na ncolumn nformula n- ncorrect nanswers n-Marcos nwrote na nformula nto
ncheck nthe nbox nin na nComplete ncheckbox ncolumn nwhen nthe n%. nComplete nis
n100%. nWhat nis nthe nrecommended nway nto napply nhis nformula nto nthe nrest nof nthe
ncolumn?
=SUMIF(Region:Region, n"Western", n[Opportunity nValue]:[Opportunity nValue]) n-
ncorrect nanswers n-Kai nis nbuilding na nsheet nto ntrack nopportunities nfor nhis nsales
nteam. nFor neach nopportunity, nthe nsalesperson nenters ntheir nRegion nand nthe
nOpportunity nValue. nKai nwants nto nknow nthe ntotal nvalue nof nall nopportunities nin
QUIZ WITH COMPLETE SOLUTIONS
=SUM() n- ncorrect nanswers n-Which nfunction ncan nyou nuse nto nadd nup nnumerical
nvalues?
=IF() n- ncorrect nanswers n-Tricia nhas na ntask nsheet nwhere nshe nis ntracking nboth n%
nComplete nand nStatus. nWhich nfunction ncan nshe nuse nto nchange nthe nsymbol nin
nthe nStatus ncolumn nbased non nthe nvalue nin nthe n% nComplete ncolumn?
=SUM([Opportunity nValue]@row n* n[Commission nRate]$1) n- ncorrect nanswers n-
Jennifer nis nbuilding na nsheet nto ncalculate ncommissions nfor nher nsales nteam. nThey
nearn na nfixed npercentage nof neach nsale nthey nmake. nShe nhas nentered nthe
ncommission nrate nin na ncell non nher nsheet. nWhich nformula ncan nJennifer ncopy nand
npaste ninto neach nrow nto ncorrectly ncalculate nher nteam's ncommissions?
, {} nBraces n- ncorrect nanswers n-What nsymbols nmust nyou nuse nwhen nreferencing
nanother nsheet?
"Red" n- ncorrect nanswers n-How ndo nyou nreference nthe nred nball nin na nsymbol
ncolumn nin na nformula?
The nvalue nif ntrue n- ncorrect nanswers n-Reginald nis nmanaging nrequests nfor nhis nIT
nteam nusing na nsheet nwith na nform. nEmployees ncan nrequest nthe ncompletion ndate
nin nthe n"Date nNeed nBy" ncolumn. nThe nteam nmember nassigned nto nthe nwork
nenters na ndate nin nthe n"Estimated nCompletion nDate" ncolumn. nHe nwrote na nformula
nto nshow nif nrequests nare non ntrack. nThe nformula nwill ndisplay nOn nTime nor nthe
nnumber nof ndays nlate. nThe nformula ndisplays nan nerror, n#UNPARSEABLE.
nReginald's nformula: n=IF(([Estimated nCompletion nDatejl n- n[Date nNeed nBy]1) n= n0,
nOn nTime, n([Estimated nCompletion nDate]1 n- n[Date nNeed nBy]1)) nWhich nsection nof
nthe nformula ndoes nReginald nneed nto ncorrect?
=JOIN(ANCESTORS()) n- ncorrect nanswers n-Yoko ncreated na nreport nto nshow
ncollaborators non nher nproject ntheir nassigned ntasks. nThey nhave ntold nher nthat
nmany ntasks nfrom ndifferent nareas nof nthe nproject nplan nlook nthe nsame nin nthe
nreport. nTo nsolve nthe nproblem, nshe nwants nto nadd nthe nparent nname nto nthe nrow
nin nthe nreport." nWhich nformula nshould nshe nuse?
[Budget nTotal]# n- ncorrect nanswers n-Olga nadded na nfield ncalled n"Budget nTotal" nin
ntheir nsheet nsummary. nWhat nis nthe nsyntax nto nreference nthe n"Budget nTotal" nfield
nin na nformula?
Contact nList n- ncorrect nanswers n-Which nfield ntype nis navailable nin na nsheet
nsummary?
=ANCESTORS() n- ncorrect nanswers n-Guillermo nowns na nproject ntracking nsheet.
nHis nsheet nuses na nhierarchy nwith nall ntasks nbeing nchildren nof na nphase. nHe
ncreated na nfilter nto nhelp nhis nteam nsee nonly ntheir ntasks. nThey nare nreporting nthat
nit nis ndifficult nto nunderstand nthe nphase nas nthere nare ntasks nwith nthe nsame nname
nin nmultiple nphases. nTo nhelp nthem nunderstand nthe nphase, nhe nhas nadded na
ncolumn ntitled n"Phase." nWhat nfunction ncan nhe ncombine nwith nJOIN() nto nshow nthis
ninformation?
Convert nit nto na ncolumn nformula n- ncorrect nanswers n-Marcos nwrote na nformula nto
ncheck nthe nbox nin na nComplete ncheckbox ncolumn nwhen nthe n%. nComplete nis
n100%. nWhat nis nthe nrecommended nway nto napply nhis nformula nto nthe nrest nof nthe
ncolumn?
=SUMIF(Region:Region, n"Western", n[Opportunity nValue]:[Opportunity nValue]) n-
ncorrect nanswers n-Kai nis nbuilding na nsheet nto ntrack nopportunities nfor nhis nsales
nteam. nFor neach nopportunity, nthe nsalesperson nenters ntheir nRegion nand nthe
nOpportunity nValue. nKai nwants nto nknow nthe ntotal nvalue nof nall nopportunities nin
