Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formula puts data left-justified instead of right-justified
I have the following simple formula:
=IF([Grasp of Material]3 = "Excellent", "100%", IF([Grasp of Material]3 = "Good", "80%", IF([Grasp of Material]3 = "Fair", "60%", IF([Grasp of Material]3 = "Poor", "40%", IF([Grasp of Material]3 = "N/A", "N/A")))))
The formula puts the 100%, 80%, etc. as left-justified. When I try to =AVG(CHILDREN()) for that column, it produces #DIVIDE BY ZERO. If I manually enter the 100% though, this data is right-justified and the =AVG(CHILDREN()) works. How do I get the =AVG(CHILDREN()) to work in coordination with the formula?
Thanks in advance for any help!