Formulas

1, TODAY() - Finish@row > 1), \"Red\"), IF(AND ([% Complete]@row <= .75, TODAY() - Finish@row =< -5), \"Yellow\"), IF(AND [%…","categoryID":322,"dateInserted":"2019-03-07T12:53:08+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-03-08T16:14:41+00:00","insertUserID":81056,"insertUser":{"userID":81056,"name":"tania.cubell81056","url":"https:\/\/community.smartsheet.com\/profile\/tania.cubell81056","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-06-11T18:50:21+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":24,"countViews":235,"score":null,"hot":24,"url":"https:\/\/community.smartsheet.com\/discussion\/43181\/status-update-auto-update-the-icon-with-a-rule","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/43181\/status-update-auto-update-the-icon-with-a-rule","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":43206,"type":"discussion","name":"Need your advise on Nested if","excerpt":"Hi All: Need your advice on the following problem. I have three columns [RUN\/INVEST], [MUPOR] and [CHECK] in my sheet. I also have two separate data sheets SHEET1 and SHEET2. And I want to write an if else formula as below for [CHECK] column values if ([RUN\/INVEST]1 = \"Invest\") then {Look for [MUPOR]1 value in column1 of…","categoryID":322,"dateInserted":"2019-03-07T19:52:19+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-03-08T08:11:33+00:00","insertUserID":64466,"insertUser":{"userID":64466,"name":"sushilp","url":"https:\/\/community.smartsheet.com\/profile\/sushilp","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!bCFWG3XASHo!HXjWn2mniiQ!_myWsvAATx0","dateLastActive":"2023-08-24T01:14:28+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-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":63,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/43206\/need-your-advise-on-nested-if","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/43206\/need-your-advise-on-nested-if","format":"Html","groupID":null,"statusID":0,"image":{"url":"denied:data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAM8AAACKCAIAAACCdonXAAAAAXNSR0IArs4c6QAAESZJREFUeF7tXAFMFFcaftTbxnA1YCOnIEqJqwnXc69ltd3lrmiAO7G50sienkLxVgkNhyE2BGOqq011oSEQLsbTcEewnBSktUtzaizesaRij93ELvXwlMauoVRc8GhqiS0x2VjuvZnd2Vl2dvfNzu6wu\/4vTSqz\/\/vf\/3\/zvff+98\/8k3D9+vXFixej6Gv379+PTsPCDlV8e8r37omwYwcKAQF\/CADbgBvyIQBskw9rGAnYBhyQDwFgm3xYw0jANuCAfAgk+M+AjHToG8wuSxSJS5S5Oyu3q5Kkmea0\/a32y43Htq8Jria+8wJ8\/+PbUxEZkPx97UxrfedPSntzQ+9EcJYEkpi29N0uyKWgmrRhoHeUIkC7kyatytWuckx9i9A3ZqO+Y8TlzpT5qL7jBv6D\/OPUJWvLmxV6fUVVvck+I+Dw1NWB6Y3qtCiFAsyKOAK0bJu+1nvua9Xq9EAGWWxTmw+0tre9XfTofPfglI+ow\/aJojAHyBbxmxq1AwRhm7lRz7a9p78rOlCpCRi25b76SsYihBakqbVKu+ObuT7fGjiXXqCVGPhFLZBgGAUCQdjmitsOFSY5k9NSEykU+hWx2yyq9SqFFBXQN8YRoNtJV23ekTlg+tR3c6T2\/qGt76q24DkgGzVi8ShIxzaUpHk1f+p9k+0hQovTMhQWyzA5BUzfHrDcpkJlZujy8IvrlAuohEEoXhGgZBtCeHnLspn+6UALsooq19lPVuGzZ8O\/nGkraZCZ\/uzf3xTlKmlEKWRwIlCvN\/Q6vEUdHx\/Al7kDsrGPtxLf6NAfNZO\/yYHa0yr2NpyyetQ4rKeM1fhMrcfXu69x3ZnhXK2iqrahe3iawshwicyM9bUcYK2qNnLWTvUZXR65xyFXTjOpAm8fieHsdUSlCuupqD8\/JpRSkO7ST\/yryCprb+f9mqSpadUwfyepd9erd7t\/2s78IyX\/kEc4pcDA74kmLL2ocH+qdGt5GsbPDdwq9GSJH9kHLs6hn7\/hlGVNhvwl5FfnuPl4g7Fj0bGyZxVT\/ca3LiwpN5w0LFU4J6xtjQeaZ5pqclyHGhy\/lj1LukzfNh0\/2tD7Tn1heN3xY+xUX7NxQFljbM1KQs571raGt1oUJyvVQQMSj4+cYhpVM8MdxosZNcZXMiSF6H5vNPXaJoUqqYX1+3LDehhVanKSzZ\/YnG6rnNf6zEkazSpxVirS8zevnxmb+A49Guk948ivrNQsJTdSkaqprMy3n\/nY7qPPk3cUN1RI0tiq96cLd23HVCNWLdXoXs6wXraFsu5QqJq50fFm+w87DWVZkaEadkEWtoUEdeBOqzcWKgf7LK49zTl81arcVLBa5EB4tbh8VbFkcTK67xhzan\/Jf8ixcrXqgX3MJ41Dk3cUaYV\/cWKV6ueZHgGyadRoQiFDUFX3zM3Hx4r2V6qfDpv5vopilG12h1NbkGO3sCEUfiBm0xSsR1P\/o0HK3lHrisKqjOfQq4adeGP6dmpsTteFiT\/lXRGVd6QxgkrmnsN3cfV0vN2xjxeD7nuPL+vxUa83mvGcCazqe8upD28mPUVllBShGGUb2VjUG\/PHLllwsOYY7B3LK1AvdDof0ECBYxr24W976\/H6ygImRHk6JWNO14czP\/CuhDHvSGOiS2ZpWqCD1aqyRpcf5H+Nr\/FlPT62tzNBamBVM2mbd1WX78o419AxgtMOEWuxyzaE1uQWoXMDIyMDF1HRRj7WyckpyPmIh9kjLsDzAyST1vnPLd6vX385vEiZwRwmPE163lHUjXwqeYli+Oaopw85eDZbQ4nbAqv6WQbO3Cc+W1b94mctH4yEop\/OrwBs456402kSJeX1aF9UT75wmnZThvlYs3llodbrhKhQqlSOSybrPYZk0\/bzFyxp67JSAoyzIKtwR5q5pYXtguO5lhazcsdmn6WFl3cM2Wr6jgvVuj8k9Z45b2fiBWyV6aIjf5M6lLiNTpXy94bNY83N\/OQRvbUUkrG8tuFczPoC9SOkzpv79DUpp9Kw5ck+I04K6isMp+6+YDD8NsjbACl5hre3ubpU1V9O3lnPpT\/mLm9s3lGWllJQY3jh7ikDybcRq\/Tv4GQNxcj8uE3PZuaoVC1IKXx9O3rf2HEjIgtcgLcp8dq2z1FM8kwjp\/Wmp3ZnfdHde2sGpWrK38CZgumBxr03N7ZWrifOT19pqB0pOPm6WvHtcDdeFrDYImVhdY1uDZ6HOKl4+q8fWh0PFYlrCmve0CUNGrmQlstj+SIY3+8Y8v2Nb09FvE3JgWL\/9Oby10+2tp2sVg63XcK56aR1v1JZbcPMXjUzctWuVqsUj+zdxuN2taG1vf1YldLWeJo86bp9ruEfT27HAW3bscr0gYb3bMn4GN9UpkT5+9tdKVOKyQoi8YAA7U6qfFmnwSHzgkSVRuscc+CVOTF7g8Z6dRjz6cHw4Ih6PV7hb1nMiqLdm8ielZiVn7\/SehM\/RU1MTn7o+PJrhxMlqkqbjr0Gr4HEA29C84GWbQLaF6rW59iu3nA6v7g28tIG9UKEfsSRrIk8rSRtX8dtNHZvGqUWGg7kTl\/4897KiqoGk\/0hTdgRmi\/QK9oRkMA2pFCp1TabzWIbztdkEUefQIqVZM\/kmiEPP97DoV7u7v2NJ1tOGp63N7eY5XymHe3wP2b2SWEbUjy3IXeoreNG7jr2AWXmutzvP+6+4iC5Lqdj4N3u4QfIOXx6r7F7BOddF8xZ1b6bjsi55zG7gTHlriS24bePtBsUil+7X1xbmFVmKE+5Yqwq1+ur\/3JzhVa5CKf8d+7XOJiHLBXGz9Oqy\/PJI+YlqlzVSFtVBVdOE1OggbEhIhAgAxKixnB1i++8AGRAwsUT0AMICCMgbScFVAEBMQgA28SgBbLSEAC2ScMPeotBANgmBi2QlYYAsE0aftBbDALANjFogaw0BIBt0vCD3mIQALaJQQtkpSEAbJOGH\/QWgwCwTQxaICsNAWCbNPygtxgEgG1i0AJZaQgA26ThB73FIABsE4MWyEpDANgmDT\/oLQYBYJsYtEBWGgLANmn4QW8xCADbxKAFstIQALZJww96i0EA2CYGLZCVhgCwTRp+0FsMAsA2MWiBrDQEgG3S8IPeYhAAtolBC2SlIQBsk4Yf9BaDALBNDFogKw0BYJs0\/KC3GASAbWLQAllpCADbpOEHvcUgAGwTgxbISkMA2CYNP+gtBgFgmxi0QFYaAsA2afhBbzEIANvEoAWy0hAAtknDD3qLQYB85VmMPMgCAqEjQNj2zDPPhK4gYj2\/+uqr6DQs7B7Ht6d872AnDTt5QKFfBIBtQA75EAC2yYc1jARsAw7IhwCwTT6sYSRgG3BAPgSAbfJhDSMB24AD8iEAbJMPaxgJ2AYckA8BYJt8WMNIwDbggHwIANvkwxpGArYBB+RDIGFwcFC+0WCkxxuBhNnZ2ccbAfBePgQSxsfHly9fLt+A1CPdvXs3Og2j9oBWEHuatvzvtNKxJue4+0fuPkLcFmt3L5btBbbF8t2LNduBbbF2x2LZXmBbLN+9WLMd2BZrdyyW7fXHtsmubQl11lj2LCTbLUcTdGcm3V0tdQmexl2fPKPjXa6zuKQFhQmMnnbULRuSbXHQaZ7WtvEuXYKuazzKALTW5RzmmTQ+OrS1cwInJJlm2rGM\/W3U3mO0uK\/OHtSyV4WFR0fPGgc52UMu2ShzWz5z5olt8jlIP9JkV\/NQ8VYvtvWszXRRzHN5cvR6cWa6j9rxUQFhQsHMTHoT4l2Sgm3WuoRtXV1HXRsCu6HgHYe3z+L9wr1QYWG3oGfpmnvRUreitAf1lK6IouVt8swe05YTtWv5tBoqVvpSBS9X2b5smxwVEhakYLxTKoB\/FGzDvc+Wjv6G2Q8sxp6SPZhG2l2dQ81drgBnvN+EdHl4uuP9UTvUeYeVzC5dwcY0ljr+xRrcS3vwTmcxKu68YyrxXSTm52ZY2kqya917Jbdjoo\/2uObONs5ZvFwNNbmnFDfl8PbqK0woeN0j+7hHbQjRsQ0Z8zTMLdDkGdlbkZ6nQ6Z+JvCyvFuaXVOCd5zJK6aeI7UuAmkODh4x9LvOGT2l7zJQaw7OfkAko61ZjuYgizsCcxmHd0zUs7bWFXTVjKayMT5ers4iHTujZicym9nlWVgYU7AH6VyR353MJo6y0ea\/XPbQsU0g+FhWUpNtuoJXN0v\/YRcXyfw+nMMdwXDEPTSKBbQHZweN3PUoPJeNdzVd7yxnp5OnLSv5YHaWi+vTM4sP9xO64Qkzyy3JyzLX9jAgCAtrD816Zld6ZvZZ1\/yU6+ZG3Th0bBM0W5OXXdJmsfYbjuR5zlpHPCcw3jkOE45peAM9nBNtiRWyJJ8tTWVmCZ4hPSWpCYJTwk+8n+17kMBwCQsLBHxRx4hIGiSBbUibd8SQg2OyXS6y4WCu+HCT+3BA8k+EWPxkB57fSOhAF0kPg+petsPE5SgGj6DirglmSXPbz\/THjERb8ki0gJNtng2RW9cFhUmyzZO9mzMtg5oVjwJS2EbOCsVbmfMB29JLTORwwO6lOBKaPYi3J++LQ10nSGCHw76t+EwazQlkEgAgrSsuSLXXsvk2TM2JLSZ2IUxIaMq8w0Z7gsJ4e53QfeSWbc6ceOzzbfB+2\/yvIfB+2\/zfA7Ag\/hCQtJPGHxzgUUQRALZFFF5Q7oUAsA0IIR8CwDb5sIaRgG3AAfkQALbJhzWMRPJtgML8IpD+u33za0CkRx+\/0MgOAdndSEMdXH\/C8yXBhWJZYvbzLmBbtNxAlm0\/fv6LaDEofHY88fx\/sTKObRC3hQ9a0BQMAWBbMITg9\/AhAGwLH5agKRgCwLZgCMHv4UPAH9u8anHZl7mi7Z1b70pjP3XC5F1OV3Pb7+saqdbxrkkmXXhlzBhvb\/1cYRmpQAuEla\/a8N272NMUaG3j1eiSaiuDlqsLjwI\/51QaI8E6YVxKOOqqY7nTOaRlK1bcr60zZSydW\/HLuuX4jUj+G7zYWYSM3iVYTOWBuwuHDFfSHAgrXgn0Y\/5tRuqdVFPeuZWroZp3tglUGvvWCU+eaTJw9QH4FWJP9YrLflxDWoo6T3gX9jEliQbj3BIsMS5HF1ZiLI+wLDXbyOLhtoWpZ3Z\/LQPvI8yaQfasui7uGxmRrK3yrTQmhXc+de24BqyYKSbw03ANaY+RqU3kN4ajviVYou4DDytR\/eJdmJZt5B5wVaV+QTGY0InI11YJVBoL1QmTGk\/81Q7uuy9z4k4\/rBKmoCgazMXKXdDFBnuiVMWZcCC2Gdw1IBij1BLU6ar4CIBAse4lZqUgRS6RAkqo0ph8CUawTrinpAk1s\/EWLmnhfwhisv8joZUPV0YFn1QCrgXCCuI2N2A0p4RBUh\/PFcEHYlHk6yWFK42RUJ0wLi3GJwCmxIs0XI\/IVhqzDW927rnB8wivkYhfHks9ZdynBHqsqFXHkSDNTsp8tuNwjndGYH4woK00RoT3mcpiLyJdx1fdQRpZw3znBrPgCXxpht7ZKMKK3mjZJGnYRmpCT3QVs9+bYTbKzGL3RwaYGEW+5qfSWLhOeNlLOoSr+T2LmftrJuS7HYJrmPCCJ869OViJ6xzn0nRsI+moE52k3phJuRFAEVulvAfpXN+hmU+g\/NQJ46wH\/tbL3EpjZh\/Fnyzxbfhza+HwwgsrrBBOCW5U4f22cPBLmg5440gaftAbEBBCgHYnBfQAAekIANukYwgaaBEAttEiBXLSEQC2SccQNPhFABdbcAVXWAjYBlyJFAK4BAb\/h+sXuaIyyIBECmt6vXFZ4YdXNbbgim1s2RVUL9OzIlKScVm9jDdQvl\/sfgprW6Q4RK83Xr9N6bu2QdxGzwqQFIcA3kzZUwJXvfx\/9ou\/1W1GpaIAAAAASUVORK5CYII=","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":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":42211,"type":"discussion","name":"countif column values based on a monthly value","excerpt":"Hi, I am creating a table of count of values in a column based on what month is reported in another. the table I want is attached. The formula I am using is as below. Can anyone advise what need to change in the planned formula =SUMIF{V2.0 Eirabot - Gantt Range 1}},\"12\", {V2.0 Eirabot - Gantt Range 1} I also want to have…","categoryID":322,"dateInserted":"2019-02-25T05:47:13+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-03-08T07:43:40+00:00","insertUserID":73211,"insertUser":{"userID":73211,"name":"ALAN.ROSSNEY","url":"https:\/\/community.smartsheet.com\/profile\/ALAN.ROSSNEY","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bKNbG4XkT7o!zXPYsz3VzP4!0KJtUCE_Pzk","dateLastActive":"2023-01-30T15:59:27+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-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":52,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/42211\/countif-column-values-based-on-a-monthly-value","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/42211\/countif-column-values-based-on-a-monthly-value","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-02\/3a\/5d\/3a5d931849d5ed392fb3c789e551fcde.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"countif.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":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":265,"urlcode":"reports","name":"Reports"}],"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":43216,"type":"discussion","name":"email lookup","excerpt":"hi, Is there a way that if I choose a name from a drop down box in one column it will show the appropriate email address in another column? regards, Mark","categoryID":322,"dateInserted":"2019-03-07T21:39:44+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-03-08T02:55:22+00:00","insertUserID":81246,"insertUser":{"userID":81246,"name":"itsupport81246","url":"https:\/\/community.smartsheet.com\/profile\/itsupport81246","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-03-07T20:33:32+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":1,"countViews":73,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/43216\/email-lookup","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/43216\/email-lookup","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":254,"urlcode":"formulas","name":"Formulas"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}],"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":43111,"type":"discussion","name":"Checkbox Range Formula","excerpt":"Hello- Is there a formula that will check a box if another range of cells is also all checked? For example, I have a column that has 5 checkboxes in it. I want another cell to also check off as soon as all 5 checkboxes in the column have been checked. ","categoryID":322,"dateInserted":"2019-03-06T20:34:41+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-03-07T20:37:39+00:00","insertUserID":66691,"insertUser":{"userID":66691,"name":"hennarizvi","url":"https:\/\/community.smartsheet.com\/profile\/hennarizvi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-04-14T19:15:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":66691,"lastUser":{"userID":66691,"name":"hennarizvi","url":"https:\/\/community.smartsheet.com\/profile\/hennarizvi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-04-14T19:15:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":412,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/43111\/checkbox-range-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/43111\/checkbox-range-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}]},{"discussionID":40916,"type":"discussion","name":"Turn average working days to projected date using WORKDAY()","excerpt":"The basic ask is to calculate a projected due date based on historical data and duration that a certain task takes. So if x, y, and z parameters are checked, it will find the average amount of time (from a different sheet) that those parameters take and then calculate a suggested due date. I want to use WORKDAY(), but am…","categoryID":322,"dateInserted":"2019-02-07T11:31:53+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-03-07T18:08:07+00:00","insertUserID":77586,"insertUser":{"userID":77586,"name":"Henry.Busch","url":"https:\/\/community.smartsheet.com\/profile\/Henry.Busch","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-02\/e3\/ae\/ne3ae93242dd0209e67814afdaaf291b2.jpg","dateLastActive":"2019-08-05T16:57:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":77586,"lastUser":{"userID":77586,"name":"Henry.Busch","url":"https:\/\/community.smartsheet.com\/profile\/Henry.Busch","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-02\/e3\/ae\/ne3ae93242dd0209e67814afdaaf291b2.jpg","dateLastActive":"2019-08-05T16:57:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":63,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/40916\/turn-average-working-days-to-projected-date-using-workday","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/40916\/turn-average-working-days-to-projected-date-using-workday","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":218,"urlcode":"construction","name":"Construction"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":285,"urlcode":"solution-center","name":"Solution Center"}],"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":42986,"type":"discussion","name":"Nested IF\/AND Help with RYGB Status Balls","excerpt":"I'm trying to accomplish two things: First, for the \"Status Visual\" column, I'm trying to state the following formula: * If the \"Task Finish\" is 3 days overdue, and the \"Task Status\" is not \"Complete\" the ball should be red. * If the \"Task Finish\" is 1 day overdue, and the \"Task Status\" is not \"Complete\" the ball should be…","categoryID":322,"dateInserted":"2019-03-05T16:53:29+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-03-07T14:35:55+00:00","insertUserID":71316,"insertUser":{"userID":71316,"name":"Tiffany Blankenship","url":"https:\/\/community.smartsheet.com\/profile\/Tiffany%20Blankenship","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-12\/bd\/ad\/nbdadc07ac084d1469a6063d16f89fd25.jpg","dateLastActive":"2019-03-05T16:51:48+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-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":230,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/42986\/nested-if-and-help-with-rygb-status-balls","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/42986\/nested-if-and-help-with-rygb-status-balls","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-03\/b4\/2d\/b42da86de56efe05fe1f4743bd473005.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.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":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":42991,"type":"discussion","name":"Searching a series of columns for blanks","excerpt":"Hey all. I am trying to have a column search a series of columns and return the data from the column that is not blank. I have started with the following: =IF(NOT(ISBLANK([Title:]1)), [Title:]1, [Peer to Peer Program Title]1) Which checks the Title column, and if not blank returns the data from Title: column. If the Title:…","categoryID":322,"dateInserted":"2019-03-05T17:12:21+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-03-07T14:25:37+00:00","insertUserID":80931,"insertUser":{"userID":80931,"name":"Josh Jereczek","url":"https:\/\/community.smartsheet.com\/profile\/Josh%20Jereczek","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-23T16:05:54+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-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":62,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/42991\/searching-a-series-of-columns-for-blanks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/42991\/searching-a-series-of-columns-for-blanks","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":219,"urlcode":"sheets","name":"Sheets"},{"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":42996,"type":"discussion","name":"Why is my formula UNPARSEABLE? Is it because of Dropdown Dependency?","excerpt":"It's a long formula - I want to make the number of starts in the \"Current Status\" column dependent upon the selection in the drop down from the \"Contract\/Grant Status\" column: =IF([Contract\/Grant Status:]1 = Submitted, \"Empty\", IF([Contract\/Grant Status:]1 = Assigned, \"One\", IF([Contract\/Grant Status:]1 = ELD Review ODE…","categoryID":322,"dateInserted":"2019-03-05T17:17:25+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-03-07T14:21:11+00:00","insertUserID":25136,"insertUser":{"userID":25136,"name":"twaiteORELD","url":"https:\/\/community.smartsheet.com\/profile\/twaiteORELD","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-03\/48\/3c\/n483c9b7c4fdf7ed56125e9f5610f6fcf.jpg","dateLastActive":"2019-03-12T12:17:04+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-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":73,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/42996\/why-is-my-formula-unparseable-is-it-because-of-dropdown-dependency","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/42996\/why-is-my-formula-unparseable-is-it-because-of-dropdown-dependency","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":249,"urlcode":"education","name":"Education"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":263,"urlcode":"government","name":"Government"},{"tagID":281,"urlcode":"support","name":"Support"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">