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.

SUM formula pulling 0 no matter what. Issue with using multiple formulas?

PJ Londergan
edited 12/09/19 in Archived 2016 Posts

I'm attempting to have all resources check off each of the meetings they attend on a weekly basis and then pull in number of hours based off those responses.

I've created a checkbox column for a meeting and then a number/text cell the right right. I wrote a formula saying, "if checked, populate with a 1.5, else keep null". (1.5 = Hour and a half meeting)

I then did the same across the board for several meetings. All is working as expected.

I then tried to write a formula to take the sum off all those. I used a basic SUM function, but it seems to pull in Zero no matter what.

Is there something I'm not donig correctly or is there a limitation with using multiple formulas this way? Assistance on what I'm doing wrong or advice on how to do it another way welcome!

<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAmUAAAC0CAIAAABaEMzTAAAgAElEQVR4nOy953siV7ruff7b9zrXPtfe45nxjO1WACrnXECRgxBBAmWUc0JZIoucQQKUpXbbnn4/IKklud2e9rjt2eP+feuqVSs8636eu1QF9P95+5nPfOYzn/nMZ36O//N7T+Azn/nMZz7zmf8F3PulLMuyLOv1+q+++kqlUrlcLq1WK0mS/Jk/JFqtVqfTffnllwAAuFyu33s6/1EoioIgyBdffGGxWEwm0x85yz5UcESOlftcs7HaVWqz36xDMIKmSQzhjN6p2NnNTXrdZ1cYXtRKosAydAeWFyVJq9VqJVHgOYbhOPb+DMPxoqTVamVZkgTuoT3NcIIoa7WyJAkcy7AsQ9EUDgvD86lK+2R3nOEEThAEhsRwguZErSTyHEOz3GMHDMeLnelKssjdz4NhGZbhWJYT3q1GK4sCx9IUjtM67cB2/jJ3OOYywihB0wzLcQL/OFFWECXtfZ/Su6XRNM2y94OJPMuwLMsw7P0lnCA9GZ0TfomiOin/t7/97XPKv5fPfvmZn+SzX346PvvlI/+cX2Z2BpxmmuUlSRY5WnTYJo+qN7l9v8vKMDQrKxa3f2IyGJwYH3HbZEniBUHUGW0Op9fX1zcwOhEMTk6MDTotiszyvCDKksHVOTo5MTLoNCkCy8uKYu7z+dy+obHR8YnRmd1I5fS8ndkdHXQbtVqDrW/A63aY9KLB5HD5/B6Xe3hsLDg5MTbqc1gNkiCJgigJOrtnaHwiOBkc8g76vE6P12WWtfLTNUmSyHGSxTSyX7wqRKZ8dooRZFHgJElr84xOTAQng+P+frOiZXlJFgVZFk39g8MTE8HJyYnxsSFvv1XPCbKsNdk9g/0uz6A/MD4ZnBgd9DqMotLnHRmfDI6PBfodJh0nfrSoPvvlh3nml5IkSZKk0+n+/ve/d+Qry7IoitJn/pDIsqzVar/88ksQBF0u1+89nf8odDodgiB//vOfO375R86yDxUcgWVkZ99srHaV2vJYFIygWJalcVJyepazravUps9uIGlWDExupBtXrbPz88vrwtGIx8FzFGkYnNsJt86zmcpV6+y8ffO6ldyZ90gsy+t9A0vpxmX74rzdurquxVfmbCwrOJwT4XqzUmu3T1qt1tn1zbffff/d3XnpaNVrMriXI81yZnPExrj8G8mTu2o6WWvU262ru9cn0b1Jq0izvOxwTseK7fbVeeusnKmdtDLVYjgoKTLPC08W/M4v85Epn51kOIEXeId7+CB70T4/b5/fnmY3pwOiwDO8YPR6dipnVxdX563m5e3dTaO8M6zlRa1haL1wWSoWa6Vco3l+eVarJzeG5o8S5dP2+c3ri1xkyStx3MfK6jHlO375q+zvfxLP/FIURVEUtVrto3wlSRIEQfzMHxJJkmRZ/utf/9rxy997Ov9RaLVaGIY7fmk0Gv/IWfahgsMztORwzsSqV9n9Ea9T1uqNBp3EW3zBrez5WXrFZ9MRuHFkPZspHu8OiyaHd/Sg2q7HN4fsPCx5ZsLlf7y9aUbW+vrshunt0sVla3/B43QMRzKXrfxGv89ukEcPEs3GyVHQxVocM5mT17cn4dGRPlm0z61nKqf1wwWzohdkwb2RPKvmQiNWum8wVLv+4erkaHygzyKNHWTOT1vRKReqNbu3Eu2L8uHwiEOyjm/Fzt7+cFWKBQWdxHH8kwULLCuajcP7hatCeNJnI0iS1jmHQ+Fy43jZ4bbp7QuJYqOcWfMrmNbcvxFptgu7/iG7yHpXd6pX354czlsERQmsl26/vatE5wfNfP/IfKr5/e15ZXfW22fsWz6st5v5jSkTLQgfp6xOyj/65a+1xf8xPPNLQRAEQZBl+W9/+5tKperr6xNFked54TN/SERRlCSp45d9fX2/93T+o5BlGYKgjl8aDAaO437vGf1ufKjgcDQlWm3BWP313e3FWbvZbLZazdOTViOf2w367HqO5wl9cLNQq2bWR2gQw0XZvpG6OMmEhpwk55qJZdvNzIrFxBIELtpXMif148PFGd9K+uTyeN0mijgK08PL6XqjvDluNDmmk9WbZmbeZmUANT88E8vXy5tjNMnQIudai7dK2Y1hK+UcDJXbN5XYuKJjcFCZ26nV6vFZj+DoX82dN+NrPkXAIYT2Te03z2+KkQlBJ7Ls0+3lGUYwGYb2Cpf5SNBrwzBUdA9vputnyRULL2Aoyo1v5hq10saEnpW0Frurz6pwPI2BWP/EbumkHV+18YohsJq/aqQXJu0EpOatgd3U2VV5y2kXCRi3TRzWq5Xolo/ieZ77mPr9mPIAAHxO+R/z2S8/85N89stPx2e/fOTn/NJmn4rWbhq57bXl4MTY4tFx8+3b7xuJIMPQBEHztGVuI9u8u2k3CsVSoVIund2+vatuD3kY1jUbT9XK4VFWFiiKZWn/ViKXSsWO5vdyZ6XNEb0sUAxNWse2S4Xy0cqAyTkTLV9m9wN2M4mjurH5RKFR2Q7yLM889cu+wFa2cRZfsco6miZMs9vlUjE8NWgcCMZPrqs70zYDT9IEpgzMH+ealX/CL1FU6wtsFi6/u2yVK+ViqZA7OX/9/UV5Z9GCkjRDKmMrkWyxXCnla83zm3b9cMnC6Q2B1fxV4WB0xIwgqOwc2Y7VmolZ2SSRBGEa264UyvFt/2e//JV55pc8z/M8L0nSl19+2ZGvIAgcx/HvYFmaxLH3gRMU+6zpx8CxDEngJMVynPDsOMdSJI5hBE2zvPDsIEEy7PPGH43AMQxFvGcpJM18zEo4lqYInKRY9peu/98TQRBEUfzLX/7S8cv3NWFZmiRwkv7lW/8p4DiGInCS+pcV8umQJAkEwY5fKorCsuzLFhxNEQRJMewvWwJHUwSOYRhB0syzEyxDETiG4QTF/MSlvzGiKP5kwWEpkrc5piPVy+S6Qy+o1Bpc1I3uHdXareTshInhGAozzW3mGxfNXHQttLUVCm0sL8wEA069TIruuXiqVj4cYWSepBiaHdpJ5VPJo93gdqZV2RrXyQJJkbh9Yq9UKO8vuI2O6Uj5IhnqtyoohmhH5xP5ejk0zjAcLbB9q7FWKbM+ZCac/lCq3j6a18syQeOm2e1yqRSe8uo9I0e16+r2pFXhcBJHDIML6UK7HB7ntQJDP91ejqZ5oxLYzV/mwhMeC4Igki8Qyp/f1TI7uzsboa2tteX52XGvzSzL+v65tXixmD6MbK+vLB0kCs2TxtGimdUp/pX8ZfFofNSCIIjkGN6ONZrJeb1ZInHcPLZbKZSioQGC47iPKkqdlH+8ReZ5nvu3yuzfm2d+yXEcx3FP5cvzPMuyneMcS1O8weQOLm1ubm5ubq6vLi8uLa2srW9ubm5uri1PDVlEiaOZh+ada1iGJDCcoBmW594Py9CcTmcfHJsachu00rsOGIYTBaNveGpubsRp1bEEw3Isw3CSaPIOT40M2AxaimZ/otefg+VYhhbMNu/E/NLK2uYT1ldmAw4jg5LMu6V/oB+G5mTFFZhdmhwwGCWKZj5iEjzH0CSBd24U/v3geV4QhEe/fHmaZWhOrzj941OBfp0svtj5d81oisBxnKI/6VxZisRxnKQZjmE4rdY+NL0cDFgV+eM25LdDFMVHv9Tr9QzzZJosy7I8q+0bmBgd9toMNM2y3Pti27l5JUiGfZZcLMuyHKt1+kZnFxZmJwbtBpLpXM9yLEPoLO7RmYXFmVGPjeM4msAxnKB+Oj0/PYIgvL/gcBzHkARntU9FqpepLY/VgJEMQ8Cc4lhONO9u66FBO0/CtG85Wytn14bQr7p7ADVl9kwEfFaFAwXXTCR/3i5sOPU4AoFa706tWQ+Hhn2u+fTJXWG7n+FgTQ87vl46bRVXh0WjfSpSvjwOuS0KisLasflEtVnbCXIwgXOUo+OXARPuGAyl6u3wvCJJBIUZZ7bLpXJ0uo80O6aPWxf5nWEdD3cD/NB8/PL2uhQZZyWepp6qkKUozqAP7OYvc0cTbjOCILRtYCVRPsusGmGs55uvAMky6B/ymkXe5Q5V794Udp0s+fVf1ezwUvq0dXq4YGR0+sGOX46YYRgW7R2/nNObRALDTB2/3PThLMv+RFq+n07KP/olx3H/TBH84/Aev/xJ+TIUwdsc4zupSqVSqVZOr799+8P3t+fNUrlSrRbSe0suWcc9qU8sy3KCoLf3D/Y7jTrpp+opQ+Cc3TGbOL3L7XhtBpSgHoajOL128Kh09/btdXRjSKERimUoklN0gf3SXTk+7bUi+C+twizHUKh2ZDZ6+uaH2/NqpVqpVKqVaqVcal2dlOMHI2azyLI/LxaGJnmdZWQxnN6dttl1BPnPT4hlaF6n2F1en8Ms8DzzbyfMH/vl81pGYHyfeznVvE1vOo06jPjR0lmOZRnBYHG5Pf1WhWU/SfJ17EEyO7xut8OkowiSNSi+pYP0zqLHov+YDfkt+aBfMgwr0LbV2Fm9dDDtQXHmx37JMgwnSUanZ9Bl1z+/WWEZhuVp28pR/e7t27cX6c2gSHAMw7AMyzAoF1g4ar19+/aqtjPJi5JkcQ64+0w/nZ6fng/6JYFzNsdsovk6v+e7Lw4MgfAGz3T44vZ1NT4/YGQky8hBOJNL7wyNTczNbGWqjXAoYJXUnHPyIP/6+8t6dHt6Jjh2kG2cFqLjHoE2uDf3a61acm5pejSwlS2cFPLLbgNpccwmT1/ndr1WBUVh3hvcr168Psks+wcskuBaT17Wi6FhM+4M7Obb1/ElgyThJGqa3z+pn6QXvSCjNc+uF88a2bXNGf/kRrxw/f1tO70XYCXuuV8yJMkZ9MOHldfl2KTXgmA4zirOmdVYvRCbWZweG5qLpWuZ1JrPxFicy8etu5Ps6sK0P7C8l6y9+f66ebzpZPRKYL3yuhYLjlkgCBIdo/ups8vsot4s4ihqnjg8rdaTO4PYZ7/8dXnmlyzLdp4Lffnll2q1uhMvhmHYFzAUzQiMYzXWKue2JvoRnO5ULYYiiQdIimZIgtGK3q3sZe5ovM8IoATLsizztBVBkBSJ45zVNh2tXaVDbouCEmRnFJokWZ3k281f3X33j+vC6piXwgmKJFi9dnAnf1WIBD1mBKdYhqGfDEt3psvQFEUSJEW9G4ein62BpUlUHplLFhuVrXGW4SiaZlmWJlHLxGL2/O4kvuFiBJrACJJ8XBDLMPS72ZOdS9jOUZKiO6FiaJokH5u8Cx/zPDwMQ+Mw5/aHUvXm/rTAcRhJvgz07wzHcTzPd/zS6XSyLPtMDDSBcQ7XQqJ+mVyzG3QohpMdHhZJUQxNINLoQqpQza34MZymaIplWZZ+F0XyybYwz45TZCd8dGcrSYIgCIpmGJahniuIpGgGN87t1Yr5vWAfiJA0TdMURVIPwX+2aQ8KoX+sEPpHSv90CIIAAMCjX9L0E3UyNM3wlHUpfFrO7wX7UYyiqPuIPAaHwjHGaBg9KF2lttwmHYTiLy9fPKhUb//xj3Y6vhsgWZamaJqhSXJgc/f44h//aFVK6yOsLDnXjy/ykcl+EwDfp+djsEiSJEnqZeL8+nyo4NAkwZnMI6FEcW+xz6i7zxGKwGSdeeGgWm+ll/12UaMxeib2Mq1Wq9VqNtK7w2YThyGw7Jk6jLZui5lEq9lstVqNyMyIg8cwjGANBv9Wqt5stVqtVj21NuIVQIQxmUdDieLegtOoxXAUk+xDq+HTVrOa3p/QK87geip6MOs1ENb+hf1kdnNCJwgEiSljS7FobDvoxhCC4hn7wn6+3mq1WslcvVFPn0RXnYzI0NRTadEkyepk70q4eLQRcBpRgmJJApP11oXD2mmz1Wq16snVIa+EYhgnm4ZWU/VGZ6LhjcPDg+1YeMXDaHXu6aNiZMM/YEBghLf4lraOM7vjssITGKYMLsfD0dCCC2cY5qNU/TMp/4fnmV8yDNO5z+3ItxMvmqaZJ9A0RREYTjCEZSl8WkhvjjgAGCdJgiRJmhe1er2iKIpeK/IsiROc0TR2WL4tJxeGXRTNshTFMDQvaXWKoiiKXqeTRYHBEcZimwpXL483+816BCc6I1EEwehkXyh7kc8UWuW9zc0RHYGiOK2TB7Zzl7nwhNsEozjNMJyk1Xc61Eocw9AUzXCcIEiyKIg6vV5R9DqdJPDs05XQDEUg0vBcIl8vbQyTBIXhOEmSJI7AkmchlT0pH42xMs9ygihpdTpFr5N4lqJpVpAfJi8LLEtTNMOwLMcLosCzLEtTJMPynfno9VqR7/zaBkNTz+apkwWWIQlcGwge5lvnsVWbUaFpmnkW6t8dlmU5jvvzn/8MQZDT6WQY5pkYKBxl7X3zsdpFfNWuaDGKlTpf99Iril7RaWWBYWiGNE1v5KvNys6kLMksRTM0RTKcKOsURdHrtLLAUp1eaYpmOUHW6RVFr9NLnf3jOI7jBUGSZVmn6PWyyDI0w3daKYper5NlnqFoketbjTZr1dhSgGU4lmY4XhAEnmVZhqboxx1RFL0sPiiEFwRJlp4ohOdY+jfbAJ7nNRpNxy91Oh1FUe/O0RRFc6Rl8eikmNuZcCEEwwmiLAqiVqdTFL1eJwkcTeCc3TkXb9zlj8Y8Nop8Jx6aomiOsiwcVtPFZju/H08umHiWJgiSJmn3eno/0TytxcvFzRHBaPbv5m8qqeXRfopiOz8UwwqSTq9XFEUrSZIkiKLAfdpQfLjgMAzL8qIkiQLHso8RohmG4QRZq9OKPMdQJM1yoqzT6/V6vU4WWZqhSQyR3DOxZL0aDspmgyxpdVqRYxmaommaZmhWkLR6vV6v12ul+0R+PhDNsBwvarU6nVYWWJbjBUkUBY5lWE4QJUngO7NheUESJZHnGJblJUmr0+u0WllgKc/kTq7cji1bGYGmyJfCYllOECVR4DiW7qyIphlefDElmmEYjpe0ncM6SRAFQRAlgWNYluMfru/8nI8oSSLfCRHLCZIoCr9g4zop/+iXzIuU/8Pz0X7JMAxDkxTN07blSLOYCY31wRhFETgjCs6lg869VauZP5j284xsnN1tXL3+4c3r61ZmddjLAbBoMc/Fqiete0r768MKSJoskz/hlwNbuYvMweT85npoZ2emH4ExWic9+iUIQpzNOXVUfOguPNVnZ0CQdbpnQslyZGs7X6k0W61WM7k66xFxknpYzRO/LG+M0BRDkCRN0zSJgXz/TPy4Vtgf1xr6Z/cih8lSvdKqJFf9Vkxr8G+lGve3pcmVgEeAUZTVWsZWEsXDe

Tags:

Comments

  • Atus Bartal
    Atus Bartal ✭✭✭✭✭✭

    PJ,

    The SUM function should work unless the items you want to sum up are not numbers. Please check them first. If you put "1.5" in the IF formula (instead of 1.5) then it will be a string/text, not a number (check if it's aligned to left [text] or right [number]). 

    I hope it helps. If not, please, give us a screenshot or the formulas.

    Atus

  • PJ Londergan
    edited 06/13/16

    Hi Atus,

     

    Thank you. The "" around the number was the issue. I removed that and it's working now. I'm newer to creating formulas so I missed that detail.

     

    Thanks again,

    -PJ

This discussion has been closed.