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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!