Select Multiple Check Boxes in Row from a Single Action
A earlier thread addressed a similar question, but I've got a matrix (series of columns with checkboxes and a "All" column that I want to select all of the boxes in that row when "All" box is selected. Is there an easy way to do this?
I.e. - I want to select the check box in Column 1, row 1 and it select all box in row 1. Conversely, I want the ability to select any box in columns 2 - 10 as desired.
Thanks in advance for the help.
Best Answer
-
Start the formula in the Govt column, not in the All column. My screen shot is confusing but its showing the formula for Task 5 is pulling from the All tasks column. I hope that does the trick!
Answers
-
In the snip below is a formula that will work. The challenge is that when an individual task gets checked it overrides the formula. So when you add another Transaction row the formula won't copy down automatically. One option could be to lock a row that is designated to hold the formula. When you add a new row, you copy and paste the locked row and then change the Transaction or PM in my example, or just copy the cells with the formulas. It's not a perfect fix but I hope it helps.
-
@Matt Johnson I am getting a #Circular Reference error:
data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAANQAAACxCAYAAAC855PxAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAACfiSURBVHhe7Z0NXBTV+sd/C4IoKi+JvGiahHmxpBe0wExvvtx8Kb1GkkUaRr6kcr3XNM18SSWTa+Hf60uiEaahpqFpV9EUTfIKpqRiigSBKIIrJqCCwLLs/zkzs7jgLrvI8LJwvn5GZs6cmTnnzPmd5zlnzs4osrKyNHl5eXBwcACnYeH3AejYsSN+++03w+VwIxYhM7Pht3EsPKUgRvKmQJzy3oixjyZiXXA07GfMwxjP1lBlxWLzGQ+MfVmF6OCvYDVjKfy6ArnH12HhelsE03naHwpBOCZh3iAnOtFmTNjqhKWLh8AJuYhdEg68Nw8D2wtXwebAaLh9Rtuq/Zi7lNIR8g682xQh+bsQrLOaBAshNRxOU8HGG+PmDkT+pukIDAzElDWp6NG7C6zggRHB3kgKDUTghCnYXOBEgsxE9k3pOC2P+WJIUTRmTdhM8qkG1yGYPQ6Ink3nC5qOzXkjMG9kF3AL1Yjg98EEC9XI4RaKw5ERLigOR0a4oDgcGeGC4jQ/iougUkvrMlMDQRUhISwQU75Nk7ZFcg+FIORQrrDOhi43nxdWOZw6Q5W1H2HBExAYOAELd6ZRzdQDG14P1DdSV4C4VdOx7lfpKGWsdK4QxN4Qg2qD6YIqOIWjGa2BY6eQVkfq5hhBXYCkrSGYMiFQqExTlm5DUtVhX5Nhz1jMsQEsQuL2aLQOWImNEYvgez4Me/6QdpmEHfrN2oDg3lSXieSD21AwbBE2btQ+a6odJguqICkeNwYHY1zXOJyqUQY48qBC8tYFiLg9CIvWbqTKtBaL/pqPdSHbmlkDp0JhsRXsHUVBqErc4GQnrJqM1pNif0MPqZD57VwELomlJoZQJmDdh6L1m7UmAbk1LFsTBZWLUz9lwvtxT3j5eCA2odpHXpy64HYiYg65we91HzhZ0balFZz6vIHJA6xQlCdGKUqORojkCs1dF4tM5tUUxCE0mEQnRhFdoeA1WB04C5upYYxdHljhspsHdvB9uRfiv1uFVbNX4NKwSQ9sWTzHbcTsAYDHW8uxcf5AOBUnY3PoHtiPY9ZvJca23YqQ3ZlSbNMwTVA5iYi93g+9HgVa9+wDz5+PIrFY2sepH65fQlrnJ+FZqTW2g9fLfvBiFYqEEhaWjF5zNwiVYVKHeIR8kwiVnSd6dUhEcpZ4RNHvZ5Hd9yVM27gcY+l+Dpy1UZxyY0aoSkqB3ylPj41FUB9Ku1qFoiKVtLcWZJxCXKcRGOFJ1s+yNbxeGgr782mi5TIRkwSVfTIW+X17wYNttKUb9FgCTp6TIQMc0ymmSmPFTBND7P+wqTVsYe5LbmIcsgeNwRBX2k2VocuwofA+fhJJxU7w8rVD3K/ZtIPcxqQ09Osl3Enz5I9tWLDVFpNXLYffjVUIY9b1UjRmbq2915R7NROqpHWYIpVr4OxtyPwjGzUZqzBBUGmIO5iLopgQ6QZOx1d0AxN+TtQ/usKpG+zs4aTSNmJOGDif+lGSlWHcUGbC7SEd82XTGrZUFfLvUOynfGF3Nhm5xUk4eZ48jUekOGZIbkYanIYNgWdbKoN/zkCXfSEI3ZmELo91kWI8OE4d3ACfYGzYyMpWu1SehGsM44L6ncwghmBehM5FVr4Dz6SjOFUgxeHUPe3d8GjOWSQbKPP2zl1QoOv2FBehEO1h34bW23vBF/FIPHYByX3I07AUo5gj9g7tkRkfh8zbtNHSAwOHuSH5vAoenWo4MqGPx56ET2I0opNFU8Fmqn/1X7JawpZpGBVUGrkS9sP6Vb4Jdr4Y1Ics10lz6syaOTbeGDQoG5vX/CBWJkKl/AOp1+3Qmlx+J+9+sPvhK+zPoR3qImTui0Fin97wsmExmdsH7NmdDF9vrbtnTa4hncPMRgitvMdh9tOZCJ9F3lLQFIQmdsHk8Z6I27of2fflJRahWvdNWIzMIDc4U910+GzzRoTR+8CEcmQTwr9LQHYxVS47TwwMmowxXmLrzEb5wtbuRxoJzs1nDCaNG4gu4uiyOLq3KBdj/m9MReNYkLAKM9closu4lZg3QIYWXgbMfbY5F1Qjgt8H/vMNDoejAxcUhyMjXFCcpo9cD35NgAuKY3YUJG2TplgFYsL0UGxLMvL85o9oTF+wHzWbRPRgcEFxzIuMaCzYkI9BCzcIz0TXzu2P/A2h4uMCQzw2Bhs+ewW1f/RrHC4ojllRpMxGwVN94CNNiLVy9sGINzyBfPFhbMHJrzB3MnvmxCYIS7PF2SMD7WxyFCFtp/QTmMkLEf27NN/n/GYERuxHwppZmMAs34fbID3fpUMysT9sihgeHHLvGHUuEtbNFcNnrkKCkguKY2a09uwNr4QIrDqUhgLpQa5bn7EYwia05uxH6CbAL3SjMEF4TOutWPEjm8N4j9zDYQi93A+L1lGchb5IDotAgvSgHAmnkP/qcmyIWItgjzhsPirOf0z8JgSnPOdhbcRGbJjbi47ZhMRi9nOaEOxxGIuVFL5ynD22hkZzQXHMDDsfzAidjG5pX+HDyRMwPXQbkqTZq7lJ8VANHgJv9oyazRYP+AzzXnQTdwoUICkhGwNf6Qcn9nDbdQhG9E5E6mVxL17wq5hc7NrFDdm51DdTJ+PscW8MpfNYScfMDhsHL6s0nDraBSOGeaI1hbf2GoKhbZK5oDhmiKMnhkxeirXr1mL2SypEzxN/vs4mCNu11pkoZGmF1sLUKy3ZyCZ3bb/OTP2wn4HMnGqm0OXl0lG2lc5j1bo1rPKykalKwrpg7blmYdvlNC4ojnmRfXwz9ms7NyQYt6fGYkyfNMSfyUV7N4/KE4TZcHml3+21h1NnJ/iF6Ez0pqXa34O1d0MXFFY6j6qoCCo7J7jBB8HMddQ5FxcUx6ywRS6iN+25N+u+IAmnzlihvYM9nB7vBauD+5HI9qnZ+8YX4sN9uoPlbJKwFWK2x4oTadk7OnZuRmK17+XwQI8+iYg5ki1OJL4Rh1UzIqgP5YknKTx6VzKKWLgqG7GRP3BBccwLuz4zsGhkEfYskJ5DzduGwmHzMM6bXD0D7xvXxe1vszHZNR4hbCRw8ofYA194Oko79WIF77fmoVdyCKYE0fUWxaHLjCD4tBXDBxZsxnQKDwxejdTuPnxybGOC3wc+OZbD4ejABcXhyAgXFIcjI1xQHI6McEFxODLCBcXhyAgXFIcjI1xQHI6McEFxODLCBcXhyAgXFIcjI1xQHI6MKM6dO6eR1jkcTi1R3L59W3Pp0iU88ogZf+OkicDvg4g5lwN3+TgcGeGC4nBkhAuKw5ERLigOR0a4oDgcGeGC4nBkhAuKw5ERLigOR0a4oDgcGeGC4nBkhAuKw5ERLigOR0a4oDgcGVEcP36c/3yDw5EJRW58nqbk4UK0vGIrBXEaCn4fRMy5HLjLx+HIiFkKSlODfxzD6JZTdf+aOrp5re6fKZidy3fH8jbuWBegXFEuhRjGQmOBNqV2aKNuK4U0burrPrDKcafFLRRa3TZajqwMbVVt0aasHRT0rz4w53IwK0GxAlC2ugqP7h6wsan0NWK9FBcXIy0lDc53O9ZbZagN9XUfyunfzXa5cPfoCmtraylUP6WlpUhPy4DjLSdyZ+rHoTHncjA7l4+1JKaIicHimWLJmiUWGqOViCHEobhNFpnLgQ9KcDgywgXF4cgIFxSHIyNcUByOjHBBcTgywgXF4cgIFxSHIyNcUByOjJidoNgUEDYDwhRYPBafo4dyhfD03xhCHIrbZJG5HPhcvkaEOc9hkxNzLgez/D0UKwhTMYc5fFrq+z6YWo71XYbmXA5m6Q+xjJn6j2MY3XKq7l9TRzev1f0zBd7B4HBkhAuKw5ERsmOaSg5kbny+tMapD5x87aW1ezT3e2BufXpd7hMUp+HJyroqrXHMDVFQ7/8pbXKaK5rPHpLWGp6rV6+iY8eO0pZ5wftQHI6MVLJQjamV4tQPipmN796btYVqzj0ohWmPFpoFZWVlehe1Wk1NbtOtJCxvLI/68q67mFoOCoqkqbdW6g5QbAPYtJC2GxgmqObcoDC09z753Vzhb1UUVEh2dnZwdnYW1uuD+rJQTCBKpRIFBQVGxWJyOTBB4f0bwiI3x5dqNHtvSxvE8cUaTUi8tMG4otG8KlRp2icF1QR2PkES9PdBEHPfTKCy/ihMo7krbWoxdu9LS0s1Fy9e1FArLYXUPVlZWdJa3cLyxPLG8mgMU8uhZoMSWVvgp/gE8cJGPD4hpTK16i6fJAg7cW0HsLoTMKwNbZBl2vIBELAAmDcWmPmDGEcL+1yBr7TO2DcFeGaFtKElC/Dzp/PS6rWttE6L73wgZ4u427woRv7FfYj44F30eWeLkKdqKStGRsIWfD5lOHp8KpZ+dRSfWYOAnq50P1zR4801OE3lD7oXQXQvqpa9MaysrFizIyxNDW2+WB6NYWo51HKU71VEXREvol0+8qHgYhJTGN08Eg8jg8T1Gbl6vzKb8DPtnkgCI4Ho5Qawk9WZTcBpMaTmUA1dQ6Ls4Sq6de6k1k92AY3lcem1HdMw9ascuHraIJ5VdiPEr/DD51RuXbvaILlMCjTIaawZvw/PRCbT/cjB3sGHMWzpYXZL0JXuh/3SWpQrxyh1Mmyef5AqwTvA09L2NRLPgBfoZrINF2opyVrlGWiW86niZJAYQkgEh89IgTWgmCzkcLq2A4n21xzBIUQ6pcc3jSzkEkHrorV7VYgOV8nq5Z+i/T1FAQ6n9CWzik7ifpcyoa2AGRuAgbRo+Zz27XsAlbqM/hJR/w7CME9SvAn4ztqL1bPeRB+yMkZJ+xX7ugbg1V7iDIyuQwMwIDIeyWyDGrXhw4DoI8IuTh1QJ4JKPkmVwFPaIDyfIquzigQiiejpfwFTe4nrVdlHrtyw3kCfoWTVauieMLV8vpjcyu3Amx5ABIlFEAiF9ZhFVpPEvEYrUrJYjByK60ICC3qF4tH1mAA/60oNALXkxe3pbzfKzyUx7uEY4AKJU8gGhR2nfc/cP3OoYblxDYdbAK2kTbiQ20cJ1v4kk92LCMkt58iPHkFdwxb/qn0jPwMu2k4EPKwTb4no32dcpAqs05raU2Xd+wZVdrJS7tRCbqH9eiErEpVKlZhuuj3F9VtLlVhbE0yAWcaMCSRm6iscJhHl/0MUSB86713a33Uw7SexC4yW/hIZ1GJnkFV68xFx23M8WatPSTB0bU+ylMfPUSDlfx+J9HMS2a9klYopnfl0PtKoDjUpu4bB3olSSebKgIPAqSV6BOWCN7dX7hdpNNF4U6+7UaUPNV9naKHK0LgnCWovVcLjZCmiXtTfh2IVO2ec5CpSyz+ArNQ+cgFNhVnGAexgqvA7yYIE9aV1EkUeCUxosUkw9npq0jWK21VXGeQaOdCfa+TyPU1Z2kdWLZ/8PlcSOXNdD9N1kslFHEAuYmVqUnYNSA0aKU7NqKWFqgadzvO+5dQPkW6iC4lpHvWRhFa/CjvJIp2eIbppbPGLJItQg8EEZhm7MitDFimaKrugERJFBrlmwjqJKYP9rYILHZOvOzjAREh/XMgagazlqyTqCFr6kFhdyB09TZbwOHNraV9lGoGFau+CAVT2zCILXMvBBco8tRH3qLTBkZNaWij9dP0L9TV0KlE+Vb4IbX+IKvjhfRSnan+crEAU/RFGArVLLlmZLyg+HVMjyLr1IOUwY5RBlX+nSgxm612Z1apCVxK5/QKymlJfKZmEHPUhCYhVPFoGkKv32W8kIFYGtD6MxBVClfSZ+ypmLcuurBj5+TUwH8X5lRsChsczGJaxGluOic1QRkwUDo/3hbZLm09l6kIbugaZIx91MijhSa14vDCsJPLmv6leUiUVLA+5UDkTgalVWnfW6rtSn0dw97SQhXiTKnYU7TMFTzr4AlknVumn0h9XEu0aElcUibsHWaxppLB5JJ77oArPBL+X+nosjTNJjIfn3mvI2Xldqb/UVdoe4E9io3zIPh5x6nM4TNxpcv/m2q4gOKyo+lzqaUzdGoSM9zwpL64YfnAA9s0dUJGXZGq4gtijDRNRqVSSpaWCaWJo88XyaAxTy6Fuph5RI8sqrh/da12BxC+hFpM6/BUtNlV0v4epApM10ul91Qj2kNeVRKSZTxtUWYbvJHdvsWleDSsbZgkbC8UHZ6Jrgh9ydPui1ZCxYSBmtolC9Bsm2hs994VPPTKTqUc52zWaoC3ShpbbVaa+1MHUIxY2YL5GcyFXClBpNOmp90+5YYi5byzcpbQHaaIypE2jpGui3gvRHNeZ2mWM9E0azdQ90oaE9t5TC6x3YVNtysvLpdj1Q31NPWKwvLE86su77mJqOdSZoBjCXD5txa5HLuwkMfuIgoEHVaK1Gk2etK/Z8oBz+RqC+hSU3NTvbHNOo6Mx3nuz/j1UPbnFHE6zQGeUr+pwL1+aw0L/CYu+fXyp+UL2qVyDGczsa6Be/pAQyGk+tJglunxldO8bC+bs8pGg1CSoG0IrVbKMTbhhq1xUzQWbOaKg/giuwQNljkFIUGUa/PM6GSo1boXYoby8nAuqGeEw/6bwN2+Jo/C3MZCdnQ03Nzdpy7xQlJSUaFrOzMbtpWziGofDqQ0WZWVlwhwyDodTeyyYiwe18S+4cTgc41iw/lL8+CJpk8Ph1AZBUHwQgsORhzr5+QaH01zhForDkRFuoTgcGeGC4nBkRJGfn685f/48vLy8pKD6oU2LddIapyG4UzZZWuPISf1bqJwYrIhOlzZqgbocdwrLpY1mSFPNv1qFwkLj73horMggqHNYP2oOYq5LW+GjMGpUlSVcemdYMcVdno5+Q9yB65cxfeZlk19Ich8pqXj9H5fYG8MegJtY9UoyewWF+VKr/MsFu/fr6X8Z+T0K42fshtjkFuJcZDD8devQfSgRM3sU1p+VNhuYOrFQ3d9dh127dt1bJolvhMzavx5ZwwPgLccHvnt0x94Id/aCo+ZJU82/ZyC2h78GanKBP+MQtccds7+7V4caO/Xo8qXg0C53DHtez8u31GU4E3UCo/wOYPDoY/j0h1vsCzgihfmInHEQg185iLGhKQibfgCrmGnRtXDqEhxbfQzDX5GOP1LxmkdcO5KEoNEUTscHLc/BNbW0wxjquzi8XDzn8KAzOJxDYYVKfOp3Anska3x52zGMWplLab2LPTPjERYpXcsvDou0aTiTjMFLU8Q8fMFmdpfhQkVe4xF5QftGUJ1wv1hMj8qXysBAeBULfycpFdMDxHIKWn4ZaYUslKXrBCIPpeI9IV2x+GjfvbKpSkrkWwj5SThQ4Fy4PxbE5lNZKBEXJlmKN4Kx4ielFEOHs+srWRHl3jn3tnWO958UijhWloa4HoM5s2OgZH/fXU+1Jg4hrxmyQMxCTsb634GYj0dhzl5KF0tH6EZEzfIXry9Xukyk/gSVcxHnHnJHVz3v97q2LxEfJTlj5faXcDDCCy5HT2BVPOsflONY+Emc8X4Ou74fjM0BLZGp5y2sl3efxOfqbtj8PTu+O9psSsR3LF7WJXz0pSUmRVD4930wVJmESOG8xijHmYgTiGrfA9/SOb+d0hLhc1ORZuuMSdOsEP61EnfychAe3Q7vv+sE9gks4BYyrR/Bym10rZWdcXO1lAbG+RJ0mTMYB99zFPI6K70jvmB5XeGKMwt/w+FbFIcEMeu0VAaRT6NHfCKiUqoJ14XE9dGim3ghlK7x/Yv40C0H08OVEGdo5mN/qj2WC+l6FHciUnHMwFzo7s/0Q9Kv5yD2YFKQeNwLg3rbI+uHEKy3DkQksxSfDYJy5RYkmDyfWkVu2xzseGiicHzkJAdEzo+SXLpq6DAUy8InojuGYjF5OROflMIr0RMTd63DxMeAoR/vwrLhzmLwhTw8PGu7Eav2gOkyQp0IKuXLyTp9KMnHvq5EunsnSFnW4S6OHbqDEe88gs6WtNmuHQL+7ozDx3KpQuTj9JGHMPKVdmjD9nVyxkDt2yYruItfjpZjNB3jKBzvhOAvfDCCvZnWtTNWRjyOZ9vRuqUt+r7QDtfySthBRsjHzwcoHX6OwnXbeD+C0e1u4gJZJsd+nhivTMasj6lWT+mOvjruq8fj2nQ+goB+hfg5SbpW304Y0IGtlFBaKa/+neCijddXifPsLra0gPWft5CWQ4Jv54hJqwdiUvdqwnW4Fn8Vl1/ujtfY+w4tW8DD7xH0PaLEL0Klt6d8kOiF67WDR+ld3GQC1scTvhiUEI9Edtzlc0jw6AdvKrtOQ5Yh8j1v2LJzdPSBb1cl8gyd4z4uIv7HRzF6VE/heNtnRuLv7c4hRbLydUKfQegnlHd11E266qEPNZHaEQkra2lFl7vISW8DV/HHwgLWbazINpfg5vU71OluBUcmCIOw41uiTcX3WwibFrBmN59aoQvfnMTrgst3AGO/NLEWsOuW5uLTAPG4wa/EITw9H5nZtM+yFYaMsEea0hmj+7UU4+uhszu5tuqq1rAQmeTifTdTe94D+OgQkHaF3LDu3fHFe60Qu+wIhuu6dobCdbiWfQud2+ukxcaKrGY1wjGEZU/4DoxHErUVWQmH0KGPF4T2ovAiohaNF10+crE26ntBvCGuZyFdlYgVb2sbWHZ8Cq7I4F7VijpKVz32oQiVvp+JtIKrewnu6Lj2pXfI6XBuCccObajTbaxitEKX7pWPR3EZSqmvVPpLChalOmF5FLk7P7yE5cOk/cZ4iM4JVyzcIR6nXYLZ66PV+YiKvIOnuikRWU1/5DIJEJZVi5fltRXGr6583pWviK2By7Pd8AlZoL1bffDC6ZOgLlm14Vpc3Nrhpu4QerGKRGesIdJPT59BOJQQg8TEDujnzfq7KiR8E4qLvZYgirl8uxaTE2YAfff3oQ54GP0we6u2gRUX/S5cHVGP6ao/QXVwhnt6Fu7vzrZC30EtEbX2Ei6zAYNbtxD1vRID+jrBmtyVp1/8E7vZIAXbl6VE7H2tYys81ccCO+iYm8LxNxE+8xiiyI0qJWGBWm7BFaTznv5DOMA4lg/h2RdJMN/cFK9bWog9q9PJapE1+G8K9j/bA5/M8YTLpmQcZp/pkEg7r03nJUTF2WNgr6oWrBWe7U9pjbws5lVNLmBUMo7dIAHuZAMcUh4E6ypiKFwXF9+OcNzxm9hnU5chLfoSjr3ojGerex+1qhCF+vpBzO07GYUdrfpB/AhiKUqpQXN2cIAVXb8wLUl/P8PBEc4nE5DIxjTUWUj4nxTL0gvef41H1NZzKGR5UGUhZu13ZB3E3bWHypjSpWLn1scDpEt1q9Dw+YxQf4Jy/Qt6/pmODD030WWYNz7xUmK6P7lBQUm41v85BPuypFmg76TeeCrxBEb9/SBGfXkXXTqRO6fr3hGdR/bG+5apGPt3dvwF3PR7DuO7Ud+H+jvvl6fidQofPvsKWj7Wjvoihq3KPdh1n8PIvAvCsYMDTuP8467w+PMyPv3GCsFjHGFt64zx41T4/EvlPRcs8xKmj6H40y/DcZoXRujx41laP+yUI+bVn4RPlvCp9izcG8GlqQgSwhPw89O9Md7LcHglOnTGJwsd8fPsgxj89yP4NNsVKyc5U4NkGOWPS/DW1/dGvypgbl/vUri/0Ev6GIIt+r07DaXfjCe3yB9zfmwJ967puFK1Zew8FFP/ehGhb42C/zurcaebt7TDCj7vLsOwvPUY/xq5VuPI2vV4Ae7GvxNtIvbwHeqDo0tGYc5+PR8+qnG6ziHy7SU4JL67psYokpOTNTdv3qyXqUdZ3wdjfdslWDzQ3vSpR9cLcbmdLTpTa1tKFXbWzFsYvdkLfU35GoBR2APek9gjbWkZsURy70yGDU/HIfOtmh7XcFzccgarbRfdGxmrZ9jw9eQvqwxXPjYR60KH6hm4Itgw+iQ2jK5Ld0wMX4ahRgcgakBxAlaMS8KgrdT3N+ARVEf9zuVjMyXmx8P344nwtTNNUHeS0vHpF3/gl6xyWJP5fm3O0xjfo8rnERsccxNUIXYsbotO06nSyPGQvQmh+nU9QnNGYt4DNjT1Pzk2JwYhse5YFsg/Rd6Q8MmxdUODzTbncJoitR+UYL6t7gPchqYRzlYWpruwMmJTashCr/k6hZwuTlNEplE+Nj1E5wGuydT1bGXqLZzdiOA3jAieuaFv+1Oce7Pm9cGEIcwXqyHOw5dh18fS0xvXoRjZaj1W/GTqp7g55kT9DZvXF7qzlZGPuG93w30Ge2hnWPDn9kYib1QYxZF5xMgAnUaMhu033yPlAZ91cBovsgrK4GxlQvnTCslS+CM4LA7KqpVJ7tnKwu9kxmN9MhC3lK6rc25d2O+3FuxVIf3rYNElo7DC5CjMESyWP96aG4UUff5ZThxWTGNxKE3TVtxLkylptfHBoN77sO9k43JNObVHVkEZmq2Mq7sREmmNwHCyFN+FYZByBbacMLUyPeisYGcMDb03E9nQzOOek3Zh8RBp/iF7BlKcgPULz8F36XZKayT+5RaDFXurTnHPR8yq9bB+O1KYrrJqZCFWfxlH/SLT0+re3Qvxv12UtjhNBXldPgOzleEyDMvCp4rrlp3g87w7lHniVx+MU8+zla28MTFyCUayzxNZ2sK7jy+lVWd+kYAVbFuV4kpGFvKpXXAePA/b5/eDbQ3SauvQAap0Ol7a5jQN5BWUodnK1HZf3LoA4wWXbxQmRxq3LxXU92xly1JyT1cjWHD56HpLDkk7dLFFv+nLMOhGFP41Tsflq2laye015cckHPNB9kGJ+2crk9N2MhKhqd5Yskmc0ctcLL00htnKVw9hxS5bBK4kl4+us+7dKj8+0tLOHYOmLEYkpWv9W9ZYvyoG+TVNK1kxwz8A4Zgjsgvq/tnKbNY39erbO8CBXe1WOpL0GagGm61chcI85NnawqEtrauVSEnR8xNhNt/Lfw52XxYTwWZhC9QgrYV512Hl3kmagMppKsgvqPtmK5OD9MIETFNvEWb1+s+NQctu7kjPqdKxaLDZylV4bDTm+/yKOSyt72xAnmtPsN/dV+rr2Phg4qKeSFwYILh2478uxcTgoZRf09OanpIE3yf+Im1xmgq1n3okzAK+goAHerD74DTa2cqGYI8Ftjwspo9ZuGkXMSw8EN0fYEYzp/Eik6BYRX3Q2RJNnwrxS4LHnjnY0G4O5v2VO3xNDT45tr5hc/l+dEfg292lEVBOU4ILisOREfkHJTicZgwXFIcjI1xQHI6McEFxODLCBcXhyIhFTk5dzTLlcJofFq6u7K36taEMyz8uQVvtsrgEr0WpkKn9SotByvHL7hI8wY7ZYTRyg1NwohRtl5Wi9t/1UmP76hIsT5Y2k+m8cua/uAzbo6Ryle5FivByUfG6228IsWpJlTxwKpDN5YuY1hK3P6ZlbgtMILG8c8BIJbmpRvhpBdbMo2NGN7b37FVFjaNnNXgSGhxN1UhhjZFyHPhWjd2OlvjfAvFezHcsx/BdKuh76zJHfuTvQ7WwxEvPKPBLhkZ8j3m5GgekFtPjs1IcuE4V8oYKAf8px3aqoC+HSC2dvnjELztK8P7uUgSYEG/xERU++ky0lK/tLquoRMWXVZi6VAzvtZasjHaHgXPdxy2qqHcsEPaiAtsv6Px2n1mXb1U4sJmOp3M8EVYqfUKGKFNjj/bcdO3/nGPHMWtehiCyEou/LUHAUelc5Rr95zC1TCooRyYV+kjvFrBjd5buxZMvWGKBDSreKZ+fKh7HrNfUn+/lpZjCg6QyCth7r+xwnco0TAx/eTN5HuUG8sARkF9QVJEO/KrBs10VcKYbfJYq9oY2rMW0RuJLwL83kgvS3gpR0ywwAgrEklWb5WkgnnTKE3cUCJtjPN4mWpn4T2qZZ1rAK5ncEvZ5v1IVxSnHc4FWZEGtEe2pQYDQYld/Ll2UpyluNwWefVyB586Sq6r7lZqUchQMtkbaAius6ajBv4VKSnF2lWGltYVgKdImW0BJlXTTtRaY9XELRLQHFrzeElH9pZmxBs5hWplIAQKWeI62524rxdHrUiLbtMC4UVboIm7h2ywF1s6lMppogfwjZHnZT9CogZv6LQlxsjVuz2uBkVfU+OgkHV9K4qGycx5OZUdpW2BDnkcM9OeBIyCboILIpxb6UCFUCVpbYOdQ5saV48dzCkwYyFpMBex6WmKSjQZn7/Pjq4838hkrOAteYfXxJvWnisPitbHAX9qQENgv11M0WP6oBfzdWFYV6EJx/jfSEjYmp40aiNOAP3v9M1Xuv3XSYP85HUV5WsLfRUElSdd0AQ7kkxUhy7L/vAIfDLUSLYWjFSY+DWw/a8AN1ncOk8tEFwWefMUKsc/TtUh8zDJ+dLQMBTrJnfSilCa63lNkGZW3qJySy5HyJDVwjpQGsmr+zyuw/hIdlFGO8PYWeLs7HUBpY18OcdF6Hhy9yCYosQ9FN/NxoKWjhXjTbmhwhm7aa5Ib1pa5CjeBzFzxmArkjqeD8iZVTmsFCUiCKoYdCd7kc2WRa1qsQP9H2YYFfDwVWP6buvo+CZ2HWRIH8VuhAjaUgKM1+QDaA+RVxAJdvK2x5gNr/DaFXL5LarxKlq669GaSJT+bqJauQ0s0lZlSg9+ukXgul6OTNnxtOfZQujKl4zj3I5ugRKgVe8ECJfFq/MJcCUf2iyMF/stcDDZgIS2V3RRC7ng6OHegVrdUc69ClZN7VUStr4nnOkvu3tFiDfpKlarTAapsqRocrfoZQV2EcwN3dX7RX0wJ6F+TD6A9QF5xh9xKcmfFCk+NiH0L+A8nq0JuapVvtFXCmdy3/r6Wla5ze5oVnmAWq5sFcnXDyW1+VjqOcz8yC4pwsUTwwxp8TS0eLCzRv7sGq2Ikt4N88u07qB9Q1fORO54ujyow6w+yMtnsAGpx48vw/A41Ckw5F3XAj54HPgmgvkVFhWqBKDcN9giDDAagcw95XIPFu1XiuW+qsJ65jU+KPpoN/blbxty6aniQvLZmgw7l+M/PZJHYMdR4ZJJ7esKe9WcN08XTAjbUcOwhi8TKqOBsKZaz+9ddLLv11Mdj4cXZKiw/KCbApDw0Q+QXFJ2y/7MKnD2qxtlyWh9FPvkdNZ5fTC38vymsswW63+f7yx1PB2srfBBogRPUp2j7cSmGnwWiXqd+hCnnYkK0scDIbtRSV0D9qOcUOJBYXk1fgiz1qBaYXlounNtjHevYt8A46h+x4/t7K7A9uhRBOqNs9/MAebVogX8wNy9Vjb7CSJ4K76QqsCWwRcWghF5cWiBiOLD7q1KhjAb+D/jb45YVZafcK5Zdr20aeD3JBiFMzUPzg/8eisORkVoJqow8AQdqPTnNl4daK3Dpg+o+Ptq84BaKw5GROuhDcTjNFy4oDkdGuKA4HBnhguJwZIQLisOREQuFQgG2cDic2sMtFIcjI4KFsrDguuJw5IC0ZAFLS/4jMQ5HDhRFRUWa1NRUWFtbo7CwECqVCuXl5dBo+Ezi+iY3NxdOTk7SVvPFnMtBUVJSosnMzISDgwNKS0tRVlYmiIkLqv5RKpVwdq7uhxbNA3MuBwUJSHPlyhW4uLhArVZXiIkLqv7Jzs6Gm5ubtNV8MedyUJCINFevXgV7P59WRFxMDQO7Dx07dpS2mi/mXA4K6i8JgtJtEbigGgZuoUTM2kKReO4TFKdh4BZKxKwtlFZQ/EY2PPw+iJhvOQD/D6UYKPt5tq+RAAAAAElFTkSuQmCC -
Start the formula in the Govt column, not in the All column. My screen shot is confusing but its showing the formula for Task 5 is pulling from the All tasks column. I hope that does the trick!
-
@Matt Johnson That did it! Thanks. I also like the idea of the locked row with formula. It's not ideal, but it will do!
Help Article Resources
Categories
Check out the Formula Handbook template!