SMARTSHEET FORMULAS BASICS
QUIZ WITH CORRECT ANSWERS
Which dfunction dcan dyou duse dto dadd dup dnumerical dvalues? d- dcorrect danswers d-
=SUM()
Tricia dhas da dtask dsheet dwhere dshe dis dtracking dboth d% dComplete dand dStatus.
dWhich dfunction dcan dshe duse dto dchange dthe dsymbol din dthe dStatus dcolumn
dbased don dthe dvalue din dthe d% dComplete dcolumn? d- dcorrect danswers d-=IF()
Jennifer dis dbuilding da dsheet dto dcalculate dcommissions dfor dher dsales dteam. dThey
dearn da dfixed dpercentage dof deach dsale dthey dmake. dShe dhas dentered dthe
dcommission drate din da dcell don dher dsheet. dWhich dformula dcan dJennifer dcopy dand
dpaste dinto deach drow dto dcorrectly dcalculate dher dteam's dcommissions? d- dcorrect
danswers d-=SUM([Opportunity dValue]@row d* d[Commission dRate]$1)
QUIZ WITH CORRECT ANSWERS
Which dfunction dcan dyou duse dto dadd dup dnumerical dvalues? d- dcorrect danswers d-
=SUM()
Tricia dhas da dtask dsheet dwhere dshe dis dtracking dboth d% dComplete dand dStatus.
dWhich dfunction dcan dshe duse dto dchange dthe dsymbol din dthe dStatus dcolumn
dbased don dthe dvalue din dthe d% dComplete dcolumn? d- dcorrect danswers d-=IF()
Jennifer dis dbuilding da dsheet dto dcalculate dcommissions dfor dher dsales dteam. dThey
dearn da dfixed dpercentage dof deach dsale dthey dmake. dShe dhas dentered dthe
dcommission drate din da dcell don dher dsheet. dWhich dformula dcan dJennifer dcopy dand
dpaste dinto deach drow dto dcorrectly dcalculate dher dteam's dcommissions? d- dcorrect
danswers d-=SUM([Opportunity dValue]@row d* d[Commission dRate]$1)