Formulas and Functions

Finish15, [% Complete]15 < 1), 1, \"//www.santa-greenland.com/community/categories/formulas-and-functions/\"). If I drag the formula all the way down the sheet, then the Late Tasks column populates with a 1. How do I write the formula to not include blank…","categoryID":322,"dateInserted":"2018-02-09T13:59:36+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-02-13T11:25:38+00:00","insertUserID":37381,"insertUser":{"userID":37381,"name":"brandon.elmer","url":"https:\/\/community.smartsheet.com\/profile\/brandon.elmer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-09-12T14:12:25+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-10-02T20:19:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":2186,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/19221\/nested-if-function-ignore-blank-cells","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/19221\/nested-if-function-ignore-blank-cells","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-02\/cc\/cb\/cccbc0e777635a22c988b894e17a91e5.PNG","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-02\/cc\/cb\/cccbc0e777635a22c988b894e17a91e5.PNG","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-02\/cc\/cb\/cccbc0e777635a22c988b894e17a91e5.PNG","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-02\/cc\/cb\/cccbc0e777635a22c988b894e17a91e5.PNG","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-02\/cc\/cb\/cccbc0e777635a22c988b894e17a91e5.PNG","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-02\/cc\/cb\/cccbc0e777635a22c988b894e17a91e5.PNG"},"alt":"late tasks.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":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":19246,"type":"discussion","name":"COUNTIF Formula for Only Showcasing What is Due to Upcoming Week Period","excerpt":"I'm trying to determine a COUNTIF formula to show what deliverables are due in the next 7 day period based upon a Due Date column. However, I'd like said formula to only showcase what deliverables are in the next 7 days and ALSO be able to EXCLUDE all projects that become overdue. So essentially I'd like a COUNTIF formula…","categoryID":322,"dateInserted":"2018-02-09T14:59:05+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-02-13T09:00:00+00:00","insertUserID":37346,"insertUser":{"userID":37346,"name":"cklasson@","url":"https:\/\/community.smartsheet.com\/profile\/cklasson%40","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-02-12T09:51:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":37346,"lastUser":{"userID":37346,"name":"cklasson@","url":"https:\/\/community.smartsheet.com\/profile\/cklasson%40","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-02-12T09:51:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":999,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/19246\/countif-formula-for-only-showcasing-what-is-due-to-upcoming-week-period","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/19246\/countif-formula-for-only-showcasing-what-is-due-to-upcoming-week-period","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":266,"urlcode":"real-estate","name":"Real Estate"}],"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":19411,"type":"discussion","name":"VLOOKUP #INVALID DATA TYPE","excerpt":"I'm trying to use VLOOKUP for the first time, and perhaps I just don't understand how it all works. I keep getting an \"invalid data type\" error. Here's my formula. =VLOOKUP(Workorder10, {Platform MPS Range 3}, {Platform MPS Range 4}, true) [Workorder]10 is the workorder number I'm attempting to search in the {Platform MPS}…","categoryID":322,"dateInserted":"2018-02-12T22:09:17+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-02-12T22:38:30+00:00","insertUserID":27221,"insertUser":{"userID":27221,"name":"Mikey67156","url":"https:\/\/community.smartsheet.com\/profile\/Mikey67156","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nxlcH_B5Abw!pFlcaSRvqTo!cqUBJp0qfNY","dateLastActive":"2023-10-03T15:06:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":27221,"lastUser":{"userID":27221,"name":"Mikey67156","url":"https:\/\/community.smartsheet.com\/profile\/Mikey67156","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nxlcH_B5Abw!pFlcaSRvqTo!cqUBJp0qfNY","dateLastActive":"2023-10-03T15:06:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":604,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/19411\/vlookup-invalid-data-type","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/19411\/vlookup-invalid-data-type","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-02\/49\/55\/4955cbcd4b433821b5bea57280f12d58.JPG","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-02\/49\/55\/4955cbcd4b433821b5bea57280f12d58.JPG","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-02\/49\/55\/4955cbcd4b433821b5bea57280f12d58.JPG","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-02\/49\/55\/4955cbcd4b433821b5bea57280f12d58.JPG","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-02\/49\/55\/4955cbcd4b433821b5bea57280f12d58.JPG","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-02\/49\/55\/4955cbcd4b433821b5bea57280f12d58.JPG"},"alt":"SNIP 1.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":211,"urlcode":"manufacturing","name":"Manufacturing"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":281,"urlcode":"support","name":"Support"}],"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":19291,"type":"discussion","name":"confused about VLOOKUP across sheets","excerpt":"I can't figure out how to make the function work or I'm trying to do something not supported. Basically, I want to pull the value of a cell from a row on sheet B and put it in a cell on the same row in sheet A. I'm not looking to perform any specific calculations on the data, just to grab a copy. What I'm trying to do is…","categoryID":322,"dateInserted":"2018-02-09T21:42:39+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-02-12T18:11:38+00:00","insertUserID":35116,"insertUser":{"userID":35116,"name":"joechap","url":"https:\/\/community.smartsheet.com\/profile\/joechap","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-04-29T01:38:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":35116,"lastUser":{"userID":35116,"name":"joechap","url":"https:\/\/community.smartsheet.com\/profile\/joechap","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-04-29T01:38:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":1322,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/19291\/confused-about-vlookup-across-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/19291\/confused-about-vlookup-across-sheets","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