Want to practice working with formulas directly in Smartsheet?

Check out theFormula Handbook templateto view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.
❓️Product questions
Sign in andask it here!The community's got your back.

Wondering if there’s a problem?
Check out theStatus Pageand subscribe for notifications.

Share your knowledge!
Help others byanswering questions.

Formulas and Functions

Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.

Discussion List

3). But that formula doesnt work now that we are in july. as it calculates july revenue as well. So…","categoryID":322,"dateInserted":"2019-07-17T15:34:39+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-07-18T16:13:42+00:00","insertUserID":50951,"insertUser":{"userID":50951,"name":"steve50951","url":"https:\/\/community.smartsheet.com\/profile\/steve50951","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-07-16T18:38:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-20T03:23:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":75,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/53231\/formula-calculating-revenue-for-q2","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/53231\/formula-calculating-revenue-for-q2","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":52726,"type":"discussion","name":"Totaling percentages linked from another sheet","excerpt":"I am simply trying to get an average percentage in a parent row from children rows that are linked in from another sheet. Is the fact they are linked what is causing my error? Currently I'm just using: =AVG(CHILDREN())","categoryID":322,"dateInserted":"2019-07-11T11:45:52+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-07-18T15:32:47+00:00","insertUserID":95681,"insertUser":{"userID":95681,"name":"JKprintern","url":"https:\/\/community.smartsheet.com\/profile\/JKprintern","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-07-18T14:27:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-20T03:23:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":13,"countViews":446,"score":null,"hot":13,"url":"https:\/\/community.smartsheet.com\/discussion\/52726\/totaling-percentages-linked-from-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/52726\/totaling-percentages-linked-from-another-sheet","format":"Html","groupID":null,"statusID":0,"image":{"url":"image\/jpeg;base64,\/9j\/4AAQSkZJRgABAQEAYABgAAD\/2wBDAAoHBwkHBgoJCAkLCwoMDxkQDw4ODx4WFxIZJCAmJSMgIyIoLTkwKCo2KyIjMkQyNjs9QEBAJjBGS0U+Sjk\/QD3\/2wBDAQsLCw8NDx0QEB09KSMpPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT3\/wAARCAGDAwwDASIAAhEBAxEB\/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL\/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6\/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL\/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6\/9oADAMBAAIRAxEAPwD07B9KK8Nj1DxLLHbvHd6oUuH8uF\/NfbI3oD3r0XwRdyNPqFjJdy3j2mwSTySF90hzuC56KMY98ZrVwsZqVzraKhu7hbS0luGUssSFiB1OKht7x\/s3nXwt4FPKsk25SPqQOagsuUVXi1C0nkWOG6hd3Xeqq4JK+o9qSPUrKWJ5I7uBo0OGYSAhT70AWaKoR65p8sk6Ldw\/uQGZjIMYPf6c0PrFpHOivPCsLxh0mMgCtk4AH5UAX6Kha8t0uUt2niWdxlYyw3MPYVBcavY20Vw73MRNuMyKrjcv4UAXaKqT3bmwFzYLDcAjcN0m1SuOxANR2t\/NJbxTXkdtbiQF8CcnC4znkD8aAL9FVl1GyaOWRbuApCcSMJBhPr6VJDcwXAUwzRyBl3DawOR6\/SgCWiqQ1EfZZ5tgzFI0e3d1wcZqU31qtyts1xELhhkRFxu\/KgCxRUX2qAgETR4Kb87h931+nvUN3qVrYvbpcSqhuH2JlgMnH+fzoAt0VAt7atdG2W4iNwoyYg43AfSkW6zqL2uz7sSybs+pIxj8KALFFUrfVbeSC3eaWKGS4+5GzjLfT1qeO7t5Z5II54nmj++isCy\/UUATUVnTa3apLcwxurzW7IHTcM\/MQM\/hmriXMEkRlSaNowcbwwI\/OgCWikBDAEEEHoRUdzOLW2kmKO4QZKoMkj2oAloqjFrFpcTwQ27mZpl3DYMhF9W9KvUAICD0OccUtVrL7k3\/AF3k\/nVbxFK8Ph6\/kidkkWElWU4IPsaYjSwfSivDob\/xJOLcpe6mVuH2RN5r4c+xzXonga7eU39q93Ld\/ZmVWmkkLbn74z0FU4WJUrnW0VWv7v7FZvPhTtx99tqj3J7D3qKw1E3wjKRrjZukZWyqnsAcc561BZeoqndXky3AtrOBZp9m9vMfYirnHJwTk\/SnvfwW\/lLeTQwTS9I3kGSfQetAFmiq8l\/aRSmKS5hSQAkqzgHjrxSNqVktus7XcAhcErIZBtIHXBoAs0VUGoRG7MeU8oQef5u75cZx\/TrUcutWES27m6iZLiTy43Vxgn60AX6KhS7t5bh4I54mmT70YYFl+opsNz51zcw7MeQVGc\/eyM0AWKKz7DUZLuNriSKKK1Odj+blhg4+YY+X8zUy6nYuUCXluxkYogEg+Zh1A96ALVFVxfWrTyQrcwmWIZdN4yo9x2qAa1p7XiWy3ULO6lhhwRx1H1oAv0VnSa3Zo0DLcQNbyFw0wkG1NozyasyX9pCsTS3MKCb\/AFZZwN\/09aALFFQPe20Vx5ElxEs23d5ZcBseuKitdVtb3TzewSBoQCSQQcY7cd6ALlFU7W6upj5k9qkNuy7kbzcsB\/tDGB+BNPi1GzmhaWK7geJTtZ1cEA+hNAFmiq0Wo2czosV3A7SKWQK4JYDqRTxd27ZxPGccHDDigCaikzUF7dpY2rXEiOyKRu2DJA9foKALFFU4dUtri8FtbsZmKeYXTlVHbJ9TVwdRQAgIYZBBHqKWq2nf8eEf1b\/0I1l+NLia18KXs1vK8UqgYdGwRz600riZu4PpRXiVvdeJbm5toRfain2nmN3lcKV7tnPQV6R4HvjeabcgXEtwkM2xZpXLM\/HJ57Z6CqcLCUrnS0VT1O\/\/ALOtfOxHy23Mr7EH1bBxS2d6bzlY8IFBZs9GP8I\/x+lQUW6Koz3twbp7eyt0meMAyNJJsUZ6AHByf85qZr62jnjglnijuJANsTONx+goAsUVVfUrKJnWS7gVkBZgZACoHUmll1GzhjWSW7gRHG5WZwAR0yKALNFVP7RiW4uUlZI4oERzKzcENn\/CmvrFklxaxfaIybrPlEOMNigC7RUMN3b3EkkcE8cjxnDqjAlT71Ti1q3kurxWlt0gtSFeQzDIb3HYe+aANKiq51C0EUcpuofLk+428Yb6HvTG1SwTfvvbddnLZkHy845\/GgC3RUX2mHazedHtUBmO4YAPQ\/jVcapboJmupI7dY5jCGkcAMcA\/1oAu0VXu7oW1sJlUOCygYPqcZqK+vpYLmG3t4o5JpQWHmybFwOuDg5PtQBdoqu19bxOkc88UUrY\/ds4Bye386adUsRbi4N5b+QW2iTzBtz6Z9aALVFVbnUrO0j3zXMSDbvALgFhjPFMh1exuI4GS6hzcLujQuNzewFAi7RVOx1KC+TCyRiYAlog4LKM45qdLmGVC8cqMoOCwbIFAyWikDBuQcj2qvfX0WnxLLOH8ssFZlGQme59qALNFVLfUYLq7kt7cmTylBaReUBPbPrVlvuN9DQAoIIBByD3par2P\/IPt\/wDrkv8AKrFABRWX4j1WTRtEmvYVR5I2QBWPHLAf1rTBB6EH6GgBaKKKACiiigAooooA8k8IarqC6Pf6ZbWkt1I+Hs225WCXoWz0Xg5+tdP4A0G+0G51OG+jwWEZVxyr9c4PtmuxihjgjCQxpGg6KgwKfVuVyVGwyXf5TeUFL4+UN0J96yIdImZT5kVtDGZ0l+zxsWRdvUjIHJ9Mdq2qKgoyV0mSMo0RiR1uZJtwH94MB+PIqnBoV2Wke48rMnlbgZmk3FX3E8jjPoOK6KihaBcybzT55JroxwQSRzbGXdKY2Vlx6A+mf6Ug0u4lUtdtFLM1qYSxHck+3TpzgfSteilYLmDHoUqagJZEWaNmRy32mRNhAA+4OG6d8VHbeHpYoZ4nRC3kvFHObl2zn1Q8L26V0VFMCuI5ZLDy5FRJTHtIVsqDjHXA\/lWbqljIujgkr\/o9rIre5KY4\/Ktqihq4J2sYQ0y5uIN8ltagiFI4o45WUHByGLBeMdhg1oWMF1FsN2YXcRhWkUfMTk8ZwMj8B9Ku0UCMdvD9vIlw8ltbNcyTGRZSgLAbsjnGaH026aR4Qtv9necTGbJ8wYIOMY56YznpWxRQtBmH\/YMoYFZI8BzGM9oCc7PrWhfW0srWr26xs0Eofa5wCMEdcH1q5RQBjxabdLNFE6Wwt4pzMJUJ8xs54IxweeTn8KsXcF4l99qsUgkZovKdJXKAYJIIIB9TxWhRQFzGGlXVu9n9mMYeJAks5cglc5K7MEEe+QRTdJ0Z7C7DSxqwjDKk32l2JBP9w8D8DW3RQBlXWmzzzXYCwmG4MbZYnIKkZGMdMD1qeSxdppHXbgyB1UMV6LjqOlXqKAuMiTZGFxjHbOf1ptz55tpBalBOR8hfoD71LRQBjadocmk3ay204dJR\/pQccs395fT6Vs0UUAVrL7k3\/XeT+dVPE3\/Is6j\/ANcGrQhiEIcA53Oz\/mc0skSTRtHKiujDDKwyCPpTQjyTwtfahLo13ptpaS3MrENavtyIWPDHPQcV1vgLQr3QZNRgvo8ElCrjlW47GuuiijgjCQxpGg6KowBT6pyuJRsNfdsbYFLYOA3Qn3rJGmXaX0EqyAqPmkbzWXB7\/IOGz79K2KKgooXMF3Hffa7JYZC6CN4pXKA4OQQwB5\/Cq91YXsjzlEtH+1RCORnJBj4x8vByO\/bmteigDI\/sU5ORE\/8ApEcpZhyyquOfeq81pPa6jZeVFBLIZriVFdiq4IHfBwfwrfooAwJfD88ls0fmRgmELhSVG7fuwMcgds1NDpc8MMLx28STJciZka5eQMMY++wzn2xWzRQD13MTS9FexvQ8sauI9+yb7S5Pzf8ATM\/KPwNXLP8A5Cepf78f\/oNX6KAMSXSrq5kuWeK1gEsZRvLckTHPBYYGMD61JNo7O10UEK+aYdnGMBAM9q16KFoD1MCXRr241CSeVoyCsqq5mY7gwwBsxhce2atyadKDbCOKB41tzBIjMU7dsD\/CtSii2lguY9npl0JrN7zymS3dyse7fsUqAAGwM\/iPzqo3h6cCDcsc4WPy3T7TJEANxORtHPB6EV0dFAGHHojx6sZmjWWEyiVWNzIpjOMY2fdOPWrdpYSLpDWVzsXhlDRnOQSSD0HPtWjRR0sFzKa21G6sZLS5Fsq+XtWRWLGQjplcDHTnk1E+l3N6zSXUVrEx8tfKjYspCnOSSBz6DFbVFAeRlrpTrI7qIgWvGnyOu0jGPrU0Fh5KRjEfyRFOB3JzV6igBiIU\/ICor5LiW0eO0dElf5dzjIUdz9asUUAZOl6M2j3BS1lDWki5kV\/vB\/UH0PpWsOoooHBoArad\/wAeEf1b\/wBCNY\/jv\/kTr76D+dbsEIghWMHIXPJ9zn+tE0EVzEYp40ljPVXXIP4U07MTPKdCuNT1Tw3JpVpayS3HmbYbhh8sUbffG7tXY+AtJutF027tbyMo63BwezDHUe1dOiLGgSNVVR0CjAp1U5XEo2I5vMML+SFMmPl3dM1mwabc2+ppIsmYFHLGVsnjkbPu9e\/WtaioKM+WC8t72WeyWCVJwu9JXKbSO4IBz9P1qvcabdyvcRKtsYbpld5iSHQjGcDHPTjkda2KKAMqPSNs8MjLCdly87ccnIwO3WqQs7m2v7WGGG2mlS1lH7xiFAaTscHseldFRQFzAm8PzmEqkiNtEO0b2j3bM5GRyvXjrU0elTRR2nlRRRlGk81TOz4DDGQxGSfY4rZooAxtF0h9PlzNEu5I\/LWUXLyFhn+63C9O1STabcCZ54Vgdxc+ciSEhWG3HJxwe\/Q1q0UAZVppcqXcVzOIQ++SRkXkIWAGFOPb2602DRjF9n3LDmITZIHdycdveteigLmA+kXyWz28H2YpNBHG7M5BQr6DHIOfapL3SryVZViZGjlmZ2TzmjyCoAO5Rngjp3rbooC5k3Fu9roFvBIQXiMSEjpwRU+rW013CIo7e2nQ5yJnK7T2YEA8j\/Jq\/RQ9QMaTRZJY5xK0UryRQx73HLbM5z9aS90q7kaf7OYzHNMXaPzWiyNoA+ZRkYI6d62qKAuZFnpEkEYEpjZhaiAMMnB59e3So4dOvo5bRlSCFkjSOZ0lLb1XttK4\/HIIzW3RQBkLozC0ihBjjKpIrMn+1UsFg6R\/Miq4Izid23Y9zyK0qKAGRrtUDGPbOar6lb3F3aGC3kSMSHbIzDJCd8D1q3RQBmaVpb6Q8kEMgaxI3IrffVu\/PcVot9xvoadSEZBHqKAILH\/kH2\/\/AFyX+VWKjhjEMEcQOQihc\/SpKAOQ8WeErKXTLq7srJ31B3Vsq7EnLDdxnHTNbml+HdM0aZ5bC3MTuu1j5jNkfia06KACiiigAooooAKKKKAL\/kW\/939TR5Fv\/d\/U0lFIBfIt\/wC7+po8i3\/u\/qaSigBfIt\/7v6mjyLf+7+ppKKAF8i3\/ALv6mjyLf+7+pprMFUsxAAGST2o3rs37htxnOeMUAO8i3\/u\/qaPIt\/7v6mmqyuoZSGUjII6GloAXyLf+7+po8i3\/ALv6mkooAXyLf+7+po8i3\/u\/qaaXUOELDcRkLnkikSWOQsI3Vih2tg5wfQ0AP8i3\/u\/qaPIt\/wC7+ppKKAF8i3\/u\/qaPIt\/7v6mkpskiQxl5XVEHVmOAKAH+Rb\/3f1NHkW\/939TUcU0c8YeGRZEP8SnIpfMQSCPcN5GQuecUAP8AIt\/7v6mjyLf+7+pphlRZFjZ1Dt91SeT9KGlRHRGdQ7\/dUnlvpQA\/yLf+7+po8i3\/ALv6moIry2mlMcVxE8g6qrAmpqAF8i3\/ALv6mjyLf+7+pqPzovKEvmJ5Z6Pnj86VZEcEq6sASCQehHWgB\/kW\/wDd\/U0eRb\/3f1NRG4hWISmVBG2MOW4P40vnRbXbzExHw5z9360ASeRb\/wB39TR5Fv8A3f1NR+bH8nzr8\/3OfvfSiWWOCMyTOqIOrMcAUASeRb\/3f1NHkW\/939TVb7faeSZftMPlg7S+8Yz6ZqdHWRFdGDKwyCDkGgB3kW\/939TR5Fv\/AHf1NRfaYfKMvmp5YOC+4Yz06017u3jZlknjVlG5gWAwPU0AT+Rb\/wB39TR5Fv8A3f1NRxSxzxh4XV0PRlORTZrmC32+fNHHu4XewGaAJvIt\/wC7+po8i3\/u\/qaimuIbdA80qRoeAzNgUxr22SJZXuIljf7rlxg\/Q0AWPIt\/7v6mjyLf+7+ppgkQuFDqWK7gM8ketHmJ5gj3DeRnbnnHrQA\/yLf+7+po8i3\/ALv6mmLIjlgrBipwwB6H3pSQoJJwBySaAHeRb\/3f1NHkW\/8Ad\/U1BFe21xu8m4ik2jLbXBwKILy3uSRBPFKRyQjA4oAn8i3\/ALv6mjyLf+7+ppjusaF5GCqOrE4AoMqBkUuoZ\/ujPLfSgB\/kW\/8Ad\/U0eRb\/AN39TUXnxb9nmJvzt255z6U4SIXKBl3qMlc8gUAP8i3\/ALv6mjyLf+7+pqBb22dXZLiJlj++Q4wv1pUuYJYTLHNG0Q6uGBA\/GgCbyLf+7+po8i3\/ALv6moJLu3idEkniVnGVDMAW+lD3ttHN5L3ESy\/3C4B\/KgCfyLf+7+po8i3\/ALv6mozLGJViLqJGGQueSPpTVuoHnMKzRmVeqBhuH4UATeRb\/wB39TR5Fv8A3f1NMd1jQvIwVR1JOAKdQAvkW\/8Ad\/U0eRb\/AN39TSUUAL5Fv\/d\/U0eRb\/3f1NJRQAvkW\/8Ad\/U0eRb\/AN39TTFkR2ZVYFkOGAPT60B1Z2QMCy43AHkUAP8AIt\/7v6mjyLf+7+ppKKAF8i3\/ALv6mjyLf+7+ppKKAF8i3\/u\/qaPIt\/7v6mkooAXyLf8Au\/qaPIt\/7v6mkooAXyLf+7+po8i3\/u\/qaSigBfIt\/wC7+po8i3\/u\/qaSigBfIt\/7v6mjyLf+7+ppKKAF8i3\/ALv6mjyLf+7+ppKKAF8i3\/u\/qaPIt\/7v6mkooAXyLf8Au\/qaPIt\/7v6mkooAXyLf+7+po8i3\/u\/qaSigBfIt\/wC7+po8i3\/u\/qaSigBfIt\/7v6mjyLf+7+ppKKAF8i3\/ALv6mjyLf+7+ppKKAF8i3\/u\/qaPIt\/7v6mkooAXyLf8Au\/qaPIt\/7v6mkooAXyLf+7+po8i3\/u\/qaSigBfIt\/wC7+po8i3\/u\/qaSigDj5da1a+khW0S5Vvscc4Ft5OHds\/e8w528fw89eakm1TWrjUZ1gtrpXtmjAhjaDy2yoJ3lju7kfL6d66C40jTrxIkubC2mSEYjWSIEIPQelLPpOn3U8c9xZW0s0YASR4wWXHTBp9Q6GVpK\/Zdb1ye5v5PK89AUlKBVJRMc4B746\/rT7a5uby5urk37xLbTtELNVTDBem4kbsnqMEcEVqyafZzTNNLawPK6hWdkBJAOQCfrSNp1k96t49pA10gwsxjG8D2PWpGYVje3uzTLxtSNyL8kSW+1AkeVLfJgbvlIxyTUOny6veRaWz6s4F\/CzSlYUzHgAgpx19c59sV0UOmWNtcyXMFnbxzy53yJGAzZ65NSpbQRCMRwxqIhiMKoGweg9KbAx7O6m1DRrWCeTzJppGikfGNyoxDMQOBnH61LJPKs00c0rbHDrEqhTGQB09QR78Vox2UMM4ljULhSoVRhRk5JA9SaVbS3SR5FgiDvkMwUZbPXNAkZFvPc2VtaHzjMslszCMqAAVAIxjmhb\/UIrRrnbJIhi3Zk8vCtxjG05xyevpW0IYxsxGo2DC8fdHtTI7K2hZmjt4kZhhiqAZFDYIxrw3kmnXIladYtqsrv5ec55Hy9qtSTTwXcYkuZDANiBkCH5j\/fGM88dKvR2VtErrHbxIrjDBUADfWkFjbKwZIIkdRhXVBlfpRcCk7TyvdXNtGzuSII9uMqo+8wyfXP5CqdtO9nHdRxRPAGuETzJCDsyBknBPP+NbtvAttAkUedqDAz1NKYImV1MaESffBH3vrQBnT3MumuryXRuISGU7guQ2Mr0HfmonkvtxjN0UdLXzmwi8tk8dOnFaa2lukQjWCIRg7goUYz64qQxRsxZkUsV2kkdR6UAZUdxc+Yqy3ePOtjLuKgCNh6e31pbPUPNt5bq9ZVVSFEO3kH19cntWi9tBIMPDGwC7cFR09PpSS2dtNky28T5xncgOcdKAM4ma3Abctu97ONxGD5QxwPTJxSPDK+rQRrePuEL5lCru69OmP0rRWytkhaJbeIRPyyBBg\/UU+O2hh2+VEibQQNqgYFAGDI814bG4zm4iieQEcbipGfzGakWUX2r2d8P9WZDHF9ApyfzrbSCKMqUjRSoIXA6A9aBBEuwCNBsOVwPu\/SgDLSWXTAsStDcRskjpsXDDHPPJyKbHcziawJvPNW5VmdNq4HGeMDOK1I7WGAu0EMcbv1ZVAz9ap2+lCK7WeTyMqDtWGHYCT3PJzQBn7Lr\/hHIiZofJwny+Wd2Nw75\/pUt47Wl1cW0fBv9pi9mPDfpzWz5MXlCLy08sfwY4\/KlaKN3R2RSyfdYjlfpQBhavHKkLKbaU29uEWIqV25yMsec+wp12D9rksypUahsbaTyP73T2H61tuiyKVkUMp6gjIoMUbSK7IpdPusRyPpQBh2W6aTyvM8r7BE0e8\/wtnAPPsBTZbue80yWWQqGWSNRD0AOR8x4zz\/ACrcNvCwkBiQiTlwVHzfX1oa3hZizRISQASVHbp+VAGdeG4e6s12QRXQZ2TLbo8Y5zwMmoLGSVvsdvDK0KnzDJtAO5gexI6VsTQRXCbJ4kkXOcOuRSrBEmzbGg2DauB90egoAxTs\/tfPP2Dzvm\/u+dj+X9aIrKWW4u3WbzHiuwwSXAVsDuQPetn7PD5PleUnlf3Nox+VI9rBIjJJDGysdzAqCCfU0AYq3VxbJdXSeX\/x8cQx8iTjkA4zkHvVuUSS6Zu+0wO7QlpGZRllPYHt+RrQW3hTy9sSDy\/uYX7v09KjawtG27raE7eVyg470dAKFg0b6ghkXbm2QwK56D+LHvU1zDsuBd2\/2dkWNkdZGwB3J4B\/Grs1tDcKFniSRR0DqDimNY2rqitbxFY\/uAoML9KHqCMWxhnaS2VZ2gcWZOVUE43HHXtU0Etzd3lnLHJEkrWpLFkLA\/N6ZFbPlpv37V3Y27sc49KRIIoypSNFKjaCBjA9KL\/194rGLHcS2LXU8silUusTbVwCCvpziiO8upQ9tO\/7xVkkkwo5QrlRWyYImV1aNCJDlwV+8fel8mPczeWu5l2sccken0oGY9tbzS2UM8qxRpFasF2HJbK9+Bimwx3A0+G8YRRfZ7ZvLKHcWJHfgY+nNbYRRHsCgJjG3HGPSo5rdZbR7dMIrIUGB938KG9wS2M5DLMYIJbnz1u4GLrgDYcdRjt9aorOZljvXznTgiN9c\/N+mK3rWzgtEAiijVtoDMqgFsetP+zwhHQRJtkOXG0Yb6+tAdNTFSOU\/YJY2VZZ55JNzrkcjjjI7U28+0JLqPmPG7mGMEopUbc\/U1veVH8nyL8n3OPu\/SjykLM2xdzDaxxyR6UAZ0d0tu8sF2bdooo1kVo1wB2Axk8+lRzRsum6hcSqI2uFyEz90YwM+9aAsLQQmIW0Plk5KbBgn1xSLp9omNlrCuG3DCDg+tAbGNdBj9qKbBHHFEtwrn5mwB930qbyZby4v4YUi8qXy8u5+ZRt7DHP51rSWlvNIsksEbuvRmUEinhFVmZVAZvvEDk\/WgCjLDFFqtmyqocq4Zu7YXvSTwNc3riNkjNuu6LbjcXYdT7VaksLSaXzJLaF5P7zICfzqURoshdUUOwALAcnHSgDHbUp5rSaaJwgghAbgH94Tz+VAu76a6lMKykRShNg2BCvfOTuz9K1vs8IjZPKTY5yy7Rgn3pr2dtJMJXgiaQYw5UZH40AZL6ncQyYd8rayN9pO3qmeKsfarlLSB2lw8gLH\/Rmk4J4+7jHFaDQRP5m6JD5n38r976+tSAYAA4A7UAZkt3MY7RPO2NPKUaURFCABnhWzg\/Wq32u6MzW63hOLoQ+YFXO3GT2xmtW8ga5h8seSQTkiWPep\/DIqKy06O0jIYI7l95IQAA9to7UAU5byeOaeHzsDz44hIQMoCOT6ZqXTQV1PUFaYzFSg3EDPQ8HHFX2t4XDhokYSffBX7319aIbeG3BEMSRg9digUAySiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAMr\/hMfDf\/QXtP+\/lJ\/wmXhr\/AKC9n\/38r52qI9TXY8Kl1ORYlvofR3\/CZ+Gv+gxZ\/wDfyj\/hM\/DX\/QYs\/wDv5XzjRS+rLuP6w+x9Hf8ACZ+Gv+gxZ\/8Afyj\/AITPw1\/0GLP\/AL+V840UfVl3D6w+x9Hf8Jn4a\/6DFn\/38o\/4TPw1\/wBBiz\/7+V840UfVl3D6w+x9Hf8ACZ+Gv+gxZ\/8Afyj\/AITPw1\/0GLP\/AL+V840UfVl3D6w+x9Hf8Jn4a\/6DFn\/38o\/4TPw1\/wBBiz\/7+V840UfVl3D6w+x9Hf8ACZ+Gv+gxZ\/8Afyj\/AITPw1\/0GLP\/AL+V840UfVl3D6w+x9Hf8Jn4a\/6DFn\/38o\/4TPw1\/wBBiz\/7+V840UfVl3D6w+x9Hf8ACZ+Gv+gxZ\/8Afyj\/AITPw1\/0GLP\/AL+V840UfVl3D6w+x9Hf8Jn4a\/6DFn\/38o\/4TPw1\/wBBiz\/7+V840UfVl3D6w+x9Hf8ACZ+Gv+gxZ\/8Afyj\/AITPw1\/0GLP\/AL+V840UfVl3D6w+x9Hf8Jn4a\/6DFn\/38o\/4TPw1\/wBBiz\/7+V840UfVl3D6w+x9Hf8ACZ+Gv+gxZ\/8Afyj\/AITPw1\/0GLP\/AL+V840UfVl3D6w+x9Hf8Jn4a\/6DFn\/38o\/4TPw1\/wBBiz\/7+V840UfVl3D6w+x9Hf8ACZ+Gv+gxZ\/8Afyj\/AITPw1\/0GLP\/AL+V840UfVl3D6w+x9Hf8Jn4a\/6DFn\/38o\/4TPw1\/wBBiz\/7+V840UfVl3D6w+x9Hf8ACZ+Gv+gxZ\/8Afyj\/AITPw1\/0GLP\/AL+V840UfVl3D6w+x9Hf8Jn4a\/6DFn\/38o\/4TPw1\/wBBiz\/7+V840UfVl3D6w+x9Hf8ACZ+Gv+gxZ\/8Afyj\/AITPw1\/0GLP\/AL+V840UfVl3D6w+x9Hf8Jn4a\/6DFn\/38o\/4TPw1\/wBBiz\/7+V840UfVl3D6w+x9Hf8ACZ+Gv+gxZ\/8Afyj\/AITPw1\/0GLP\/AL+V840UfVl3D6w+x9Hf8Jn4a\/6DFn\/38o\/4TPw1\/wBBiz\/7+V840UfVl3D6w+x9Hf8ACZ+Gv+gxZ\/8Afyj\/AITPw1\/0GLP\/AL+V840UfVl3D6w+x9Hf8Jn4a\/6DFn\/38o\/4TPw1\/wBBiz\/7+V840UfVl3D6w+x9Hf8ACZ+Gv+gxZ\/8Afyj\/AITPw1\/0GLP\/AL+V840UfVl3D6w+x9Hf8Jn4a\/6DFn\/38o\/4TPw1\/wBBiz\/7+V840UfVl3D6w+x9Hf8ACZ+Gv+gxZ\/8Afyj\/AITPw1\/0GLP\/AL+V840UfVl3D6w+x9Hf8Jn4a\/6DFn\/38o\/4TPw1\/wBBiz\/7+V840UfVl3D6w+x9Hf8ACZ+Gv+gxZ\/8Afyj\/AITPw1\/0GLP\/AL+V840UfVl3D6w+x9Hf8Jn4a\/6DFn\/38o\/4TPw1\/wBBiz\/7+V840UfVl3D6w+x9Hf8ACZ+Gv+gxZ\/8Afyj\/AITPw1\/0GLP\/AL+V840UfVl3D6w+x9Hf8Jn4a\/6DFn\/38o\/4TPw1\/wBBiz\/7+V840UfVl3D6w+x9Hf8ACZ+Gv+gxZ\/8Afyj\/AITPw1\/0GLP\/AL+V840UfVl3D6w+x9Hf8Jn4a\/6DFn\/38o\/4TPw1\/wBBiz\/7+V840UfVl3D6w+x9Hf8ACZ+Gv+gxZ\/8Afyj\/AITPw1\/0GLP\/AL+V840UfVl3D6w+x9Hf8Jn4a\/6DFn\/38o\/4TPw1\/wBBiz\/7+V840UfVl3D6w+x9Hf8ACZ+Gv+gxZ\/8Afyj\/AITPw1\/0GLP\/AL+V840UfVl3D6w+x9Hf8Jn4a\/6DFn\/38o\/4TPw1\/wBBiz\/7+V840UfVl3D6w+x9Hf8ACZ+Gv+gxZ\/8Afyj\/AITPw1\/0GLP\/AL+V840UfVl3D6w+x9Hf8Jn4a\/6DFn\/38o\/4TPw1\/wBBiz\/7+V840UfVl3D6w+x9Hf8ACZ+Gv+gxZ\/8Afyj\/AITPw1\/0GLP\/AL+V840UfVl3D6w+x9Hf8Jn4a\/6DFn\/38o\/4TPw1\/wBBiz\/7+V840UfVl3D6w+x9Hf8ACZ+Gv+gxZ\/8Afyj\/AITPw1\/0GLP\/AL+V840UfVl3D6w+x9Hf8Jn4a\/6DFn\/38o\/4TPw1\/wBBiz\/7+V840UfVl3D6w+x9Hf8ACZ+Gv+gxZ\/8Afyj\/AITPw1\/0GLP\/AL+V840UfVl3D6w+x9Hf8Jn4a\/6DFn\/38o\/4TPw1\/wBBiz\/7+V840UfVl3D6w+x9Hf8ACZ+Gv+gxZ\/8Afyj\/AITPw1\/0GLP\/AL+V840UfVl3D6w+x9Hf8Jn4a\/6DFn\/38o\/4TPw1\/wBBiz\/7+V840UfVl3D6w+x9Hf8ACZ+Gv+gxZ\/8Afyj\/AITPw1\/0GLP\/AL+V840UfVl3D6w+xNUR6mpaiPU12SOSJPbopQkgE571L5af3R+VR23+rP1q3aW7Xd3DbqwVpXCAt0GaqOwnuQeWn90flR5af3R+Va13oyRM0dtcPLcJKIzDJF5bNnuoycio20LUFlSPyVJfdgrIpUY65OcDHvSUog4yRm+Wn90flR5af3R+VaS6FqDzvEsK7kQSE+Yu3aehznBFCaHe7UkkhxEcFsOu4KTjO3Oce9O8RWZm+Wn90flR5af3R+Vaur6HPps07KubZJNitvUkemQOlZdCaauhtOLsxPLT+6Pyo8tP7o\/Klop2FcTy0\/uj8qPLT+6PypaKLBcTy0\/uj8qPLT+6PypaKLBcTy0\/uj8qPLT+6PypaKLBcTy0\/uj8qPLT+6PypaKLBcTy0\/uj8qPLT+6PypaKLBcTy0\/uj8qPLT+6PypaKLBcTy0\/uj8qPLT+6PypaKLBcTy0\/uj8qPLT+6PypaKLBcTy0\/uj8qPLT+6PypaKLBcTy0\/uj8qPLT+6PypaKLBcTy0\/uj8qPLT+6PypaKLBcTy0\/uj8qPLT+6PyqzYWcmoX8FpFgPM4UE9q2ZJPDtvdGyNpPLGp2Peebhs9CQvTFS2lpYaTZzvlp\/dH5VXuFCsMDGRWtq+nNpWpS2rNvC4KPj7ynkH8qyrn7y\/Sh2auhq6dmQ0UUVmUFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRQAT0oAmqI9TUtRHqauRMSxbf6s\/WrVrJFFcxvPF5sQb5kzjI+tVLd1CEEgHPepd6f3l\/OqjsJ7nTR+I7a2EW1rq7McwdDcAAxryCAcknrSLrtirhGEskJ3tg28ahGPQ7R978TXNb0\/vL+dG9P7y\/nU8kSueR0N9rtrPDNHEsvz2qwAlFUZDZzgcAVFNqljPKt24uhc+WkZjTAT5cDOc5IwOmKw96f3l\/Ojen95fzpqKRLbZtS6razvqQdZhHeTI4IAyFBOe\/XmqIFhlcvc4y27Cj\/gOOfzqnvT+8v50b0\/vL+dCSWw3JvcWik3p\/eX86N6f3l\/OquSLRSb0\/vL+dG9P7y\/nRcBaKTen95fzo3p\/eX86LgLRSb0\/vL+dG9P7y\/nRcBaKTen95fzo3p\/eX86LgLRSb0\/vL+dG9P7y\/nRcBaKTen95fzo3p\/eX86LgLRSb0\/vL+dG9P7y\/nRcBaKTen95fzo3p\/eX86LgLRSb0\/vL+dG9P7y\/nRcBaKTen95fzo3p\/eX86LgLRSb0\/vL+dG9P7y\/nRcCzYXkmn38F3FjfC4YA962XTw5cXJvWuriJGbe1mIsnPUgN0xXO70\/vL+dG9P7y\/nUtJ63Gm10NzxSyXGprewzxzQXCAxhT8yKONpHYiucufvL9Kn3p\/eX86r3DBmGDnApNWjYd7yuRUUUVBQUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFAAPcUUUATVCTyalNe9eHfDmjT+GtMlm0mxeR7WNmdrdSWJUZJOKmtUUEiqVNzbPAM0Zr6Q\/wCEY0L\/AKA2n\/8AgMn+FH\/CMaF\/0BtP\/wDAZP8ACsPrK7G\/1Z9z5vzRmvpD\/hGNC\/6A2n\/+Ayf4Uf8ACMaF\/wBAbT\/\/AAGT\/Cj6yuwfVn3Pm\/NGa+kP+EY0L\/oDaf8A+Ayf4Uf8IxoX\/QG0\/wD8Bk\/wo+srsH1Z9z5vzRmvpD\/hGNC\/6A2n\/wDgMn+FH\/CMaF\/0BtP\/APAZP8KPrK7B9Wfc+b80Zr6Q\/wCEY0L\/AKA2n\/8AgMn+FH\/CMaF\/0BtP\/wDAZP8ACj6yuwfVn3Pm\/NGa+kP+EY0L\/oDaf\/4DJ\/hR\/wAIxoX\/AEBtP\/8AAZP8KPrK7B9Wfc+b80Zr6Q\/4RjQv+gNp\/wD4DJ\/hR\/wjGhf9AbT\/APwGT\/Cj6yuwfVn3Pm\/NGa+kP+EY0L\/oDaf\/AOAyf4Uf8IxoX\/QG0\/8A8Bk\/wo+srsH1Z9z5vzRmvpD\/AIRjQv8AoDaf\/wCAyf4Uf8IxoX\/QG0\/\/AMBk\/wAKPrK7B9Wfc+b80Zr6Q\/4RjQv+gNp\/\/gMn+FH\/AAjGhf8AQG0\/\/wABk\/wo+srsH1Z9z5vzRmvpD\/hGNC\/6A2n\/APgMn+FH\/CMaF\/0BtP8A\/AZP8KPrK7B9Wfc+b80Zr6Q\/4RjQv+gNp\/8A4DJ\/hR\/wjGhf9AbT\/wDwGT\/Cj6yuwfVn3Pm\/NGa+kP8AhGNC\/wCgNp\/\/AIDJ\/hR\/wjGhf9AbT\/8AwGT\/AAo+srsH1Z9z5vzRmvpD\/hGNC\/6A2n\/+Ayf4Uf8ACMaF\/wBAbT\/\/AAGT\/Cj6yuwfVn3Pm\/NGa+kP+EY0L\/oDaf8A+Ayf4Uf8IxoX\/QG0\/wD8Bk\/wo+srsH1Z9z5vzRmvpD\/hGNC\/6A2n\/wDgMn+FH\/CMaF\/0BtP\/APAZP8KPrK7B9Wfc+b80Zr6Q\/wCEY0L\/AKA2n\/8AgMn+FH\/CMaF\/0BtP\/wDAZP8ACj6yuwfVn3Pm\/NGa+kP+EY0L\/oDaf\/4DJ\/hR\/wAIxoX\/AEBtP\/8AAZP8KPrK7B9Wfc+b80Zr6Q\/4RjQv+gNp\/wD4DJ\/hR\/wjGhf9AbT\/APwGT\/Cj6yuwfVn3Pm\/NGa+kP+EY0L\/oDaf\/AOAyf4Uf8IxoX\/QG0\/8A8Bk\/wo+srsH1Z9z5vzRmvpD\/AIRjQv8AoDaf\/wCAyf4Uf8IxoX\/QG0\/\/AMBk\/wAKPrK7B9Wfc+b80Zr6Q\/4RjQv+gNp\/\/gMn+FH\/AAjGhf8AQG0\/\/wABk\/wo+srsH1Z9z5vzRmvpD\/hGNC\/6A2n\/APgMn+FH\/CMaF\/0BtP8A\/AZP8KPrK7B9Wfc+b80Zr6Q\/4RjQv+gNp\/8A4DJ\/hR\/wjGhf9AbT\/wDwGT\/Cj6yuwfVn3Pm\/NGa+kP8AhGNC\/wCgNp\/\/AIDJ\/hR\/wjGhf9AbT\/8AwGT\/AAo+srsH1Z9z5vzRmvpD\/hGNC\/6A2n\/+Ayf4Uf8ACMaF\/wBAbT\/\/AAGT\/Cj6yuwfVn3Pm\/NGa+kP+EY0L\/oDaf8A+Ayf4Uf8IxoX\/QG0\/wD8Bk\/wo+srsH1Z9z5vzRmvpD\/hGNC\/6A2n\/wDgMn+FH\/CMaF\/0BtP\/APAZP8KPrK7B9Wfc+b80Zr6Q\/wCEY0L\/AKA2n\/8AgMn+FH\/CMaF\/0BtP\/wDAZP8ACj6yuwfVn3Pm\/NGa+kP+EY0L\/oDaf\/4DJ\/hR\/wAIxoX\/AEBtP\/8AAZP8KPrK7B9Wfc+b80Zr6Q\/4RjQv+gNp\/wD4DJ\/hR\/wjGhf9AbT\/APwGT\/Cj6yuwfVn3Pm\/NGa+kP+EY0L\/oDaf\/AOAyf4Uf8IxoX\/QG0\/8A8Bk\/wo+srsH1Z9z5vzRmvpD\/AIRjQv8AoDaf\/wCAyf4Uf8IxoX\/QG0\/\/AMBk\/wAKPrK7B9Wfc+b80Zr6Q\/4RjQv+gNp\/\/gMn+FH\/AAjGhf8AQG0\/\/wABk\/wo+srsH1Z9z5vzRmvpD\/hGNC\/6A2n\/APgMn+FH\/CMaF\/0BtP8A\/AZP8KPrK7B9Wfc+b80Zr6Q\/4RjQv+gNp\/8A4DJ\/hR\/wjGhf9AbT\/wDwGT\/Cj6yuwfVn3Pm\/NGa+kP8AhGNC\/wCgNp\/\/AIDJ\/hR\/wjGhf9AbT\/8AwGT\/AAo+srsH1Z9z5vzRmvpD\/hGNC\/6A2n\/+Ayf4Uf8ACMaF\/wBAbT\/\/AAGT\/Cj6yuwfVn3Pm\/NGa+kP+EY0L\/oDaf8A+Ayf4Uf8IxoX\/QG0\/wD8Bk\/wo+srsH1Z9z5vzRmvpD\/hGNC\/6A2n\/wDgMn+FH\/CMaF\/0BtP\/APAZP8KPrK7B9Wfc+b80Zr6Q\/wCEY0L\/AKA2n\/8AgMn+FH\/CMaF\/0BtP\/wDAZP8ACj6yuwfVn3Pm\/NGa+kP+EY0L\/oDaf\/4DJ\/hR\/wAIxoX\/AEBtP\/8AAZP8KPrK7B9Wfc+b80Zr6Q\/4RjQv+gNp\/wD4DJ\/hR\/wjGhf9AbT\/APwGT\/Cj6yuwfVn3Pm\/NGa+kP+EY0L\/oDaf\/AOAyf4Uf8IxoX\/QG0\/8A8Bk\/wo+srsH1Z9z5vzRmvpD\/AIRjQv8AoDaf\/wCAyf4Uf8IxoX\/QG0\/\/AMBk\/wAKPrK7B9Wfc+b80Zr6Q\/4RjQv+gNp\/\/gMn+FH\/AAjGhf8AQG0\/\/wABk\/wo+srsH1Z9z5vzRmvpD\/hGNC\/6A2n\/APgMn+FH\/CMaF\/0BtP8A\/AZP8KPrK7B9Wfc+b80Zr6Q\/4RjQv+gNp\/8A4DJ\/hR\/wjGhf9AbT\/wDwGT\/Cj6yuwfVn3PnQ9K+jPDP\/ACKuk\/8AXnF\/6CK+cz0r6M8M\/wDIq6T\/ANecX\/oIqsXsicLuzToqtqdy9npd1cxhS8MTOobpkDPNZNtrEslhJcnU7C4CopKW0PzISR1+c\/0rhO036KxodZaLzllWS4ma5eOGKMKGIHPcgce5rSs7uO+tUnhztbPDdQRwQfcGgCeiikZgilmOFUZJPYUALRWJYa+0lndz3sOwQr5yKnVoT9089+DUmr621hFKLa2kmnSNJcDGArMRzkj0\/lQBr0VlvrscTsGtrjbHt8+QBSsJIBw3PPUZxnFNl8QwxSOPsl00aTeSZVVSu89B1zzkc4oA1qKzl1lXgkYWd150cvlNBhS4bGRznbjHfNVv7fea8sY7azmaOd3SUnbmNl4I+92\/H2oA2qKyItdBgjCwz3UzKzssKAFVBIyQT7euTSy+I7dMtDBcXEawrcM8ajCoc88kdMHjrQBrUUiOJEV1OVYAg+1LQAUVl6\/qUmmWtu8UsEPmzrE0k4yqAgnPUenrTItXKQxDzY9TmmLeWLJAoIXr1Yjj60Aa9FZi69BLLBHDBcStMhf5VA8sA4O7J4INRReI0m8ny9PvWNwheAYQeYB1x83GM98UAbFFZTeIYPLgaG3uJmmjMuxANyqODkEjP0GTWorB1DDOCM8jBoAWiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKYztvCKuWI4JOBQA+ioyHtyqPlwTwwPNSEZBHrQAuD6UmDWBcaTAms2cCz3wikjkZ1+2S8kYx\/F70morY22pWtte30tvbCByu68dNzbh1bdk9+tAHQUViSeVHpDyaPczTxtIokkSdp2C5+bbknnHpTrOG3klU6ZfySx8rcRSXDOcEe5yrZ+lAG1g+lJXPyaTANehthPfeS1u7lftkvUMoB+97mt6KNYYljUsVUYBZix\/Enk0dLgfMR6V9GeGf+RV0n\/rzi\/9BFfOZ6V9GeGf+RV0n\/rzi\/8AQRXdi9kcWF3Zcv7X7bp9xa79nnRtHuxnGRjOKhuNOE+l\/Yw4X5VXeF9Mdvwq7RXCdpiXXhtLkbi8LyCZpVE0PmJ83UFc89OuRWnYWi2NnHAgjAXr5aBFyeuAOlWKKFoAVW1G0N\/YS2olMQlG1mAydvcfiMirNFAGJJ4Xtgx+zzTxq8DQOHlaTKnpjcTjBpW0K5nFy11fI8ksCwqUh2hdpJBxk561tUUAY8uiTy+cn2xVhutpuUEXLEAA7Tn5QQO+albRgbeWITYD3K3AO3pgg7f061p0UAY97oJumuGWdP306zbJI96HCBdrLkbhxmm2egNYpbCG4jUwTvLgQ4Uq\/VQAePatqigNzGj0Oe12PZXixzBDG7PFuDKWJGBkYIyeafHoCQ29xDFMQktoLUZGSMZ+b3+9WtRR0sHmMhj8mCOPOdihc+uKfRRQBUv7D7cbXL7PInWb7ud2ARj9aZfWEs1xDc2k6QXEIZQXj3qVbGQRkeg71eooAzLPRRZyrIJi5EToxK\/eZjkt+fanW2k\/Zjp377d9ijaP7uN+7HPt0rRooAw5\/Dskunw2i3MJRFKnzYA+CT95eQVYeua2Yo\/KhSPczbFC7mPJ9zT6KACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKZIrNt2YyGB5p9FADMSGUM7KwC4zjBp9FFAFG4t5X1mznVcxRxyKzZ6E4x\/Kob77RBq0NzFYy3UYhaM+WUypJB\/iI9K1KKAM9p76e38y3s3tpI3BMU5T96vcAqTiq5juL\/UrWf+z3s\/IYs8sjJucYI2jaTkZOefStiigCjJbSnXobkL+5W3dC2e5ZSB+hq9RRQB8wHpX0V4ZJ\/4RXSflP8Ax5xf+givnU9K+jPDP\/Iq6T\/15xf+giu7F7I4sLuzS3H+6aNx\/umlpcH0rhO0buP900bj\/dNLRQAm4\/3TRuP900pIHUgfU0gZT0YH6GgA3H+6aNx\/umlooATcf7po3H+6aWigBNx\/umjcf7ppaKAE3H+6aNx\/umlooAaGJGdppdx\/umhPuL9KXBoATcf7po3H+6adg+lJQAm4\/wB00bj\/AHTS0UAJuP8AdNG4\/wB00tFACbj\/AHTRuP8AdNLRQAm4\/wB00bj\/AHTS0UAJuP8AdNG4\/wB00tFACbj\/AHTRuP8AdNLRQAm4\/wB00bj\/AHTS0UAJuP8AdNG4\/wB00tFADd3ONpzS7j\/dNJ\/y0\/CnUAJuP900bj\/dNLRQAm4\/3TRuP900tFACbj\/dNG4\/3TS0UANDZ\/hNLuP900L3+tLQAm4\/3TRuP900tFACbj\/dNG4\/3TS0UAJuP900gbIyFNOpqfcFAC7j\/dNG4\/3TS0UAJuP900bj\/dNLRQA3dyBtPNLuP900h+8v406gBNx\/umjcf7ppaKAE3H+6aNx\/umlooATcf7po3H+6aWigBNx\/umjcf7ppaKAE3H+6aNx\/umlooATcf7po3H+6aWigBNx\/umjcf7ppaKAE3H+6aNx\/umgEMMggj2paAE3H+6aNx\/umlooATcf7po3H+6aWigBNx\/umjcf7ppaKAE3H+6aTdjHynmnUjfeX60AG4\/3TRuP900tFACbj\/dNG4\/3TS0UAJuP900bj\/dNLRQAm4\/3TRuP900tFACbj\/dNG4\/3TS0UAJuP900bj\/dNLRQAm4\/3TRuP900tFACbj\/dNNaUKcEGn1BN9\/8KAPmc9K+jPDP\/Iq6T\/15xf+givnM9K+jPDP\/Iq6T\/15xf8AoIruxeyOLC7s0z0P0ryPTPEklr5hv3ur3eq7QdQki2HnPTrnI\/KvXDyCPUVy\/hjSNY8OWEtr9nsLjzJTJvNwy44AxjYfSuanKEU+ZXOipCcmuV2Knw81O7vUvYLq6e4WIIys7biCd2eTzjiuzrnvDeh3mmanqt5eGAfbpN6pE5bb8zEgkgf3q6GpqOMpXirIdJSjFKTuzh\/EOubvFQtDoi6kLOJh5Zy27eEO7G04x0\/Gs+78QiwmtLxfCi2Bgm3b8FN\/yMNudg9c\/hXUat4dM+pvfWMELS3ELRXPmyY3coVIBVl42Y6VSTwnLceVb31ta\/YzMJZQkoDNhWAA2Rp3bue1NSj2Bxl\/MdYp3KD6gGo7l5IraR4IvNkVcqmcbj6ZqUDAAHQUVC0Zb1RzNv4h1eOwNzeaMxiQsXkWQKQAf7p54roredLq2iniOY5VDqfY1T1fTp9ThWCK9a2hORMqoCZAe2e1XLeBLW2igiGI4lCKPYVvVlTlFOKs\/K+3z\/QwpRqRk4ybatu7b\/L9SSoJLhhKY4oy7AZPOMVPULQHz\/NRypONwxnNc50CW8sshcSR7QDwanoooARPuL9K4PxCt5ceJZlj1W\/to\/PjhEcEUrqoMW4kbTgnPbr3rvE+4v0rm9S0C8uNYe6hVHjadJv+P2SE8R7MYUYznnd17U07O4mrqzOeXTLw6g9t\/wAJDrO1Ylk3fY7nJJJGNuc446\/4V1vhVpf7CC3FxLcNHPLH5sqsrsFcgZB5H0NUV0TUBqD3P2cbWiWPb\/a9xkEEnO7bnHPT\/GtjRbGTT9PMM+N7SySECQyYDMTjceT16mnKTkhRiolCLWrlhaXMktkkF24Eds52ylScZDE4J9sVY\/tsTAmKGaNFuRB5joCHOSCBznt1po0OYRR2n2tTYRyB0jMX7wYOQu\/OMZ9qmGkYtVh877t0bnO31YnHX361P9fl\/wAEpleTWnnv7KO1imS3kuTGZmC7JQAcgc56jrgVckv2t9Wa3uNiwNAZY375X7wP4YNVodEmiuLcfa1NrbTGWKLyvm5B4LZ56+lT6xpI1a3jj80wsjhtwGcr0ZfoRxR0DqVbbW3EUc18REjwNPsVDwu7C8569OMVPFrsLypFLbzwSs6rsk28BgSrHBPHGKW\/0WK\/dg77YjbmDYB05yD+nSqieGlGnXNtutopJgoEttbCLbg5B6nJ\/GgC5aa3bXpiEKyEyyPGARjG3q306fnUGqeJIdK1S1sJLO8lluuImiQFSe\/Oe1TWmjR2epG7RztMKxiPHAI4LfiAPyrRKKzKxUFl6EjkUALVfUI7mWwnSyl8q5K\/u3wDg\/jx7VYooA4qHXxqD\/YbDV9UGqltnkSwxYQ\/xEnZ0H19K6bWr2XTNEnuY2QyxKvzSD5c5AJI\/HNUbDRntvGeqakYEENxBGsTjGdw+\/8AnxWnqdj\/AGlp0trv8vzMfNjOMMD0\/ChjW5nwapIYBKdSsrtTKkebaL7pPY\/OahtNbuzfW1vJA0scsk4aX5RtCHjuOnfita9shdwxRhgnlyJJkL129qppojRTW8iXAzFJKzBk+8snUdeCPWjqIF8R2xVnaGdYvLeSJyBiZV67RnP54q\/ZXP2y1SfyZYQ4yEkxux2PBNY1v4Vit45YkNqFaN40dbYCUbu7Nnn8MVuxJ5UMcec7FC59cDFAC\/8ALT8KSbd5fy785\/hxn9aX\/lp+FJNH5ibfk6\/xLkflQBEiyPnMkyY9dn9KfEvO4TtIOmDjH6Ckit9gYMI8MMfIm3+tENpHAdyg7ueSaAJqhKHft+0uCeQPl\/wqaoBZRLMJACCO2e9ADGEqsQGnYDuNlWh0FV5LYvIzYg5\/vR5P55qwOABQAi9\/rTJ3Kx4Q4djtWnr3+tMkhWV1MgDKo4Ujv60AMW5xCpZSzlthC+tKJ\/lJCSMdxGOOP6UgtVWTKEKm4NtA70j2pb+MY3FiGXIOfagBY5\/NlXbkKUJwfXNDXardCDy5Cx6EDiiG28kr82QoI6Y71PgZzjmgApqfcFOpqfcFADJ5HjAZQuMgHNNllkDuI9uEXcdw61JLH5qbc45BpksLO7MjhdwwwIzQA5pgkHm7WIxnA60lvOLmISKrKp6bu9SKoVQo6AYpQMDA6UANP3l\/GnU0\/eX8adQBnXdy8d60f2nyUCAj5N2TVmxlea2DyEE5IBHcU2W1ka5aaKfyyyhSNmelSW1v9miK7ixJLE+9AE1FFNcMVIRgrepGaAIbYvI8jmVigYqoIFWKjt4jDCELBiO4GKkoAB1qvHK7WjuT8w3YP0NWOlUikwDIiSrGxORhc8++aALUTFoUY8kqCfyp9Nj4jUbSuBjB7U6gCrdTN5iRp5oXPzsiEkU+3fqheR\/QshGB9afKspwYXCkdmGQabBC0ZdnYM8hycDAoAmpsrqkbFumMcU6mugkUq3Q0AUoRNali64QKCVA49OvrV8HIzUQiZiDK+7b93j9T70W0Bt4thcvyTk0ALPMLeIyMrMo67aWGTzolcKyhuQG608jIwelFABVS4kfzSyMQsIBYA\/e9vyq07iNC7HCqMk1R86wyxYq5Y5JZcn+VAF8EEAjoaCcAnGcdhUFrLE8e2Fy4TjJqegCC2ulugxVHUKcHcO9TN95frSgAdBikb7y\/WgBaqsZdxwZ8Z7bMVaqs1oWYnEHJzzFk\/wA6AHwq5+ZpJP8Adbb\/AEpLi7W2ZAyO2\/gbR3p0VusfJSPf6qmKlIB6jpQAVFO2NvzyL\/uLn+hqWmOjPjbIyY\/u45\/OgCBW3MAJ7jJ9Y8f0qaLgsPMZyDzuAGP0oliZ1QLIy7SCT60qR7CTuLMepNAD6rXdy0SMIlLOByR0Ue9WagEMqIyRyIFbPJTJ\/nQBBp1xLLuR8sB0f+lXqihiMMaoCuB1wuM1LQBWvGkGxUztPLEA9iOMjp3qJUeZG8tSpHGTM+QfoRV6q1rbPBNO7FSJGyMfjQBZqCb7\/wCFT1BN9\/8ACgD5nPSvovwz\/wAirpP\/AF5xf+givnQ9K+gPDiqfDOlkqP8Aj0i7f7Iruxfwo4sLuzfoqjsX+6Pyo2L\/AHR+VcJ2l6iqOxf7o\/KjYv8AdH5UAXqKo7F\/uj8qREXH3R1NAF+iqOxf7o\/KgqoIG0cn0oAvUVR2L\/dH5UbF\/uj8qAL1FUFRcH5R1NLsX+6PyoAvUVQZFyvyjrS7F\/uj8qALifcX6U6qOxf7o\/Ksebw4tzPLMdS1KPe5OyObCrz0Ax0q4Ri37zsRNyXwq501Fcv\/AMIsn\/QW1X\/wI\/8ArUf8Isn\/AEFtV\/8AAj\/61aezpfz\/AIMjnqfyfidRRXL\/APCLJ\/0FtV\/8CP8A61H\/AAiyf9BbVf8AwI\/+tR7Ol\/P+DDnqfyfidRRXL\/8ACLJ\/0FtV\/wDAj\/61H\/CLJ\/0FtV\/8CP8A61Hs6X8\/4MOep\/J+J1FFcv8A8Isn\/QW1X\/wI\/wDrUf8ACLJ\/0FtV\/wDAj\/61Hs6X8\/4MOep\/J+J1FFcv\/wAIsn\/QW1X\/AMCP\/rUf8Isn\/QW1X\/wI\/wDrUezpfz\/gw56n8n4nUUVy\/wDwiyf9BbVf\/Aj\/AOtR\/wAIsn\/QW1X\/AMCP\/rUezpfz\/gw56n8n4nUUVy\/\/AAiyf9BbVf8AwI\/+tR\/wiyf9BbVf\/Aj\/AOtR7Ol\/P+DDnqfyfidRRXL\/APCLJ\/0FtV\/8CP8A61H\/AAiyf9BbVf8AwI\/+tR7Ol\/P+DDnqfyfidRRXL\/8ACLJ\/0FtV\/wDAj\/61I3hZApP9rar0\/wCfj\/61Hs6X8\/4MOep\/J+J0\/wDy0\/CnVQSNQijGcADJ6ml2L\/dH5VgbF6iqOxf7o\/KjYv8AdH5UAXqKo7F\/uj8qNi\/3R+VAF6iqOxf7o\/KjYv8AdH5UAXF7\/WnVR2L\/AHR+VGxf7o\/KgC9RVHYv90flRsX+6PyoAvUVR2L\/AHR+VGxf7o\/KgC9TU+4Kp7F\/uj8qNi\/3R+VAF6iqOxf7o\/KjYv8AdH5UAXqKoMi8fKOopdi\/3R+VAFw\/eX8adVHYv90flRsX+6PyoAvUVR2L\/dH5UbF\/uj8qAL1FUdi\/3R+VGxf7o\/KgC9RVHYv90flRsX+6PyoAvUVR2L\/dH5UbF\/uj8qAL1FUdi\/3R+VGxf7o\/KgC9RVHYv90flRsX+6PyoAvUVR2L\/dH5UbF\/uj8qAL1FUdi\/3R+VMdVGeB92gDRoqlsX+6Pyo2L\/AHR+VAFwgMCGwQeoNR\/Z4P8AnlH\/AN8iq2xf7o\/KjYv90flQBcSNI87FVc9cDFOqjsX+6KXYv90flQBdprfeX61T2L\/dH5UbF\/uj8qAL1FUdi\/3RS7F\/uj8qALtFUti\/3R+VJsX+6PyoAvUVR2L\/AHR+VGxf7o\/KgC9RVHYv90flRsX+6PyoAvUVR2L\/AHR+VGxf7o\/KgC9RTLOKN423RocNjkewqx9nh\/55J\/3yKAIqKl+zw\/8APJP++RR9nh\/55J\/3yKAIqgmPz\/hVz7PD\/wA8k\/75FH2eH\/nkn\/fIoA+Wz0r6B8N\/8ixpf\/XpF\/6CK+fj0r6B8N\/8ixpf\/XpF\/wCgiu7F\/Cjiwu7NKiiiuE7QooooAKan3T9TTqan3T9TQA6mt1X606mt1X60AKzqilnYKo7k0BgwBUgg9CKrXzFEiYDJDkgHvhTTbGUsXQY28uCPdj\/hQBaTofqadkeo\/Oq9yA1sQwBBkUEH\/eFWfsVpn\/j3h\/75FADG6r9adVe3UKhVQAomcADoOTUk8nkwSSf3VJ5oAkBBGQcj2pqdD9TUdmu21jyqqSNxCjjJqROh+poAdiiuK1Nry48RanDbtqryRqnkC2l2xoxX+IE4xmr41LVnubixmS0ZLazWS5LbtzEocgY9xSvpcdtTpqK4mDxHqMGmM1rDaLBaWcMzI24khuoBz\/OtEeIL6Fr+K6+xRyQxxSRv823D9iOST9OtN6COlorkl8T6lLGIYYrY3X2z7NukR0UgrkHaeRViXxBfwaqdLkjtzeNPGI8KdpiIyzdeowaFqB0tFYOrtLeeIrPS\/tM1tbvC8zNC+xnIOAM1CL69tHtdMsby3vZ5HkxcT8hFX+FsHluaAOkoriW12We+t9TWNFmi0+4yh5XcrY\/Kr2peJry0H7mOBibOOcbgfvMwGOvSj+vz\/wAgen9f13Ooork5\/EOsWpvPNjsWFm8fmFQ3zq+OBzwRnrT5fEeox3NxII7U2cF8tqVw3mENjnOcd6FqB1NFB4NFABRRRQAUjfdP0paRvun6UAA6D6UtC\/w1yOlzThbG4YXqb7hlknlmLxyDJ+ULuOPyHSgOh11FY1tqt0wtbmcQC2u2Koigho+uCWzg9OeBiqo8Q3S+cMRSHyWljIhdFBBxjcfvj3FAHR0VhXd1qEsFxbB7YOlm00reWcNkHCqM8fX9KluJ5IPDdqYnMbOsSFx1UHAJoA2KKwJLr+xrq7RFuyiQ70WeTerndjcGJJHXoank1K7s2nhu3tTKsAmSRVZVGTjBHJPtjrQBsUVzY1KW+kgjm5eC\/iXeIWi3AqT91uRVjxHqM9m1ulvMYySXYC2eTIHPVT+lD0A3KK51zdHw9aXL3k\/mBkyFUx7st3B57464ro2+8frQFxKKKKACiiigAooooAa\/8P1FOpr\/AMP1FUPEEjxaBevEzq6x8FDgjkdDQxpXZo0VzMd7Lpck7+TdRJ9mDJBdTeYXfcBuBy2Bz0z+FXpdSu7I3EF09qZkjWRJFVlXk4wV5JOemOtAjYorn4davbgrBF5XnfaRCZJIHjG0jOdhOQfxpt5dXd2IpGaEW0d\/HFtCneSDyc5x+GPxoW\/9eX+YHRUVm6lun1G1tDJIkMiu7CNyjOQOFyOR+FUrW\/uERbODzVme5aJfteHMQC7sHDfN7c0Ab9FYcmsXKwGMtAlyk7QuwieTdgZyqLyevrxSaXetqOqW1yy7WksmyORyJMdD9KFqBu0Vy2tandjVHt7e5eNBtjwtnKSCxHO4HB471fuIJv7RhEd1NJePIHIUlY44u4K5xz780LUGbVFFFABRRRQAUUUUAFMk6n\/dp9Mk6n\/doAyfELP5mnRotw6yXBDR28nls42k4zkfzqvZXt3GBZxErPJcuiC5JkMChd2G5+Y\/j361sXthb36xi4D\/ALpt6MkjIVOMdQRUX9j2X2YQ+W23f5gfzG37vXfnOfxoQMoy6zci2C7oUuEleNyInl3bRnKovOOR34pLbWrq6KSKkSQrbefICp3EgkYHp071oNo9k0UUflsoiyVKSMrc9csDk575p9vptraACGIKNnl4yT8uc45+tH9fgBmWcl3NrVlNdtCfNs3dVjUjaCVODknP14p12Hu7y\/3G6cWwQRxW0uwjIyW6gH8fSr9rpNnZTCWCNg4UopaRmCqewBPA9hS3WmW15KJJVcSY2lo5GQsPQ7SMj60PyBGdDqV5dRoto8WYrZZpHnTmTOeMA4HQ881FeeIpYoI7mHy\/L8lJWi8p5G+bsWHCexPWtJ9M0+8RNqDbEPLHlSFeB\/CcHkexpJ9J068mdHTLhFV40kKjb\/DlQceuM0wG6U2JtUPPF0T0z\/AtYtnqt7c6uM3LNEGeTb9jlQEKMYyTgc5\/EV08EEUDSmIYaR9785y2AM\/kBSQ2cFu26JMEgjqT1OT+ppAY2j3d0xhe6QiW\/jMkUhmLqCBnBTgLx6fjW6m4IvmEF8fMQMDNVIdJs4JXeJCGYFf9YTsB67Rn5fwxVobIIRk7URerHoB6k0APopiTRyEiORWIAJAOcA9KfQAUUUUAFFFFAFyw\/wBW\/wDv\/wBBVqqth\/q3\/wB\/+gq1QAUUUUAFFFFAHyselfQPhv8A5FjS\/wDr0i\/9BFfPx6V9A+HP+RY0v\/r0i\/8AQRXdi\/hRxYXdmlRRRXCdoUUUUAFNT7p+pp1NT7p+poAdTW6r9adTW6r9aAEliEq4bIwcgjqDSRQiLcdzMzdWbrUlFADNiyIyuoZSTkEcdaiksYHjZVjWMkY3IMEVMnQ\/U06gCMRrEqIihVB6AYp7KrqVcBlPUGkbqv1p1AAAAAAMAdqanQ\/U06mp0P1NAEUVlBBdT3MaYmnx5jZPzY4FNOnWxuLify\/3lygjlbJ+ZR0H61ZooAzV8P6asEsItv3csSwuN7covQdafPoen3JmM1uGMyIjnceQv3cc8Y9RV+igDNg8PabbsrRW5DLKJgTIxO\/GM8n0pg0qSXxMdTn8rZFD5UAXO455Jb+latFAFTUNKs9VRFvIfM2HKkMVKn2I5qCTw9pktnFataqIYSTGFYqVJ6nI55rSooAorounqY9tsoEcLQKATgIeoxVePwtpESMq2pwyhDmRjwDkDr61rUUAUZtGsZ\/tHmQbvtO3zfmPzbfu9\/ahtFsHSVWgysswuHG48uOh61eooAKKKKACiiigApG+6fpS0jfdP0oAVegrPt9DsbWRHijk+RiyK0zsqn1Ck4FXx0H0paAKcWkWUM5lSH5jnCliVXPXCngZ9qjTQrBM4ic5Up80rHCnqBk8D6VoUUAVLvSrS9KmeNiVTZlXZcr6HB5Hsama1ha1+zNGrQ7dmw8jFS0UAU4dJs4RIBG0nmLsYyyNIdvp8xOB7U1NGskgli8pmWUAMXkZmwOgBJyMdsVeooApRaPZwtuWNy3mLIWeRmJZRgEknnip57WG5KmZNxUEDkjAPWpqKAIpraK4hEUqbowQQM46dKl60UUAFFFFABRRRQAUUUUANf8Ah+oplzbRXltJbzruikG1hkjI+op7\/wAP1FOoApRaPZxLIPLeTzE2MZpGkO30yxOBSLo1ksEkPlMyyY3M8jM3HTDE5GO1XqKAKcOk2lu4eONt4cSbmkZiWxjJJPPFI+j2cl19oaJvM3iTAdgu4dG25xn3q7RQBBdWcN6irOpO05VlYqyn1BHIqH+yLP7N5Hltt37929t+7+9uznPvmrtFAFI6PZmGOMRsojYsrJIytk9csDk575p9tptrZlDbxbCiGNfmJwpO4j86tUUAQm0haczFP3hIOcnqOn86rto1o13Jc\/6QssjBnKXDqGI9gcVeooAKKKKACiiigAooooAKZJ1P+7T6ZJ3\/AN2gDO1uJbj7LEXiLGQlYZwfLm4+6T+tZSRiSazWGSa0EV6yPCjKyK23OFJHT\/E10s8EN1EYriJJYz1V1BB\/CmfYbTyFg+zQ+Sh3LHsG0H1AoQMwbbUdUu5t6eaqyPJHg+VsTGcFRndngZzTU1y8n2sjhVuAtvD8oys4xuP6n8q6FbO2S6a5WCITtwZQo3H8aUW0ChQsMYCMXUBRwx6ke9CAw21S4XVotks0kD3PkEFUWP8ADnfuB79KLe6vpYrMSX7obu4kUuEUeWqlsBeMZOB1zWz9gs\/tBuPssHnkgmTYN2frTns7aW38iS3iaHOfLZAVz16ULYOpztvNdRaei21yx\/fTFzEU8xsMeQG4I9aPPnlkvr62vChSzhkysYxIfm6g5wPp+db76dZSQLC9pA0SnKoYwQD64qT7PBhx5UeHUKw2j5gOgPtR0H\/X4mFLeTm\/KRTi3E1xGjOqLnBQnqR1+tX7C5uJLK9VpfPkt5HjSXABfABHTjPOOPSprzS7e8aHckYVJN7qUBEnBGD+dWoYYreJYoI0jjXoqDAH4UdxdjDsINPjtNOui\/l3cgBMicvK2PmDdyOvXpiqh1O5m8xGlllguLaVlMioqnHQoAdwH+9XRx2VrDcNPHbwpM\/3pFQBj9TTU06yjdnS0gVnzuIjAJz1zQ9bgtDEjknjW6NrIscpS2UEkAkEchc8bvTNauj3D3Fo\/myySSRyFG8xVDD2O3gnnqKstaWzo6PBEyOAGUqMMB0Bp0MEVtEIoI0ijXoqDAH4U76sSVkiSiiikMKKKKALlh\/q3\/3\/AOgq1VWw\/wBW\/wDv\/wBBVqgAooooAKKKKAPlY9K+ifDMUZ8LaSSikmzi7f7Ir52PSvovwyR\/wiuk8\/8ALnF\/6CK7sXsjiwu7NHyY\/wDnmv5UeTH\/AM81\/Kn5HqKMj1FcJ2jPJj\/55r+VHkx\/881\/Kn5HqKMj1FADPJj\/AOea\/lTIooypyi\/ePb3qbI9RUcRGw8\/xH+dAC+TH\/wA81\/KmPFGGj+ReW9PY1NkeoqOQjdHz\/F\/Q0AL5Mf8AzzX8qPJj\/wCea\/lT8j1FGR6igCGKKMqcov3j296f5Mf\/ADzX8qSIja3P8R\/nUmR6igCF4ow0eEXlvT2NP8mP\/nmv5UkhG6Pn+L+hqTI9RQAzyY\/+ea\/lVS6uLbT9PuLu5VRFDuZjjsD0q9keorM1jTf7Y0G9sA4UzBgCexzkfqKAOL\/4WDcNaPqK2mnC1WcRfZmY+eRjO70x+Fdzpd3aatpsF7bIvlTLkAjkeoNeYDRNWj8OTaCdKuTdvfLOJQo8raF2\/er0nw3pR0PQLWxdwzxglyDxuJycUAaPkx\/881\/KjyY\/+ea\/lT8j1FGR6igBnkx\/881\/KjyY\/wDnmv5U\/I9RRkeooAZ5Mf8AzzX8qPJj\/wCea\/lT8j1FGR6igBnkx\/8APNfyo8mP\/nmv5U\/I9RRkeooAZ5Mf\/PNfyo8mP\/nmv5U\/I9RRkeooAZ5Mf\/PNfyo8mP8A55r+VPyPUUZHqKAGeTH\/AM81\/KqlwUjaQsUjjjGSSBgDHU5q9keoqnOoMsgZSyuBxjIIxQBTtb+yvnK2l7bzsoyREyMQPwrQVEe13lF3FSelZelaNY6MJhY2zR+c+9jtOfp9K1kG2zCnghDQA5YY9q\/u16elL5Mf\/PNfypVI2LyOgp2R6igBnkx\/881\/KjyY\/wDnmv5U\/I9RRkeooAZ5Mf8AzzX8qPJj\/wCea\/lT8j1FGR6igBnkx\/8APNfyo8mP\/nmv5U\/I9RRkeooAZ5Mf\/PNfyo8mP\/nmv5U\/I9RRkeooAZ5Mf\/PNfyo8mP8A55r+VPyPUUZHqKAGeTH\/AM81\/KjyY\/8Anmv5U\/I9RRkeooAZ5Mf\/ADzX8qPJj\/55r+VPyPUUZHqKAGeTH\/zzX8qPJj\/55r+VPyPUUZHqKAIZIoxswi\/fHan+TH\/zzX8qJCPk5\/jFPyPUUAM8mP8A55r+VHkx\/wDPNfyp+R6ijI9RQAzyY\/8Anmv5UeTH\/wA81\/Kn5HqKMj1FADPJj\/55r+VHkx\/881\/Kn5HqKMj1FADPJj\/55r+VHkx\/881\/Kn5HqKMj1FADPJj\/AOea\/lR5Mf8AzzX8qfkeooyPUUAM8mP\/AJ5r+VHkx\/8APNfyp+R6ijI9RQAzyY\/+ea\/lR5Mf\/PNfyp+R6ijI9RQAzyY\/+ea\/lR5Mf\/PNfyp+R6ijI9RQAzyY\/wDnmv5VDNEgJwij5CenuKs5HqKgnIy3P\/LM\/wAxQBJ5Mf8AzzX8qPJj\/wCea\/lT8j1FGR6igBnkx\/8APNfyo8mP\/nmv5U\/I9RRkeooAZ5Mf\/PNfyo8mP\/nmv5U\/I9RRkeooAZ5Mf\/PNfyo8mP8A55r+VPyPUUZHqKAGeTH\/AM81\/KjyY\/8Anmv5U\/I9RRkeooAZ5Mf\/ADzX8qPJj\/55r+VPyPUUZHqKAGeTH\/zzX8qPJj\/55r+VPyPUUZHqKAGeTH\/zzX8qPJj\/AOea\/lT8j1FGR6igBnkx\/wDPNfyo8mP\/AJ5r+VPyPUUZHqKAHWgCiQKABv6D6CrFQWv\/AC1\/3\/6Cp6ACiiigAooooA+Vj0r6F8PIg8M6V+7j\/wCPOI8qD\/AK+ej0r6G8P\/8AItaT\/wBecXt\/AP8AOa7sX8KOLC7s0UjRpFBijwTj7gq59kt\/+eMf\/fIqpH\/rU+o7f5\/KtGuE7SH7Jb\/88Y\/++RR9kt\/+eMf\/AHyKmooAh+yW\/wDzxj\/75FNS2gIOYY+p\/hHrRGCt5IC7MCoOCenJqWL7p\/3j\/OgBn2S3\/wCeMf8A3yKa1tACmIY+Tg\/KPSrFMf7yf739DQAz7Jb\/APPGP\/vkUfZLf\/njH\/3yKmooArpbQEHMMfUj7o9ad9kt\/wDnjH\/3yKfH90\/7x\/nT6AK720AKYhj5OPuj0p32S3\/54x\/98inydU\/3v6Gn0AQ\/ZLf\/AJ4x\/wDfIpqW0BBzDH1I+6KsUyPof94\/zoAZ9lg\/54x\/98ij7Jb\/APPGP\/vkVNRQBD9kt\/8AnjH\/AN8ij7Jb\/wDPGP8A75FTUUAQ\/ZLf\/njH\/wB8ij7Jb\/8APGP\/AL5FTUUAQ\/ZLf\/njH\/3yKPslv\/zxj\/75FTUUAQ\/ZLf8A54x\/98ij7Jb\/APPGP\/vkVNRQBD9kt\/8AnjH\/AN8ij7Jb\/wDPGP8A75FTUUAQ\/ZLf\/njH\/wB8ij7Jb\/8APGP\/AL5FTUUAQ\/ZLf\/njH\/3yKPskH\/PGP\/vkVNRQBD9kg\/54x\/8AfIpHtYAjEQx5A\/uip6bJ\/q2+hoAiW1gKg+TH0\/uil+yW\/wDzxj\/75FSL9wfSnUAQ\/ZLf\/njH\/wB8ij7Jb\/8APGP\/AL5FTUUAQ\/ZLf\/njH\/3yKPslv\/zxj\/75FTUUAQ\/ZLf8A54x\/98ij7Jb\/APPGP\/vkVNRQBD9kt\/8AnjH\/AN8ij7Jb\/wDPGP8A75FTUUAQ\/ZLf\/njH\/wB8ij7Jb\/8APGP\/AL5FTUUAQ\/ZLf\/njH\/3yKPslv\/zxj\/75FTUUAQ\/ZLf8A54x\/98ij7Jb\/APPGP\/vkVNRQBD9kt\/8AnjH\/AN8ij7Jb\/wDPGP8A75FTUUAV3toBtxDHywH3RTvslv8A88Y\/++RT5P4f94U+gCH7Jb\/88Y\/++RR9kt\/+eMf\/AHyKmooAh+yW\/wDzxj\/75FH2S3\/54x\/98ipqKAIfslv\/AM8Y\/wDvkUfZLf8A54x\/98ipqKAIfslv\/wA8Y\/8AvkUfZLf\/AJ4x\/wDfIqaigCH7Jb\/88Y\/++RR9kt\/+eMf\/AHyKmooAh+yW\/wDzxj\/75FH2S3\/54x\/98ipqKAIfslv\/AM8Y\/wDvkUfZLf8A54x\/98ipqKAIfslv\/wA8Y\/8AvkUfZLf\/AJ4x\/wDfIqaigCH7Jb\/88Y\/++RTfs0HmgeTHjGfuirFM\/wCWw\/3TQAz7Jb\/88Y\/++RR9kt\/+eMf\/AHyKmooAh+yW\/wDzxj\/75FH2S3\/54x\/98ipqKAIfslv\/AM8Y\/wDvkUfZLf8A54x\/98ipqKAIfslv\/wA8Y\/8AvkUfZLf\/AJ4x\/wDfIqaigCH7Jb\/88Y\/++RR9kt\/+eMf\/AHyKmooAh+yW\/wDzxj\/75FH2S3\/54x\/98ipqKAIfslv\/AM8Y\/wDvkUfZLf8A54x\/98ipqKAIfslv\/wA8Y\/8AvkUfZLf\/AJ4x\/wDfIqaigCH7Jb\/88Y\/++RR9kt\/+eMf\/AHyKmooAjhRU3qiqoDdAMdhUlMT7z\/739BT6ACiiigAooooA+Vj0r6G8Pf8AItaV\/wBecPT\/AHB\/n9a+eT0r6J8OOB4Y0kEbv9DiHb+4OOld2L+FHFhd2X4v9an1Hf8Az\/8AXrRqisgLrgYJI54\/PpVvY3\/PRv0rhO0fRTNjf89G\/SjY3\/PRv0oAdtG7dgZ6ZpsX3T\/vH+dGxv8Ano36UyNCVPzt94+nrQBNTH+8n+9\/Q0bG\/wCejfpTHQ5T52+97elAE1FM2N\/z0b9KNjf89G\/SgAj+6f8AeP8AOn1DGhwfnb7x9PWn7G\/56N+lABJ1T\/e\/oafULocp87fe9vSn7G\/56N+lAD6ZH0P+8f50bG\/56N+lMjQ4Pzt94+nrQBNRTNh\/56N+lGw\/89G\/SgB9FRkbfvSkfXFGMjPnHHrxQBJRUePl3eacevFIMMcCYk+2KAJaKjCkjIlbH4Uuwn\/lo36UAPoqPGTjzTn04pdjf89G\/SgB9FM2N\/z0b9KNjf8APRv0oAfRTNjf89G\/SjY3\/PRv0oAfRTNjf89G\/SjY3\/PRv0oAfTZP9W30NJsb\/no36U10Plt87dD6UAPX7g+lOqNUO0fvG6e1AG44EpJHpigCSio8ZGfNOB34o2nj963P0oAkopmxv+ejfpRsb\/no36UAPopmxv8Ano36UbG\/56N+lAD6KZsb\/no36UbG\/wCejfpQA+imbG\/56N+lGxv+ejfpQA+imbG\/56N+lGxv+ejfpQA+imbG\/wCejfpRsb\/no36UAPopmxv+ejfpRsb\/AJ6N+lABJ\/D\/ALwp9QyIfl+dvvD0p5QgZMjY\/CgB9FR44z5px68Uuw5x5jZ\/CgB9FM2N\/wA9G\/SjY3\/PRv0oAfRTNjf89G\/SjY3\/AD0b9KAH0UzY3\/PRv0o2N\/z0b9KAH0UzY3\/PRv0o2N\/z0b9KAH0UzY3\/AD0b9KNjf89G\/SgB9FM2N\/z0b9KNjf8APRv0oAfRTNjf89G\/SjY3\/PRv0oAfTP8AlsP900bG\/wCejfpTNh84fO33fagCaimbCP8Alo36Um0n\/lq36UASUVHt\/wCmp\/Sjaef3rcfSgCSiowN33ZSfpigKT0kY\/lQBJRUQwTgTHPpkUpGMAykZ6ZxQBJRURwv3piPrilxxnzTj14oAkoqMrtGTKwHvigDIyJSQO4xQBJRTNpxnzGx+FNGGOBMSfQEUAS0UzY3\/AD0b9KNjf89G\/SgB9FM2N\/z0b9KNjf8APRv0oAE+8\/8Avf0FPqOMYLjJPzdT9BUlABRRRQAUUUUAfKx6V9DeH\/8AkWdK\/wCvKHr\/ALg\/z7188npX0N4f\/wCRa0n\/AK84vb+Af5zXdi\/hRxYXdmlF\/rU653f5\/wA\/hWjWdH\/rU+o7f5\/KtGuE7QooooAqxtL9q2mTeOS4xwvpU8X3T\/vH+dNS2jjcsu4EnJ+Y4z9KdF90\/wC8f50APpj\/AHk\/3v6Gn0x\/vJ\/vf0NAD6KKKAGR\/dP+8f50+mR\/dP8AvH+dPoAZJ1T\/AHv6Gn0yTqn+9\/Q0+gApkfQ\/7x\/nT6ZH0P8AvH+dAGHrl8NPMk7WlzdYZVEdum9hkdcelN0TUBqLLKtndWmJNhS4j2M3Gc49K15rNpJWdJAu7qCuaSKzZJVd5A23kALigDm\/idp9pc+C7+4ntoZJ4UXy5GQFky65we1VtR0+0j1nw7oyW8NvpV0JZpoI0CpPIqqVVgOvUnHfFddqWm2ur2EtlfRebbygB03EZwc9Rz1FM1DSLLVLRLa8h3xxkMhDFWQjoVYcg+4NC0B6o5my0+zg8aahocVtE2lS2Udw9oVBiSTeRwvQZABx7ZrC0lrDw54B1nVre1tobxbm5t4ZggDDMhVRn0HH5V6FpmjWWkLILOJg0rbpJJHaR3P+0zEk\/iarHwtpBtY7Y2gMMd19rVC7Y83JO7rzyTx0pW6eX6\/5aAnbXz\/T\/M4TwvcWmm6X4j0Czv47yFLE3UUkcocZaMiQZH+0M\/jXb+C\/+RL0fP8Az6R\/+g1au9B069vBd3FsGnED2+8MVzG33lODzUOmeGdP0dozZG7VY12pG95K6KPTazEfpVX3+X4XC2it\/V7HF6VbyeHfGcUWvaaJXu7uQ2WsQSHLlufLlAOenAzxxwO9el1j2vhTSLO9W5gtmDo7SRoZXaONj1ZUJ2qeT0Hetil0SB6tsKKKKACiiigAooooAKbJ\/q2+hp1Nk\/1bfQ0AQ3KyvYTLbsqzGIiMt0DY4z+NeZ+Td+DdI1DSjDYtqB0lrgXtpH5ch+bDBmJy3XIbj6V6e8MdxbNDMivHIu1lYZBBHIrOsPDGlackywWxYTR+S\/nSNL+7\/uDcTheeg4pW3\/ruO+39djjYNHaa\/v8ARtLWJbaSwtbkxMcRu+7kNgH7wHJxzT9P1CHQrq2W+Wa5j09Xt4vs6hkRsgytyR8q7lT144FdrpehWGjLILGFkMmNzNIzsQBgDLEnAHQdBUE3hXSLi1treW13RWzFox5jA8nJyc5YE9Qc5quv9f15f5CW1v6\/r+tTWVgyhl5BGRS0gAAAAwBS0gCiiigAooooAKKKKACiiigAooooAKKKKAGSfw\/7wrm\/HTsdNsLfnyLrUIYZxngoW5B9jXSSfw\/7wqHUNPttUs3tbyISQvjIyQQR0II5B9xQBwEWiXGrWerafZiD7JYapIIoZmIiCFBwMA42E5Ax+VXtB1m3tNUje8+0zyXCx2sNxtG1Ix8qlsnOXYE9+1dXbaLY2mmyWEEJW3l3eYN7FnLdSWJySfUnNRv4c0yS7tblrUeZaKqw4ZgoC\/dyucHHbPShO3pp+Vv6+Ynr\/Xnc06KKKBhRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABTP+Ww\/wB00+mf8th\/umgDgfiRrF1Y31jDb3CokavdMhspJfuqcEspxjJH04Jo8MxPB4n0GKQtuXRXB3RNEc+Yucq3Of59e9djqGhafqkpkvYPMcxGEnew+QkEjg+oFGpaHY6s8L3UbiWHPlyxStE6g9QGUg4PpQtP69V+v4A9f69Dyq+tbq+0S2t7G48i6fxNP5Uh\/hYbiP1FWE1o67Y+NLp43inXTY4riJuNkqhww+ma9JTw1paQWUK2oCWU3nwgM2RJz8xOfmPJ65psnhfSZZNSdrNd2pqEuyGYeaAMDvx+FJrS39bWKcry5v63bOIjifRILfxBa6R\/ZFpZaa5uSTGPtbFRsG1Cc\/Nzk4NHw7urbTNYn0qLUYrw39mt87Ryh9s\/\/LVeOnUH8K76+0Sw1LTE0+7g8y0QpiMsQPlwVzg89BTrjR7G6v7W9lt1NzabvJkBIK7hg9OuR61Td2\/67\/q\/wM4qyS\/rp\/XzPJtPW2fR9JtItLNpql5qDfZ9WdUCkrMSRvB3ZwCACOa6LxzY3Fnrra1e6Ymr6KLdY5kV9s1ng5Mic\/njnjqK62TwrpEujLpT2gNmknmqm9sq+7dkNnIOT60X\/hbStSuWnuYJDI6COTZM6CVR0DhSAw+ualXSS\/rYrRt\/11OQubVdZ8fyyW+l2GpxNpUEiLfuVCgscEfI3NL45+xTxaP4avJrXSreZWnnCShI0CD5VUkD+MjsOldbd+FdLvL4XjRzxXHlLDvt7mSH5B0XCMBgVNaeH9Ps777ZHC7XXkiDzZZXkbYDnGWJ702k1b+uoLR3\/rZI4O\/1M+Ifh1oEhWG6m+3wW8qSN8kjq20hjg8HGeh61Dqds2lTeJLaSyg043GimSO2sn3QNtJBcnC4bkD7vTvXdTeEdHmtpoGtWWOa5+1sI5XQ+b\/eBBBB47UR+EtJSO7RoZZvtkXkTPPcSSO0fPyhmYkDnsaWuvn\/AJJfmNWTXl\/nf8ilq\/8AyTC59f7KP\/ouq3gvRzb2lhcvoWkWubVCLmB8ytlR1Hljr35rXh8KaZBbS2wF28EsJgaKW8mkXYRjADMQOPSn6d4asdLlie1e9AiXaiPezOgGMY2sxH6Vd9W+\/wDwSUrQjHt\/wP8AI1qKKKkYUUUUAMT7z\/739BT6Yn3n\/wB7+gp9ABRRRQAUUUUAfKx6V9E+HCg8MaTuAz9jhPTP8Ax3r52PSvobw\/8A8i1pP\/XnF7fwD\/Oa7sX8KOLC7s1UKb1Cj5s4HH\/1\/wA6t4k\/vL\/3z\/8AXqjH\/rU+o7f5\/KtGuE7RmJP7y\/8AfP8A9ejEn95f++f\/AK9PooAZiT+8v\/fP\/wBemRh9pwy\/eP8AD70xZ5RdCNwuDk8AjH496mi+6f8AeP8AOgAxJ\/eX\/vn\/AOvTHD5T5l+96e1TUx\/vJ\/vf0NABiT+8v\/fP\/wBejEn95f8Avn\/69PooAhjD4OGX7x7e9PxJ\/eX\/AL5\/+vRH90\/7x\/nT6AIXD5T5l+96e1PxJ\/eX\/vn\/AOvRJ1T\/AHv6Gn0AMxJ\/eX\/vn\/69MjD4OGX7x7e9TUyPof8AeP8AOgAxJ\/eX\/vn\/AOvRiT+8v\/fP\/wBen0UAMxJ\/eX\/vn\/69GJP7y\/8AfP8A9en0UAMxJ\/eX\/vn\/AOvRiT+8v\/fP\/wBesvxTPJb+HLuSCRo5FC4ZDgj5h3rP1jxZJot7FDLb2vlM0ajzLwLNLuIG5I8HIBPcjoaFq7AdJiT+8v8A3z\/9ejEn95f++f8A69c\/F4mupL1QdOQWZvXsvN8\/59wJAbbtxt49c1BYeObW+1eK1U2hinlaGLy7oNNuGeWjx8oODzk9qFq7A9Dp8Sf3l\/75\/wDr0Yk\/vL\/3z\/8AXp9FADMSf3l\/75\/+vRiT+8v\/AHz\/APXp9FADMSf3l\/75\/wDr0Yk\/vL\/3z\/8AXp9FADMSf3l\/75\/+vRiT+8v\/AHz\/APXp9FADMSf3l\/75\/wDr01w\/lt8y9D\/D\/wDXqWmyf6tvoaAGqJNo+Zen93\/69LiT+8v\/AHz\/APXpV+4PpTqAGYk\/vL\/3z\/8AXoxJ\/eX\/AL5\/+vT6KAGYk\/vL\/wB8\/wD16MSf3l\/75\/8Ar0+igBmJP7y\/98\/\/AF6MSf3l\/wC+f\/r0+igBh3jq6\/8AfP8A9eky3\/PRPy\/+vXG\/Ewymw0+KIt+8mI2qfvHHFcdpvh64uLu4W\/L2lvaLuuJH\/g9APUmvSoYCNSl7WU7fL\/gnBWxkqdX2cYX+Z7JiQ\/xr\/wB8\/wD16MSf3l\/75\/8Ar1zvgGQv4YT52dVmkVC3XaDxXS1w1qfs6jh2OynPngpdxmJP7y\/98\/8A16MSf3l\/75\/+vT6KzLGYk\/vL\/wB8\/wD16MSf3l\/75\/8Ar0+igBmJP7y\/98\/\/AF6MSf3l\/wC+f\/r0+igCGQP8uWX7w7U\/En95f++f\/r1my65aHXYtJRi9ywLtjogAzz71q1UoSjbmW5MZKV7DMSf3l\/75\/wDr0Yk\/vL\/3z\/8AXp9FSUMxJ\/eX\/vn\/AOvRiT+8v\/fP\/wBen0UAMxJ\/eX\/vn\/69GJP7y\/8AfP8A9en0UAMxJ\/eX\/vn\/AOvRh\/76\/wDfP\/16fVfy0luZfMUNgLjIzjrQBJ8\/99fy\/wDr0uJP7y\/98\/8A16je2hEbERICAf4afCSYIyeSVH8qAFxJ\/eX\/AL5\/+vRiT+8v\/fP\/ANen0UAMxJ\/eX\/vn\/wCvRiT+8v8A3z\/9en0UAMxJ\/eX\/AL5\/+vRiT+8v\/fP\/ANen0UAMxJ\/eX\/vn\/wCvTMP5w+Zc7fSpScDJrM0zW7XV766jsyXW1wjPjhifT8qpQk05JaIlySaT6mjiT+8v\/fP\/ANejEn95f++f\/r1ieMWv4tDlmsbv7MIvmkKrl2GRwDn5fc\/yqDVoG1PV7qGS5uoY7SzEsYgnaL5yTydpGcbehyOahu39eVyjosSf3l\/75\/8Ar0Yk\/vL\/AN8\/\/XriPOuNYsLrUJby6hmtbKCWERTMihypZiVHDZOOoIq1eS6nbaumo7bjyWAKkzDymVkwsezP395znHTv2pvR2BanW4k\/vL\/3z\/8AXoxJ\/eX\/AL5\/+vWZ4fv7a6s\/JguZJ5YP9a0qspYnJ3DdyVJzgjjA46VrUAMxJ\/eX\/vn\/AOvRiT+8v\/fP\/wBen0UAMxJ\/eX\/vn\/69GJP7y\/8AfP8A9en0UAMxJ\/eX\/vn\/AOvRiT+8v\/fP\/wBen0UAMxJ\/eX\/vn\/69GJP7y\/8AfP8A9en0UAMxJ\/eX\/vn\/AOvRiT+8v\/fP\/wBen0UAMxJ\/eX\/vn\/69GJP7y\/8AfP8A9en1DdXUNlayXFw4SKMbmY9hTSbdkJu2rHR5y+SCd3b6CpKoaNqUWr2AvbdWWKVjtDdeDj+lX6JRcW4vdBFqSugooopDCiiigD5aMEmD8v619BeHv+Ra0r\/rzh6f7g\/z+teEHoa9d8Oa9cS+HNO8uxidUgSMZuCCdo2jgKepHT+lepiaMppcp52Hqxg3zHWRf61PqO\/+f\/r1o1yq69cRywmSwj2tKibluCxGWALfc6AnH8q6Pz2\/uD868+pSlT+I7oVIz+EnoqDz2\/uD86PPb+4PzrMsVbYLIHLu23O0MeBmnxfdP+8f51H57f3B+dNSZgD8g6nv70AWaY\/3k\/3v6Go\/Pb+4PzprTMSvyDg+tAFmioPPb+4Pzo89v7g\/OgCSP7p\/3j\/On1WSZgD8g6nvTvPb+4PzoAkk6p\/vf0NPqs0zEr8o4PrTvPb+4PzoAnpkfQ\/7x\/nUfnt\/cH501JmAPyjqe9AFmioPPb+4Pzo89v7g\/OgCeioPPb+4Pzo89v7g\/OgDP1Hw7BqN+Ll7i5jDKqzRRsNkwVtyhsgkYPoRVe78I213dXUrXd1HHdOkskKFQpdcYbO3d\/COM49q2PPb+4Pzo89v7g\/OgCkmg2yRKgklIW7a8ySPvkkkdOnJqO08ORWV2skN5dLbI5eO0DKI0Y\/QbiOTwSR7Vo+e39wfnR57f3B+dHW4PUnoqDz2\/uD86PPb+4PzoAnoqDz2\/uD86PPb+4PzoAnoqDz2\/uD86PPb+4PzoAnoqDz2\/uD86PPb+4PzoAnpsn+rb6GovPb+4PzpHmYow2Dp60ATL9wfSnVXWZgo+QdPWl89v7g\/OgCeioPPb+4Pzo89v7g\/OgCeioPPb+4Pzo89v7g\/OgCeioPPb+4Pzo89v7g\/OgDnfHeh32tWNqNPjEkkMhYruCnBHbNc5qGkeMNT06GyubUNHF1IlTMnpuOecV6L57f3B+dHnt\/cH5120cdOlFRUU7bXOSrg41JOTbV97GT4O0u50fw\/HbXihZt7OVBzjJ9a3ag89v7g\/Ojz2\/uD865alR1Jub3Z0U4KEVFdCeioPPb+4Pzo89v7g\/OoLJ6Kg89v7g\/Ojz2\/uD86AJ6Kg89v7g\/Ojz2\/uD86AIZ9NtW1KG\/MQF1H8gkHBIPY+tXarPMx2\/KPvDvTvPb+4PzpuTe4kktieioPPb+4Pzo89v7g\/OkMnoqDz2\/uD86PPb+4PzoAnoqDz2\/uD86PPb+4PzoAnqA7453YRs4YD7pHGPrR57f3B+dHnt\/cH50ADSuykCCTkY5I\/wAakiUpEinqqgVH57f3B+dHnt\/cH50AT0VB57f3B+dHnt\/cH50AT0VB57f3B+dHnt\/cH50AT0VB57f3B+dHnt\/cH50AT1StdNtbG+nmtohG9zhpNvQkd8fjU3nt\/cH503zm8wHaOnrTUmk0uomk3cTUrCPVLCW0mZ1jlGCUODVPVNBGpXInjvruzcxGGT7OU\/eITnB3KfzGDyav+e39wfnR57f3B+dIZlXfhW3uZD5d3d20LxJDNBCyhZUT7oJIJHBIyCK0riwiuZoXl3FYc7Uz8uSMZP4E0\/z2\/uD86PPb+4Pzoeu4FPSNCg0dpWjmmmaRVQGUj5I1ztQYA4GT7+prTqDz2\/uD86PPb+4PzoAnoqDz2\/uD86PPb+4PzoAnoqDz2\/uD86PPb+4PzoAnoqDz2\/uD86PPb+4PzoAnoqDz2\/uD86PPb+4PzoAnoqDz2\/uD86PPb+4PzoAnpskaTRtHIodGGGVhkEVF57f3B+dHnt\/cH50AR6dYwabbG1tU2Qox2rnOM8\/1q3UULFt5Iwd39BUtNtt3YkklZBRRRSGFFFFAHzNXp3hP\/kV7HPTyz14GM89O3qep6CvMa9O8I\/8AIsWOOu09OOcnue+O\/RR7mvdn8J40PiNK46wZ\/wCfmHrxzvXsO+O3RR7muvPU1yE\/\/LDHT7RD04GPMGOvb0HU9TXXnqa87F7R+f6Hfht38hKKKK4zqKS6kH1f7CkRKiNmMueNwx8v61LK7KVVW25ySRVSHQba31OO8hedSgf5DM7KSxBJwTj14q1MDlGAJA3A4GabtpYSuU01i0kufs6anA0+dvliRS2fTFX4XZuGOSrYz+FZMWiWEOryanHakXUi4LbD+YHqa1bcEZJBGX4yPakMkkdlZVUqCcnJ\/wA+9OjcSIG9RyPSo7hCxU84HoM46Hp+FLboUU9cEjGfpigBxYohIGTuwB9TT\/Ln\/uR\/99n\/AAqNlLRkLjIbPPsc1I11KilmhBAH8LZP8qAGBi2NwAIcggH0pSWL7I1BbGTk4ApqggAtgFnLYHvmgTeRM7vG20gKCMY\/nQA5WJyCMMpwRSr0P1NMRzJK77GVXwRux6Yp69D9TQAtFFFABRRRQBm+Ibuax0K5uLZ9kqBdrYBxlgO\/1qG48Rw21w0bWt1JDCUW4uUUGOJmxgHnceozgEDNGq6Lc6jcnZfmO0lVFngaPdna27KHI2k9Dwaju9AuJri4SC+WGwunWSeHydz5GM7XzgA4Gcg96SBkqeI7d77yFt7jyPOMAu\/l8oyD+Hru68Zxj3rXrmbfwZb2urG5jFl5PnGcbrNWnDHnHmk9M+2feump9A6hRRRQAUUUUAFFFFABRRRQAUjfdP0paRvun6UAA6D6UtIOg+lLQAUUUUAFFFFABRRRQA0rvmjQk7TnODipfskX+3\/32f8AGoi2yaNyDtGc4Gal+1xf7f8A3wf8KAIY+N65JCuQM+lPpkfO9sEBnJGfSn0AFFFFABRRRQAUUUUAVJNQtl1GKxMoNzIC4jHUAdz6VbrOfRrX+249VVStyFKNjo4Ixz71o1c+TTl7a+pMebXm\/pBRRRUFBRRRQAUUUUAFNjjWaaQOWwoGMMRTqbHIsM0hcNhgMYUmgCR7WMIxG\/IH98\/41HGS0SE9SoNSPdRlGA35I\/uH\/Co4wViQHqFAoAdRRRQAUUUUAFFFFABVS21G2vbqeK2lEj2+Fk29AT2z+FW6ztN0a10m6upLQFVuSHZOyken51ceTld9+hL5rq23UoeItSNvqFnaLfXtoHjeV2s7fznIBAxjY2Bk9cU7VftK6X9ut9clgghg3KyxIfOb1fI5z0woHWtDULbUJZEfT76K3+Uq6TQeYpB7jBBB\/HHtWXdeG743FkbLUbdLW0T5Le4tjIpkznzDh1yfTPArMsgudW1S31K2luBPDCIo5JIVhzEQVJk3Pg4YHAAyPoa2dGvlvLZg93FPco375EYEwk8hCB0IHHNS3Fk95HbJcSgrGweUKuBIQOO\/AzzjmqekaG+mXUs0lysoKmOILHt2oWLfMcnccnrxT6\/1\/X9fIizRr0UUUFBRRRQAUUUUAFFFFABRRRQAUUUUAFNkkSKNpJGCooyWY4AFOqK5tory2kt7hA8Ug2sp7imrX1E720HaVewahZ\/abV98LsdrYxnHH9Ku1n6Jp0Wk6ctnAzGONm2luvJz\/WtCnPl5ny7dBQ5uVc24UUUVJQUUUUAfL32r\/Y\/WvWvDFlqEXhuwX7BK4aJWVhJGQQfmHBYcYOcevWvHT0r6G8P\/APIs6Vn\/AJ8oev8AuD\/PvXqV60qcdrnm0aSm9zONlqE8kA+wSIBNHIWeSM4AcE\/xdSB1\/DpXVlHz9w\/mKrx\/61Oud3+f8\/hWjXBVrOpa6tY7adJU72ZV2Sf3D+Yo2Sf3D+Yq1RWRqVdkn9w\/mKREfBwh6nuKmSfzJGVUbCkgtxjP506L7p\/3j\/OgCDZJ\/cP5ikZXyvyHr6irdMf7yf739DQBDsf+4fzFGx\/7h\/MVZooAqIr4PyHqe4p2x\/7h\/MVNH90\/7x\/nT6AKjK+V+Q9fUU7Y\/wDcP5ippOqf739DT6AK2x\/7h\/MU1FfB+Q9T3FW6ZH0P+8f50AQ7H\/uH8xRsf+4fzFWaKAK2x\/7h\/MUbH\/uH8xVmigCtsf8AuH8xRsf+4fzFWaKAK2x\/7h\/MUbH\/ALh\/MVZooArbH\/uH8xRsf+4fzFWaKAK2x\/7h\/MUbH\/uH8xVmigCtsf8AuH8xRsf+4fzFWaKAK2x\/7h\/MUbH\/ALh\/MVZooArbH\/uH8xSMr7T8h6eoq1TZP9W30NAFcK+B8h6eopdj\/wBw\/mKnX7g+lOoArbH\/ALh\/MUbH\/uH8xVmigCtsf+4fzFGx\/wC4fzFWaKAK2x\/7h\/MUbH\/uH8xVmigCtsf+4fzFG2T+4fzFWaKAK2x\/7h\/MUbH\/ALh\/MVZooArbH\/uH8xRsf+4fzFWaKAK2x\/7h\/MUbH\/uH8xVmigCtsf8AuH8xRsf+4fzFWaKAKjq\/y\/Ieo7inbH\/uH8xU0n8P+8KfQBW2P\/cP5ijY\/wDcP5irNFAFbY\/9w\/mKNj\/3D+YqzRQBW2P\/AHD+Yo2P\/cP5irNFAFbY\/wDcP5ijY\/8AcP5irNFAFbbJ\/cP5ijY\/9w\/mKs0UAVtj\/wBw\/mKNj\/3D+YqzRQBW2P8A3D+Yo2P\/AHD+YqzRQBW2P\/cP5ijY\/wDcP5irNFAFbY\/9w\/mKbtfzB8hzj1FW6Z\/y2H+6aAIdj\/3D+Yo2P\/cP5irNFAFbY\/8AcP5ijY\/9w\/mKs0UAVtj\/ANw\/mKNj\/wBw\/mKs0UAVtj\/3D+Yo2P8A3D+YqzRQBW2P\/cP5ijY\/9w\/mKs0UAVtj\/wBw\/mKNj\/3D+YqzRQBW2P8A3D+Yo2P\/AHD+YqzRQBW2P\/cP5ijY\/wDcP5irNFAFbY\/9w\/mKNj\/3D+YqzRQBFACA+Rg7un4VLTE+8\/8Avf0FPoAKKKKACiiigD5WPSvobw\/\/AMi1pP8A15xe38A\/zmvnk9K+ifDkZfwxpJHH+hw9if4BXdi\/hRxYXdl+P\/Wp9R2\/z+VaNUUiKup9D2B\/w\/8A11b81fRv++TXCdo+imeavo3\/AHyaPNX0b\/vk0AV1tnF0JNsagEksvVs+tWIvun\/eP86PNX0b\/vk0yOQBTw33j\/CfWgCamP8AeT\/e\/oaPNX0b\/vk0x5ASnDfe\/un0oAmopnmr6N\/3yaPNX0b\/AL5NABH90\/7x\/nT6hjkAB4b7x\/hPrT\/NX0b\/AL5NABJ1T\/e\/oafULyAlOG+9\/dPpT\/NX0b\/vk0APpkfQ\/wC8f50eavo3\/fJpkcgAPDfeP8J9aAJqKZ5q+jf98mjzV9G\/75NAD6KZ5q+jf98mjzV9G\/75NAD6KZ5q+jf98mjzV9G\/75NAD6KZ5q+jf98mjzV9G\/75NAD6KZ5q+jf98mjzV9G\/75NAD6KZ5q+jf98mjzV9G\/75NAD6KZ5q+jf98mjzV9G\/75NAD6KZ5q+jf98mjzV9G\/75NAD6bJ\/q2+hpPNX0b\/vk015AY24bof4TQA9fuD6U6o1kG0cN0\/uml81fRv8Avk0APopnmr6N\/wB8mjzV9G\/75NAD6KZ5q+jf98mjzV9G\/wC+TQA+imeavo3\/AHyaPNX0b\/vk0APopnmr6N\/3yaPNX0b\/AL5NAD6KZ5q+jf8AfJo81fRv++TQA+imeavo3\/fJo81fRv8Avk0APopnmr6N\/wB8mjzV9G\/75NAD6KZ5q+jf98mjzV9G\/wC+TQASfw\/7wp9QySA7eG+8P4TT\/NX0b\/vk0APopnmr6N\/3yaPNX0b\/AL5NAD6KZ5q+jf8AfJo81fRv++TQA+imeavo3\/fJo81fRv8Avk0APopnmr6N\/wB8mjzV9G\/75NAD6KZ5q+jf98mjzV9G\/wC+TQA+imeavo3\/AHyaPNX0b\/vk0APopnmr6N\/3yaPNX0b\/AL5NAD6KZ5q+jf8AfJo81fRv++TQA+mf8th\/umjzV9G\/75NM8wecDhvu\/wB00ATUUzzV9G\/75NHmr6N\/3yaAH0UzzV9G\/wC+TR5q+jf98mgB9FM81fRv++TR5q+jf98mgB9FM81fRv8Avk0eavo3\/fJoAfRTPNX0b\/vk0eavo3\/fJoAfRTPNX0b\/AL5NHmr6N\/3yaAH0UzzV9G\/75NHmr6N\/3yaAH0UzzV9G\/wC+TR5q+jf98mgB9FM81fRv++TR5q+jf98mgAT7z\/739BT6jiOS5Gfvd\/oKkoAKKKKACiiigD5WPSvobw\/\/AMi1pX\/XlB+qgUUV3Yv4UcWF3ZpxczIO2T+h4rQoorhO0KKKKACmR\/dP+8f50UUAPpj\/AHk\/3v6GiigB9FFFADI\/un\/eP86fRRQAyTqn+9\/Q0+iigApkfQ\/7x\/nRRQA+iiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKbJ\/q2+hoooAF+4PpTqKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAZJ\/D\/ALwp9FFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFM\/5bD\/dNFFAD6KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAYn3n\/wB7+gp9FFABRRRQAUUUUAf\/2Q==","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Untitled"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":207,"urlcode":"Sales","name":"Sales"},{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":53246,"type":"discussion","name":"eliminate INVALID DATA TYPE when using a IF statement to display the month","excerpt":"I am using an IF statement to display the month but when I don't have a date the column is displaying #INVALID DATA TYPE. I understand why this is happening but I don't know if I can also incorporate the use of an IFERROR statement nested. What is the correct way to eliminate the #INVALID DATA TYPE? Here is my IF Statement…","categoryID":322,"dateInserted":"2019-07-17T18:28:49+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-07-18T14:21:16+00:00","insertUserID":96586,"insertUser":{"userID":96586,"name":"thunt06","url":"https:\/\/community.smartsheet.com\/profile\/thunt06","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-07\/e8\/af\/ne8af9a4fceb4330f13efee3dc0d73dcc.jpg","dateLastActive":"2020-03-26T05:06:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-20T03:23:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":307,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/53246\/eliminate-invalid-data-type-when-using-a-if-statement-to-display-the-month","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/53246\/eliminate-invalid-data-type-when-using-a-if-statement-to-display-the-month","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":492,"urlcode":"media-entertainment","name":"Media & Entertainment"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":53281,"type":"discussion","name":"Nested IF statement is giving me an UNPARSEABLE error","excerpt":"Hi, I'm using this formula: =IF(COUNTIF([Pilot Status]10:[Pilot Status]12, \"No\") > 0, \"No\",IF(COUNTIF([Pilot Status]10:[Pilot Status]12,\"Hold\")>0,\"Hold\",\"Yes\"))) to show a \"No\" Symbol if there is at least 1 \"No\" in the range, if there are zero \"No\" in the range, then i want it to show a \"Hold\" symbol if there is at least 1…","categoryID":322,"dateInserted":"2019-07-18T10:48:45+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-07-18T14:07:36+00:00","insertUserID":96621,"insertUser":{"userID":96621,"name":"mjandorf","url":"https:\/\/community.smartsheet.com\/profile\/mjandorf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-07\/a2\/fe\/na2fef24355e9d81ca8ee6d446c3e7f80.jpg","dateLastActive":"2019-08-02T14:05:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-20T16:19:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":153,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/53281\/nested-if-statement-is-giving-me-an-unparseable-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/53281\/nested-if-statement-is-giving-me-an-unparseable-error","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":53196,"type":"discussion","name":"Using formulas to copy, or transfer data between cells.","excerpt":"Hello community! I am looking for a seemingly easy solution which I can't find. While the workflow automation helps in many ways, the \"actions\" available seem to be greatly lacking. For example in google sheets + scripts + triggers, I can have a cell update based on a formula from a time driven event (whether external or…","categoryID":322,"dateInserted":"2019-07-17T12:49:57+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-07-18T14:04:40+00:00","insertUserID":96511,"insertUser":{"userID":96511,"name":"austinurbanSeagate","url":"https:\/\/community.smartsheet.com\/profile\/austinurbanSeagate","photoUrl":"https:\/\/lh3.googleusercontent.com\/-oqhJ2fmS8oA\/AAAAAAAAAAI\/AAAAAAAAAAA\/ACHi3rdmcbLZATsCzjJRJCWiaxJ3uSLTDQ\/photo.jpg","dateLastActive":"2020-02-10T16:24:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-20T16:19:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":1465,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/53196\/using-formulas-to-copy-or-transfer-data-between-cells","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/53196\/using-formulas-to-copy-or-transfer-data-between-cells","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":441,"urlcode":"comments-and-conversations","name":"Comments and Conversations"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":53191,"type":"discussion","name":"Formula Training","excerpt":"I'm training a guy to support Smartsheet for our company. He's pretty good with most of the functionality, but he has no experience with formulas. I thought I'd put together a training program for him to help him learn them - starting with basics, then building into nested formulas, etc. I want to give him some samples to…","categoryID":322,"dateInserted":"2019-07-17T12:12:06+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-07-18T11:33:02+00:00","insertUserID":89971,"insertUser":{"userID":89971,"name":"MCorbin","title":"","url":"https:\/\/community.smartsheet.com\/profile\/MCorbin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/80PUK21NFANO\/nKJOX5CKCTKS0.jpeg","dateLastActive":"2023-08-18T15:46:36+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers Alumni"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-20T03:23:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":115,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/53191\/formula-training","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/53191\/formula-training","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":234,"urlcode":"Health-care","name":"Healthcare"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":53031,"type":"discussion","name":"Checkbox condition in a child row, conditional formatting of parent?","excerpt":"I have an uber parent row that is the mother of a group of related tests for software QA. In addition, some of the children of that mother have their own children. I would like any parent row to turn red if any of its children fail a test, as noted by a \"Fail\" checkbox column, and bonus points for conversely turning green…","categoryID":322,"dateInserted":"2019-07-15T16:18:13+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-07-18T10:55:37+00:00","insertUserID":96241,"insertUser":{"userID":96241,"name":"Suzanne Raphael","url":"https:\/\/community.smartsheet.com\/profile\/Suzanne%20Raphael","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T13:24:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-20T03:23:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":16,"countViews":1201,"score":null,"hot":16,"url":"https:\/\/community.smartsheet.com\/discussion\/53031\/checkbox-condition-in-a-child-row-conditional-formatting-of-parent","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/53031\/checkbox-condition-in-a-child-row-conditional-formatting-of-parent","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-07\/ab\/d3\/abd3c33ad7d96d7933fab181b7047d2e.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"failing-children.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":53276,"type":"discussion","name":"How do i get symbols to appear instead of the word representing a symbol?","excerpt":"Hi, I am attempting to write an IF statement with the result being that the \"Pilot Status\" cell will have one of the symbols in it. I have formatted the field to show symbols, and I've written the formula to use the representative words, but i'm still only seeing the word show up in the field. HELP My Formula…","categoryID":322,"dateInserted":"2019-07-18T10:01:58+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-07-18T10:30:33+00:00","insertUserID":96621,"insertUser":{"userID":96621,"name":"mjandorf","url":"https:\/\/community.smartsheet.com\/profile\/mjandorf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-07\/a2\/fe\/na2fef24355e9d81ca8ee6d446c3e7f80.jpg","dateLastActive":"2019-08-02T14:05:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-20T16:19:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":465,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/53276\/how-do-i-get-symbols-to-appear-instead-of-the-word-representing-a-symbol","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/53276\/how-do-i-get-symbols-to-appear-instead-of-the-word-representing-a-symbol","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-07\/b2\/7e\/b27e0c1c7b2e2c76941db28cf1ed549e.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet - Symbols.PNG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":53271,"type":"discussion","name":"How can I get the number of checkboxes checked in a single column ?","excerpt":"Hello, I'm trying to get the number of checkboxes that are checked in a given column (more precisely, A10 - Transcode colum) without using another column to do so (in this case, Valeur A10 - Transcode column which displays ''1'' when a box is checked and ''0'' when it's not the case). As you can see in the screenshots, I…","categoryID":322,"dateInserted":"2019-07-18T09:46:17+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-07-18T10:00:22+00:00","insertUserID":96616,"insertUser":{"userID":96616,"name":"Francis Comtois","url":"https:\/\/community.smartsheet.com\/profile\/Francis%20Comtois","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2pPD_70MWzw!!DitW8PHLWhC","dateLastActive":"2020-03-03T21:57:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-20T03:23:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":86,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/53271\/how-can-i-get-the-number-of-checkboxes-checked-in-a-single-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/53271\/how-can-i-get-the-number-of-checkboxes-checked-in-a-single-column","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-07\/33\/4c\/334c1a92897cf759d75ab3ac28b486d4.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"2019-07-18_09-45-45.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":492,"urlcode":"media-entertainment","name":"Media & Entertainment"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":52931,"type":"discussion","name":"Formulas for an automatically generated Risk Level","excerpt":"Hi I'm am trying to replicate the below formulas in smartsheet so it can automatically calculate the Risk Level with existing controls and with additional mitigation. The below formulas are currently being used in excel: Formula for existing controls Risk Level: =IFERROR(VLOOKUP(H7&I7,LikeliConseq, 2, FALSE),\"//www.santa-greenland.com/community/categories/formulas-and-functions/\") Formula…","categoryID":322,"dateInserted":"2019-07-14T18:38:22+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-07-18T07:44:35+00:00","insertUserID":96061,"insertUser":{"userID":96061,"name":"Ruth","url":"https:\/\/community.smartsheet.com\/profile\/Ruth","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-07-15T20:39:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-20T03:23:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":795,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/52931\/formulas-for-an-automatically-generated-risk-level","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/52931\/formulas-for-an-automatically-generated-risk-level","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-07\/5e\/59\/5e59493bafca29cb44c6cff43ced3388.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Risk Evaluation.PNG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the公式手册模板!
No. In your formula from your post just before my last one, you were adding together 3 different joins. The first one has a different syntax from the 2nd and 3rd. The 2nd and 3rd have the correct syntax already.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":109176,"type":"question","name":"How to check a box if exact text is found within a string of text","excerpt":"Hello, I am trying to place a check in a box when some exact text is found within a string of words. I am looking to place a check when \"TAC\" is found in a string of words. Here's the formula I am using, but its not working. No error message, but is not selecting the checkbox appropriately. =IF(HAS([Column Name1]@row,…","snippet":"Hello, I am trying to place a check in a box when some exact text is found within a string of words. I am looking to place a check when \"TAC\" is found in a string of words. Here's…","categoryID":322,"dateInserted":"2023-08-19T01:53:52+00:00","dateUpdated":null,"dateLastComment":"2023-08-19T17:54:54+00:00","insertUserID":149359,"insertUser":{"userID":149359,"name":"Jen H.","url":"https:\/\/community.smartsheet.com\/profile\/Jen%20H.","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uzlXJ-dimro!oc1UqANVjEQ!GEwnp-NhEjM","dateLastActive":"2023-08-19T18:02:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":149359,"lastUser":{"userID":149359,"name":"Jen H.","url":"https:\/\/community.smartsheet.com\/profile\/Jen%20H.","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uzlXJ-dimro!oc1UqANVjEQ!GEwnp-NhEjM","dateLastActive":"2023-08-19T18:02:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":35,"score":null,"hot":3384878926,"url":"https:\/\/community.smartsheet.com\/discussion\/109176\/how-to-check-a-box-if-exact-text-is-found-within-a-string-of-text","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109176\/how-to-check-a-box-if-exact-text-is-found-within-a-string-of-text","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":109176,"commentID":391532,"name":"Re: How to check a box if exact text is found within a string of text","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/391532#Comment_391532","dateInserted":"2023-08-19T17:54:54+00:00","insertUserID":149359,"insertUser":{"userID":149359,"name":"Jen H.","url":"https:\/\/community.smartsheet.com\/profile\/Jen%20H.","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uzlXJ-dimro!oc1UqANVjEQ!GEwnp-NhEjM","dateLastActive":"2023-08-19T18:02:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-19T17:54:00+00:00","dateAnswered":"2023-08-19T02:33:27+00:00","acceptedAnswers":[{"commentID":391518,"body":"

HAS() will only return true under three conditions.<\/p>

  1. The cell is a multicontact cell and contains a match for the contact<\/li>
  2. The cell is a multiselect dropdown and contains a match<\/li>
  3. The cell is not a multicontact or multiselect dropdown and contains ONLY and EXACTLY the text you are matching against. <\/li><\/ol>

    I am assuming your row in question is a standard Text\/Number cell? If so, you will need to get somewhat creative with some CONTAINS() statements.<\/p>

    This will narrow down your matches to only cells that contain a space both before and after TAC. If, however, TAC can appear as the first or last \"word\" in the cell, it would not match in that circumstance as there would only be a space on one side.<\/p>

    =IF(CONTAINS(\" TAC \", [Column Name1]@row), 1, 0)<\/p>


    <\/p>

    If TAC can appear as the first or last \"word\" in the cell, this will cover those possibilities as well.<\/p>

    =IF(OR(CONTAINS(\" TAC \", [Column Name1]@row), LEFT([Column Name1]@row, 4) = \"TAC \", RIGHT([Column Name1]@row, 4) = \" TAC\"), 1, 0)<\/p>


    <\/p>

    If it is possible that TAC will be the exact entry of the cell, you will need an additional statement to cover that, as there would not be spaces on either side. This will add that option.<\/p>

    =IF(OR(CONTAINS(\" TAC \", [Column Name1]@row), LEFT([Column Name1]@row, 4) = \"TAC \", RIGHT([Column Name1]@row, 4) = \" TAC\", [Column Name1]@row = \"TAC\"), 1, 0)<\/p>


    <\/p>

    If there are other situations you may have in your sheet, i.e., TAC inside parenthesis, or before or after punctuation, etc, you will additional statements to include those options as well.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":109170,"type":"question","name":"COUNTIFS formula with 3 criteria (2 of the criteria have formulas)","excerpt":"Hi - I am trying to create a COUNTIFS formula using three criteria in the same sheet - Status (I just want to count the Open items), Impacted IT Projects (which is another dropdown of project names to select from), and Severity (this column displays a \"High\", \"Medium\", or \"Low\" value based on the calculated score in column…","snippet":"Hi - I am trying to create a COUNTIFS formula using three criteria in the same sheet - Status (I just want to count the Open items), Impacted IT Projects (which is another…","categoryID":322,"dateInserted":"2023-08-18T20:29:26+00:00","dateUpdated":null,"dateLastComment":"2023-08-18T21:13:12+00:00","insertUserID":165367,"insertUser":{"userID":165367,"name":"Shari D","url":"https:\/\/community.smartsheet.com\/profile\/Shari%20D","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-18T21:12:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":163506,"lastUser":{"userID":163506,"name":"JamesB","title":"IT Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/JamesB","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nEQMY42MFGXWS.png","dateLastActive":"2023-08-18T21:34:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":103,"score":null,"hot":3384789758,"url":"https:\/\/community.smartsheet.com\/discussion\/109170\/countifs-formula-with-3-criteria-2-of-the-criteria-have-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109170\/countifs-formula-with-3-criteria-2-of-the-criteria-have-formulas","format":"Rich","lastPost":{"discussionID":109170,"commentID":391505,"name":"Re: COUNTIFS formula with 3 criteria (2 of the criteria have formulas)","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/391505#Comment_391505","dateInserted":"2023-08-18T21:13:12+00:00","insertUserID":163506,"insertUser":{"userID":163506,"name":"JamesB","title":"IT Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/JamesB","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nEQMY42MFGXWS.png","dateLastActive":"2023-08-18T21:34:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-18T21:12:26+00:00","dateAnswered":"2023-08-18T21:01:48+00:00","acceptedAnswers":[{"commentID":391499,"body":"

    @Shari D<\/a> My apologies, should have been HAS<\/p>

    =COUNTIFS(Status:Status, \"Open\", Severity:Severity, \"High\", [Impacted IT Projects]:[Impacted IT Projects], HAS(@cell, \"IT Project Name 1\"))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=322&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

    Trending in Formulas and Functions