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