Formulas and Functions

=TODAY(-7), \"Recent\", false) I'm working in a quotes sheet that can get very long and I want to create a…","categoryID":322,"dateInserted":"2018-01-26T08:04:06+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-01-29T06:15:43+00:00","insertUserID":25886,"insertUser":{"userID":25886,"name":"Deirdre","url":"https:\/\/community.smartsheet.com\/profile\/Deirdre","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-02T07:30:10+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":25886,"lastUser":{"userID":25886,"name":"Deirdre","url":"https:\/\/community.smartsheet.com\/profile\/Deirdre","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-02T07:30:10+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":233,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/18446\/formula-to-mark-a-row-as-recent","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/18446\/formula-to-mark-a-row-as-recent","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"}],"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":18431,"type":"discussion","name":"sumif with children and checkboxes","excerpt":"I'm trying to create a setup where I sum together only the children if another box for that row is checked. I've come up with (see screenshot below as well): =SUMIF(CHILDREN(Include),1,CHILDREN()) But despite trying different variations of the formula I get everything back as #UNPARSEABLE I appreciate any help you can…","categoryID":322,"dateInserted":"2018-01-25T18:10:05+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-01-29T03:27:56+00:00","insertUserID":35846,"insertUser":{"userID":35846,"name":"dannysteiger2001","url":"https:\/\/community.smartsheet.com\/profile\/dannysteiger2001","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-01\/79\/02\/n7902760856910919c42d6ad24cb3ec5e.png","dateLastActive":"2018-01-26T11:18:18+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-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":550,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/18431\/sumif-with-children-and-checkboxes","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/18431\/sumif-with-children-and-checkboxes","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-01\/5b\/f0\/5bf062e335d50da1c609e25e0646a207.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"smartsheet.JPG"},"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":218,"urlcode":"construction","name":"Construction"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"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":18316,"type":"discussion","name":"Time Formula - Drop Down Selection","excerpt":"Hello, I've searched and it appears the time formula is an ongoing battle for enhancement requests. Looking for some help, I have two columns; 'Start Time:' and 'End Time'. There is a drop-down box on the web form and sheet that starts at 12:00 AM and ends at 11:55 PM, all increments of 5 minutes. For example, 12:00 AM,…","categoryID":322,"dateInserted":"2018-01-24T12:09:45+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-01-26T15:45:55+00:00","insertUserID":34911,"insertUser":{"userID":34911,"name":"Rockee","url":"https:\/\/community.smartsheet.com\/profile\/Rockee","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-01-23T12:52:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":16866,"lastUser":{"userID":16866,"name":"L_123","title":"","url":"https:\/\/community.smartsheet.com\/profile\/L_123","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-22T21:15:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":28,"countViews":2033,"score":null,"hot":28,"url":"https:\/\/community.smartsheet.com\/discussion\/18316\/time-formula-drop-down-selection","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/18316\/time-formula-drop-down-selection","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":246,"urlcode":"mobile","name":"Mobile"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":277,"urlcode":"integrations","name":"Integrations"}],"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":18451,"type":"discussion","name":"Forms","excerpt":"I need data to land in particular areas when entering into a Form... In my sheet I have Hierarchy's...Months, Jan through December. Under those sections I need the orders that are entered into a form to automatically be put under each area according to the date...thoughts??","categoryID":322,"dateInserted":"2018-01-26T08:29:53+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-01-26T12:58:06+00:00","insertUserID":35871,"insertUser":{"userID":35871,"name":"Shane Stanley","url":"https:\/\/community.smartsheet.com\/profile\/Shane%20Stanley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-01\/54\/67\/n546781be2775c6af6f1ae51b75451e09.png","dateLastActive":"2022-03-16T12:07:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":11072,"lastUser":{"userID":11072,"name":"Mike Wilday","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Wilday","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/749H48MC3045\/nF9FQYPTX0X7D.jpg","dateLastActive":"2023-08-23T14:56:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":573,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/18451\/forms","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/18451\/forms","format":"Html","groupID":null,"statusID":0,"image":{"url":"denied:data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAaQAAAFYCAIAAACTfh8AAAAgAElEQVR4nO2d21Nb173H9e+cJ43\/gzxmpjO9zPSklj1x+5C20ybuY07vukAgOG3ThqatoVPbo14eak8sNx2f2PU4PcHI5AIIgg2iDiC0uWojIHV94aLzsLa21r4sIQT+8pP4fmYNlraWltB38\/t6LbZY38hrYfT29l66dCn0oVC+973viepPmoM6Y6DOGHw6R0I70eyOJ9QZA3XG4De7zjCU2YU+FIoaVE5\/0hzUGQN1xuDTmWZHalBnDNQZQ8DsOjqCrbe399LFi6EPhbbvnT0rqj9bc406U+d2aj6dIx1h9Pb2Xrx4UT\/S2dn51ltvXbhwIbT\/2bNnff3r86z7k+agzhioMwafzpGOVCrYHLNLpTpSqc6Ojtc6O\/\/yl7\/MzsxMTEx89NFH3V1dvv7OoGFDhTZT\/57XX\/\/nP\/85Pjb2enf3QcZna65RZ+rcTs2ncyQVhjI7dbujo+P1118fHx9Pp9NvvPFGLpf705\/+pI67\/dWg6mB\/f\/\/s7GyxWCwWi5ZlWZalbj948ODSpUuqj9vfR09PTy6XKxaLPT09+vHw\/v137YqDfbe\/evTadMVl+lrwmHtUe7q39\/HFcF50peqJdG1aOw\/16b9ra0Ndm96\/+P137ZY9YSE6e38a67yza3f30rjhH+y9h6rLPk73EeHTeW+zS6VSPT09ExMTv\/nNb86dOzcwMHDlyhU1LQwO2tnZee3atd0wHj16dOvWLdXHZHYdHR09PT2\/+MUv6n\/TqZRzRnXbmr6WUq7mngHv4eoZ779rqy7uDVIl7Lzo2vnvpfxd92N2tm1r\/xnR7GyPyiYlG9C4\/67d0Hk4qFm1oNklk8HmmF0ymUomO1Kp17u7x8bGrr7zzj9u3vzn++9fv379\/du3X+\/udvs7gyaTnR0dV69e3dnZ2d7edm1uZ2dna2vrP\/\/5z40bN9SAbn+9db322t+uXfvss88u\/\/WvqltwfLf1Z+2Kne33jtCftSuV\/LXakcx0pWJn+1OZvHa8\/65dsbP9qf6sXbHv9oe8\/WPbQs5LJm9n+30i29n+\/qxt247a1\/JqApGfzjt6Vo9U1HP1zs44\/Vk7n+nP2tMZp\/90xjmoOlxTQ\/Vn7Xx+ujqUM6w679pDldqz9npdGS1EZ+29uyLr70i9R+eufrv6Zj1DBUojVdXCFbDOUGEnt\/YqwdMttvl0jiTDUGanbqdSqe7u7lwu9+677w4NDd2+ffvGjRvDw8Pd3d1ufzVoMpns6Oi4evWqMjh3Fq3uPnr06MaNG2pAt79LKpXq7Oy8cuXKv\/\/9776+PnUkOL5LJu+cMx3XAf0HMvlKJZ\/RDlbyGfWvRmC440dQ5\/6s7QrnkMkrs3MUzeSr0mbySsPaEefptc7+cZ2uzj\/ai2XydrY\/mfS8jPcFtUG9o9R9XRkEdfYLrd5\/7WDVwKrCBN+sZyjPD3Y+ow\/QwFBhJ9d3xpK10y0Yn86RZCIRbI7ZJRLJRCKVTHZ3deVyuXf\/9rcPPvjg5s2bN957T12mcPs7gyYSHanUO++8s729vbW1tVNld3d3e3tbzezUgG5\/t6lXGRoaWl1d7UilfN9PsL9jY95ujo3VjihL7HMqxTnYl7UrdrYv6fwb8vaPbQvqnMzk7WyfT2Q726e+qrv5jPNQJm9n+xK+WtM711pf1s5n1PiVfCaTr+Qz2sHqUNqRvqztnEG3c94dM5NXr7L368poITpr711XVXtT6mc1k7ez\/YkQkT1DBUojRFvzUPrJDT7kO91HLmbjOkcSYSizc+92dXXlcrlr166Nj48PDw9fv379448\/7u7udjuoQROJRCqVeueddypelNk9fvz45s2bqo\/bX6enp8eyrA8\/\/LCjoyOZTOoPhfTvqxqb53YmX3GP+g7rR+1sn3aDVAk7L7p2tXt9WdvRTnlPIlE7popAo9ZZP1QdNJOvVEIGrZ6j2uDOLecFtUGdI428rgzCf549Kvveonuz+iYDb9YzVPAxj+B7DKWfB\/9IwdMtGJ\/OkUQ8HmyO2VXvdnd1TUxMnP\/d7z744INPPv74rbfe+vTTTzs7OtwOzqDxeDKR+OWbb965c2doaGhoaOijDz+cvH+\/Uqk8evTog\/\/7v7d\/\/Wtff7clE4m3f\/3rp0+fjo6Onv\/d75KJhP5osH8iHk+cH6z9rzd4vnr8ar5ms\/mMOqgfq1TyV\/1PDwxyTFu4zvHz2ZJf0r7BkitXxlG3ZJdK2fP6EUdtvXPt3OWv6qcsf1V\/oXw+X8qe17udz5acl87kK\/mr8cT5QbtUsquv4f1OzK8ro4Xo7P1pDPyIlvL5Uv6qo1WlNNgXeLOmoZwfbE3wjNLWPFTYya29SvB0i20+nfc2u2Qi8Vpn5+3bt+\/cuZNMJLq7ut57772hoSHToMlEQv+oS3dX15XLl3O5nFqcGk92PP6zN94YHh7+3+vXO1KpvX842J5Bo87UuZ2a3+ziYSizc+8mEomenp7h4eGpqal79+7lcrlz587p\/dWg7l39d4SJRCKZTHZ2dqZSKVN\/91XUx1mC309of3LoUGcM1BmDT+dI\/Kc\/Dbbe3t6LFy74DnakUufPn+\/r60smEr6Hzr7ySrC\/2xLxeIP9lQEHj9cfn+2wGnWmzu3UfDpHfhpGb2\/vhQsXQh8K5ZVXXhHVnzQHdcZAnTH4dI789Cc\/CTbH7MIeCm3OoGL6szXXqDN1bqfm05lmx0adqXN7Nr\/Z\/eTHPw42ZXahD4U2Naic\/mzNNepMndup+XSm2bFRZ+rcns1vdj\/+0Y+CTZld6EOhTQ0qpz9bc406U+d2aj6daXZs1Jk6t2fzm92PwlBmF\/pQKGpQOf1Jc1BnDNQZg0\/nyI9++MNgc8wu7KHQ5gwqpj9bc406U+d2aj6daXZs1Jk6t2fzm90Pf\/CDYOvt7b3whz+EPhTaXnn5ZVH92Zpr1Jk6t1Pz6RzpDePNN98MPU4IIS1KZCWM0eHh0OMmstmsqP6kOagzBuqMwaczzY7UoM4YqDMGmh0xQp0xUGcMNDtihDpjoM4YaHbECHXGQJ0x0OyIEeqMgTpjoNkRI9QZA3XGQLMjRqgzBuqMgWZHjFBnDNQZA82OGKHOGKgzBpodMUKdMVBnDH6z+ySMyXv3Qo+byGazovqT5qDOGKgzBp\/OkQohhBwDIpthlEql0OMmpPUnzUGdMVBnDD6daXakBnXGQJ0x0OyIEeqMgTpjoNkRI9QZA3XG0LzZbWxsNDjofr+JpvtPT0+PjY2Njo6OjIy4X3O5XKFQ2Nf4RMEixECdMSBmduvr6+vr6+Vyed3LxsaGcsxDMbvZ2dl79+6VSqXV1dVSqaRurK6urq2tDQ4OrqysaH1Huk5EHM5cdo5dPuM7UD1aO1B7mrfT5kjXiRNdI\/t6D\/7n+4eUAIsQA3XG4De7TzUmJiYmJyeDnTY3N8vlsmVZS0tLq6ur9Qe1bXtlZWVpaWkxwMrKyuLi4vr6enD89fX1hYUFy7IWFxeDU8jQH47JyUnLstbW1vSXWFpasm17fHxcn9xp1uLevHwmcqJrxGc7yv+qd2uOFvAmmh05ANQZg9\/srCqLi4vLy8t3794Ndtrc3CwWi8vLy+vr64VCoVwumwbd2NhYWVnZ2tp6GsaTJ0\/K5bJt277xNzY21DegLG9xcbH+N62YmpoqFArLy8tra2sbGxvlcnljY2NtbW15eXlsbGx+fj70\/Ts25TEydWuk68SZy\/rMLqSPbxT\/yGoW6D4SnBg6R06cOeOYXa3LgczzkGARYqDOGPxmpxaAalq0urpqMrv5+Xk14SoWi7ZtmwZVZrezs1OpVHZ3d30f6tvZ2SlV0Z++vr7ujl8ul4vFYv1vWjE1NTU3N2dZ1ttvv93T0\/Ozn\/2sq6srnU6vrq6Ojo4azK7qZZqneRauvntVcwoxNt+x2lxNmzM6fapjun1Guk4oA6y9mvd1jwgWIQbqjMFvdiMjI8PDww8ePFBrwGw2G+y0ubk5Pz+vZmQLCwurq6ve34j5zW57e1uZnY\/t7W3392v6031m5942fdOKycnJQqEwOzv79a9\/\/Utf+tJXv\/rVL3zhC6+++urq6urIyEiY2VVtaLMxs6t1b2AZGzqgd96mP8np43Y4eqPb3GQRoqDOGPxm981vfvPb3\/728PDw0tLSwsLC4OBgsNPm5qZlWcvLy2qNuby87LOSps1O9S+VSjMzM7Ozs3Nzc+prqVTS\/dQ0s5udnV1YWHjw4MH09PT09HQ+n5+ZmbEsa3R01D89HOk6oU\/QjEtUj1PVHvBNvBoxu8tnIt65XojZ1b43EY7HIsRAnTH4ze6LX\/zixYsXi8VioVBYWFgwzezU7+yUIa6srPispMFlrM\/s1MXZxcXFhw8ffvbZZ5ZlLSwsFIvFubm5hw8fLi0tbVY\/72Ka2all7Ozs7Pz8\/Pz8fKFQKBQKxWIxl8t57DjkekDoBYpNw8xOv1kdcM9lrDvS5TMR\/2s5Rqi\/uP8ljgIWIQbqjMFvdr\/61a\/m5ubm5uYKhYJlWfXNTv1qb3l5uY7ZLS8vm\/4Qd2dnR12K9ZmdbdufaczOztq2vafZTU9Pz1UpFAru12KxODo6almW27P6IRPvpYAGPnpSe2Lwoyf6iN5rDZp9qftn3Dletc+JE7rtiblCwSLEQJ0x+M1O\/ZpfrSKLxWKd39mtra2pqdPa2pppGatur62tqXWoy+bm5uPHj1dXV5eWlsrlcqjZPagyMzPTiNnZtv3RRx\/dvXt3cHDwTpXBwcGhoaFcLre+vn4oeh0rWIQYqDMGv9mp2ZA7s7tz506w02b1AoX6bLBt23XMTn3+Y21tzdZYXV19+PDh4uKi+piIbnZLS0uPHz8uFotLS0vq03kLCwuPHj3a0+wUa1Vs23Zf9KAiHVdYhBioMwa\/2Y1rTExMDA8PBzttbm7atl0oFNQKtFAo+Awl+Lk5H+VyWf3KTz2qL3vVb\/HUb9zUV\/XpFv3Ty\/zhwECdMVBnDM3\/udja2pqafK2trTXS38X9TIn7aeRgf5857mt8clhQZwzUGQPib2OPvD9pDuqMgTpjoNkRI9QZA3XGQLMjRqgzBuqMgWZHjFBnDNQZQ8jfxgb517\/+FXrcxLPu\/19f+R82TNvXeSHNsd+ff9IcPp3DoxTL5fK+Msqedf8jt4Dj0yzy7FlZWTnqb+FY4NO5lczuqCQ7PlBkDDQ7DDQ7YoQiY6DZYaDZESMUGQPNDoNQs1Mb3u3s7KgbvkcPYnZTU1Pj4+O5XG5UY2xsTG0qRXRodhhodhiEmt3W1tbk5OT169dnZmYO0ezy+fzQ0JBlWfPz88VicWFhQe18t7CwcOfOndnZWf8TBuLRaHygWXFbHZodBpodBnFmt7u7+\/Tp03\/84x\/JZPLPf\/5zZ2fn0NBQxbv3Z9Nml8vlLMsql8tqJ775+Xm1H9\/a2trExMTU1JT\/CTQ78uyh2WEQZ3ZqR8\/Ozs6FhYXt7e3Jyclz585tbW2p7Y4PbnZqB+ZHjx7dvHnzy1\/+8v379z\/\/\/PPFxcXx8XEVxuhBM7uBeNTZVjOWdu7HYjHfEaez55b\/WdFYLBqJRGKxWKRmpOmY00ESNDsMNDsM4sxud3f3888\/\/\/nPf76zs7Ozs1Mul3\/5y1+qX94ditmpvYtv3LjR1dX1\/PPP\/\/a3v33\/\/fdV3GI9s6vZV9WWBuJRx5+0Iz6zC3+Wbp+uBQr0OpodCJodBkFmp65IzMzM\/P3vf3\/11Vdv3Lhx69atTCbz\/e9\/\/\/bt25ZlVaqL2abNbnR0tFAozMzMfOUrX3n++edPnz793HPPffe73y2VSiMjI\/VndtokzWdkQWsLnRD6+lg1j5O6WKbZYaDZYRBkdtvb20+ePPn973\/\/jW9844UXXjh16tTp06djsdgLL7zwne9858qVK6rPQcwul8vNzs4WCoXx8fG33377ueeeu3LlysTEhMqpqPc7u3QsUpvH7Wl21T71nmU5h2NpqV5HswNBs8MgzuwuXbr04osvnjx58mtf+5r6GovFvvWtb2UymUM0u1KpdOvWrZdffvnTTz9dXl4uFAq5XE43O2fZqZud61p1zM63Vq33LPd1otGowCWsZdHsUNDsMIgzu4sXL54+ffrkyZP\/XeXkyZMvvfTSoZjd2NiYHre4tLSkAjfUQ\/l8vtY17bn2oN2PObO1sEWr0ykai2kTQsOzHIT+us6yLJodCpodBkFmt7W1pczuxRdfPHXq1NeqnDp1Ss3sdnd3t7a2DmJ2MzMzg4ODuVxueHh4eHj4k08+GRkZGR4eHhsby2azKmMIi9glrGXR7FDQ7DAIMrudnZ0nT5788Y9\/fOmll86cOfP1KmfOnDl79uy7776r+hzE7CzLmpuby+fzU1NT+tepqan5+fnD0HM\/qGmf1GmdRbNDQbPDIMjsKpXK7u5uqVS6f\/\/+\/fv371W5f\/9+Pp9fX193+\/NvYzFQZAw0OwyyzK5BaHYYKDIGmh0Gmh0xQpEx0Oww0OyIEYqMgWaHgWZHjLAIMVBnDDQ7Eg5jKGDQ7DD4zW4sjAcPHoQeN\/Gs+x95DE3bt48\/\/li\/TZ4p09PTR\/0tHAt8OrfGzK5cLh\/Vfw7HB87sYHBmh6Ell7E0OwwsQgzUGQPNjhhhEWKgzhhodsQIixADdcYg1Ozqp4sdxOyYLtY4LEIM1BmDULOrny7WtNntI12stsOwu8twANFblhwCLEIM1BmDOLNrJF2sabPbR7pYI0ZGsyOHAXXGIM7sGkkXO4jZNZouFmpk1b04A1FhIeFh6bDdPVsrbIxFiIE6YxBndo2kix3E7BpNF9OXsf6AMW3T9og3aswXHtbiYWMsQgzUGYMgs2s8Xaxps9tHulhwZudO61wD1EzJ6e5LI2vxsDEWIQbqjEGQ2TWeLnaQmV2j6WKhZuebbjVqdq0aNsYixECdMYgzu0bSxQ5udnumi4WYXW3JqS9aA8tYT85sa4eNsQgxUGcM4syukXSxps1urPF0seYvUNSe1ephYyxCDNQZgyCzazxdrGmzk5cu5kPOEtayWIQoqDMGQWbXeLrYQf6CQlC6mA95YWMsQgzUGYMgs6s0nC7Gv43FwCLEQJ0xyDK7xvsflV7HChYhBuqMgWZHjLAIMVBnDDQ7YoRFiIE6Y6DZESMsQgzUGQPNjhhhEWKgzhhaMl3swYMHRxVQdKxg6hUG6oyB6WLECGccGKgzBi5jiREWIQbqjIFmR4ywCDFQZww0O2KERYiBOmMQanZMF5MAixADdcYg1OyEpIu5f5XvvbcfZO1jsj9YhBioMwZxZicpXczdRtNzZ3\/Q7MheUGcM4sxOVLpYPF7dVz0Wj2vOZ0oISwcfDm7w2TqwCDFQZwzizE5Qulg0no7H1Hbq0XjaMbv6CWFuuIS753DtURnxiPuBRYiBOmMQZHYS08XSsVjaGojH4gMD7syuXkJYaHJFMGOsRWARYqDOGASZnch0MXcBWzW7+glhNDuyf6gzBnFmJyxdbCAeU1cmNLOrlxBWW8Y6N2l2ZC+oMwZxZictXUz7t2Zy9RLCQi5Q0OxIPagzBkFmx3QxabAIMVBnDILM7rini8mDRYiBOmMQZHYVposJg0WIgTpjkGV2jfc\/Kr2OFSxCDNQZA82OGGERYqDOGGh2xAiLEAN1xkCzI0ZYhBioMwaaHTHCIsRAnTEwXYwYYeoVBuqMgelixAhnHBioMwYuY4kRFiEG6oyBZkeMsAgxUGcMNDtihEWIgTpjEGp2TBeTAIsQA3XGINTsjj5drIq2QV0DqG2cWm8zp3BYhBioMwZxZiclXUwxEI9qUTuNQrMj+4E6YxBndlLSxSzLqm5LPKC7XTAtTE8X48yO7B\/qjEGc2UlJF7MsT36YnjLhrGud+DBPuhjNjuwf6oxBkNnJShfzWlwtBlE76sZU+AN3aHZkP1BnDILMTla6mJs14eLO52h25FChzhjEmZ2UdDF\/pLUWvBNcxtLsyAGgzhjEmZ2MdLGBkCuw7tWKkAsUNDvSPNQZgyCza410sXYxskZgEWKgzhgEmV1rpIvR7MhhQ50xCDK7CtPFhMEixECdMcgyu8b7H5VexwoWIQbqjIFmR4ywCDFQZww0O2KERYiBOmOg2REjLEIM1BkDzY4YYRFioM4YmC5GjDD1CgN1xsB0MWKEMw4M1BkDl7HECIsQA3XGQLMjRliEGKgzBpodMcIixECdMQg1O6aLSYBFiIE6YxBqdkefLjYQj0ZqO9p57x0XWIQYqDMGcWYnJV1sIB6NRqPaXuzR\/WaMtT4sQgzUGYM4s5OSLjYQj0bj8bjazSkd0wIVB+JRZ6P2WNryBcv69zdubViEGKgzBnFmJyVdbCAejcbT8Vh8wLLSsWg87ZhdbT87LXustmdxO3kdixAEdcYgyOxkpYspU0vHYmlrIB6LD2gbtdemduYwiraARYiBOmMQZHay0sUc53IXsFWzS8eqVyq09Ws65gZkN\/eNyYRFiIE6YxBndlLSxdycxJi6MqGZnet1ET1Xtg2vYLAIMVBnDOLMTka6mCc6sfpvzeQikUgkFov5PpvSbl7HIgRBnTEIMrvWSBcLp\/2WsJbFIkRBnTEIMrvWSBcLoqZ6bTets1iEKKgzBkFmV2G6mDBYhBioMwZZZtd4\/6PS61jBIsRAnTHQ7IgRFiEG6oyBZkeMsAgxUGcMNDtihEWIgTpjoNkRIyxCDNQZA9PFiBGmXmGgzhiYLkaMcMaBgTpj4DKWGGERYqDOGGh2xAiLEAN1xkCzI0ZYhBioMwahZsd0MQmwCDFQZwxCze7o08UU7bmbSaOwCDFQZwzizE5KupiCZkeePdQZgzizk5IupnDNruZ6+m6esZgWM2ZZtZ0922PHJxYhBuqMQZzZSUkXU9Q3u9oG7b7gsTaJVGQRYqDOGASZnax0MUV9s\/Mdcad1WvJYS8MixECdMQgyO1npYooQs6uGioWaXRtM5zRYhBioMwZxZickXcwxLt3sapHYBrNzH2qX+B0WIQbqjEGc2UlJF0sbrj1EYzHTMtbiBQrSDNQZgyCza+V0sfaERYiBOmMQZHatmi7WvrAIMVBnDILMrsJ0MWGwCDFQZwyyzK7x\/kel17GCRYiBOmOg2REjLEIM1BkDzY4YYRFioM4YaHbECIsQA3XGQLMjRliEGKgzBqaLESNMvcJAnTEwXYwY4YwDA3XGwGUsMcIixECdMdDsiBEWIQbqjIFmR4ywCDFQZwxCzY7pYhJgEWKgzhiEml0LpIsdgyweFiEG6oxBnNm1TLoYzY4cEtQZgziza6V0sWg8HtOyJrgtO2kK6oxBnNm1UrpYND5Q24C9TbZi12ERYqDOGASZXWumi1U9rh1XtSxCDNQZgyCza9V0sXQsEku3o9exCEFQZwzizK4F08XSsUg0Gm2zJaxlsQhRUGcM4syuBdPF2vHXdZZlsQhRUGcMgsyuZdPF2nIJa1ksQhTUGYMgs2vJdDE132vHaZ3FIkRBnTEIMrsK08WEwSLEQJ0xyDK7xvsflV7HChYhBuqMgWZHjLAIMVBnDDQ7YoRFiIE6Y6DZESMsQgzUGQPNjhhhEWKgzhiYLkaMMPUKA3XGwHQxYoQzDgzUGQOXscQIixADdcZAsyNGWIQYqDMGmh0xwiLEQJ0xCDU7potJgEWIgTpjEGp2UtLFant1HjrpmPitUliEGKgzBnFmJy5dLBaPP4uNOVthXygWIQbqjEGc2YlKF1P7FQ\/obhcMo7DcjT2rvhjSZyAeVZuButsc1+6IhUWIgTpjEGd2ktLFqtmI+iwsxMjclW46FomEm10tZTFsTKmwCDFQZwyCzE5auphuRzWzMsaMad1C+\/h2eafZkSrUGYMgsxOWLlYNoXDZM2YsxOy8lzeqltcq0YssQgzUGYM4sxOSLqbN5RT6HM0bMxa6jPX20RN5nN40O1KFOmMQZ3Yy0sUGQq7AVu3PHzNWOxSLVR0y2Kc2UdQPyPY7FiEG6oxBkNm1bLqYSyvM1vYDixADdcYgyOxaMl3MskImbe0CixADdcYgyOwqTBcTBosQA3XGIMvsGu9\/VHodK1iEGKgzBpodMcIixECdMdDsiBEWIQbqjIFmR4ywCDFQZww0O2KERYiBOmNguhgxwtQrDNQZA9PFiBHOODBQZwxcxhIjLEIM1BkDzY4YYRFioM4YaHbECIsQA3XGINTsmC4mARYhBuqMQajZiUgX07bv3E\/izv5jw6TulsIixECdMYgzOynpYvp+m7V9OhugCeei2R1vqDMGcWYnJV3MZEDudE854UA8Go3FPLuta5s9mTtH4+l4tNrRP0j9F3oGuY4GWIQYqDMGcWYnJ12s6jaauYTGTdTCKbzhEnU66zei8YGBeDRS28fdl1AReCEcLEIM1BmDILOTli5WRZmeviO7tlWn5krOTT1h0dTZd0NbMjuP1H0hGCxCDNQZgyCzE5Yu5qHmQb5FZH2zM3VuxOzMLwSDRYiBOmMQZ3aC0sU8Ia\/mRWudZeyeK9w6y1jTc4GwCDFQZwzizE5GuphlacHWnnCJPS5QWJ7YsJDOBrNr6AIFza49oc4YBJldS6aLSf3UyKHAIsRAnTEIMruWTBej2ZEDQ50xCDK7CtPFhMEixECdMcgyu8b7H5VexwoWIQbqjIFmR4ywCDFQZww0O2KERYiBOmOg2REjLEIM1BkDzY4YYRFioM4YmC5GjDD1CgN1xsB0MWKEMw4M1BkDl7HECIsQA3XGQLMjRliEGKgzBpodMcIixECdMQg1O6aLSYBFiIE6YxBqdiLSxfRNnuoFP5jjxFp8mwAWIQbqjEGc2UlJF\/OGPni28vRRx9FodqQBqDMGcWYnNV1M2yi9NuGLpb1xYu4jzlOlxoY1CIsQA3XGIM7spKSL+VMg9GiJmpU5dufdQb3WR2psWIOwCDFQZwyCzE5WupjJ7IIr07CEHc3IJMaGNQiLEAN1xiDI7GSli5mWsQc3OwGxYQ3CIpGc6VoAAAQ4SURBVMRAnTGIMzsp6WLGCxS1Zaxzc7\/LWAGxYQ3CIsRAnTGIMzs56WLGj554LlBYepyY+4g2nZMYG9YgLEIM1BmDILNryXSxtoZFiIE6YxBkdi2ZLtbWsAgxUGcMgsyuwnQxYbAIMVBnDLLMrvH+R6XXsYJFiIE6Y6DZESMsQgzUGQPNjhhhEWKgzhhodsQIixADdcZAsyNGWIQYqDMGposRI0y9wkCdMTBdjBjhjAMDdcbAZSwxwiLEQJ0x0OyIERYhBuqMgWZHjLAIMVBnDELNjuliEmARYqDOGISa3dOnT+\/fv3+U6WKe7eyezTZMgjd3UrAIMVBnDOLMTkq6mNqazrvN8CFDsyOWZVFnFOLMTlS6WDzm7iqshexo+WG6X9VuG\/PDItF4Oh7V0ydEZ4+xCDFQZwzizE5KupiyroF4VN86PXTjdS020ZfI488P02+owWVnj7EIMVBnDILMTla6WNV30jEtZiIYqeN0sCzHFq16+WG+G+Kzx1iEGKgzBkFmJzRdbCAejcXrmJ265bvredV9mZ2k7DEWIQbqjEGc2UlJF\/OuKLVAHe8yVt2OxmLRqkvVyQ8LMTvR2WMsQgzUGYM4s5OSLua79FC1Nn9+mGVZnqBF935YfljQ7GRnj7EIMVBnDILMjuli0mARYqDOGASZHdPFpMEixECdMQgyuwrTxYTBIsRAnTHIMrvG+x+VXscKFiEG6oyBZkeMsAgxUGcMNDtihEWIgTpjoNkRIyxCDNQZA82OGGERYqDOGJguRoww9QoDdcbAdDFihDMODNQZA5exxAiLEAN1xkCzI0ZYhBioMwaaHTHCIsRAnTEINTumi0mARYiBOmMQanZbW1uTk5NHmS7m2TT42eyyxMAdYlkWdUYhzuykpIvpmwZrWwofJjQ7YlkWdUYhzuykpIt5d0j37Lru273T3c9T37Kd6WKkYagzBnFmJyVdzGt2ziQsmP6l7c\/uzP+YLkb2CXXGIMjsZKWLhZpdI+lfTBcj+4Q6YxBkdrLSxUKXsY2kfzFdjOwT6oxBnNlJSRcLvUARTP\/SY8bUTaaLkX1CnTGIMzsp6WKmj540eYGC6WLECHXGIMjsmC4mDRYhBuqMQZDZMV1MGixCDNQZgyCzqzBdTBgsQgzUGYMss2u8\/1HpdaxgEWKgzhhodsQIixADdcZAsyNGWIQYqDMGmh0xwiLEQJ0x0OyIERYhBuqMgelixAhTrzBQZwytmi62r\/6kOagzBuqMwaczzY7UoM4YqDMGmh0xQp0xUGcMNDtihDpjoM4YaHbECHXGQJ0x0OyIEeqMgTpjoNkRI9QZA3XGQLMjRqgzBuqMgWZHjFBnDNQZA82OGKHOGKgzBpodMUKdMVBnDDQ7YoQ6Y6DOGGh2xAh1xkCdMdDsiBHqjIE6Y6DZESPUGQN1xkCzI0aoMwbqjMGn8\/8DSmUp5nwXKwQAAAAASUVORK5CYIIA","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":204,"urlcode":"forms","name":"Forms"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}],"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":18411,"type":"discussion","name":"Formula to auto fill date based on last non blank","excerpt":"I figured out the formula to give me exactly what I need in Excel: =IF(LOOKUP(2,1\/(A1:D1<>\"//www.santa-greenland.com/community/categories/formulas-and-functions/\"),A1:D1),EOMONTH(LOOKUP(2,1\/(A1:D1<>\"//www.santa-greenland.com/community/categories/formulas-and-functions/\"),A1:D1),3)) This formula does not translate to smartsheet. I need a formula that finds the last non blank in the row and auto fills a due date of 3 months later, last day of the month. ","categoryID":322,"dateInserted":"2018-01-25T15:42:49+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-01-26T09:11:39+00:00","insertUserID":35786,"insertUser":{"userID":35786,"name":"Jeeppler","url":"https:\/\/community.smartsheet.com\/profile\/Jeeppler","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-01-29T08:50:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":16866,"lastUser":{"userID":16866,"name":"L_123","title":"","url":"https:\/\/community.smartsheet.com\/profile\/L_123","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-22T21:15:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":319,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/18411\/formula-to-auto-fill-date-based-on-last-non-blank","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/18411\/formula-to-auto-fill-date-based-on-last-non-blank","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":18441,"type":"discussion","name":"Conditional sum formula","excerpt":"Please be gentle, very novice smartsheet user! I am trying to get a total value on a smart sheet when certain conditions are met. I have a column called Type and a column called value, so when cell entries in column type are a particular value, I want a sum of the values recorded against that type in column value. And I…","categoryID":322,"dateInserted":"2018-01-26T06:40:37+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-01-26T08:49:08+00:00","insertUserID":19846,"insertUser":{"userID":19846,"name":"Ian Smith 2017","url":"https:\/\/community.smartsheet.com\/profile\/Ian%20Smith%202017","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-15T15:10:36+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-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":774,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/18441\/conditional-sum-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/18441\/conditional-sum-formula","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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

Help Article Resources