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?
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
Comments
-
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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives