Formulas

=TODAY AND [Deviation from Proposed Launch Date]…","categoryID":322,"dateInserted":"2019-01-22T16:52:28+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-23T15:52:07+00:00","insertUserID":76046,"insertUser":{"userID":76046,"name":"KWright84","url":"https:\/\/community.smartsheet.com\/profile\/KWright84","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hafYoX3UND4!!E9s4FnPd1e9","dateLastActive":"2020-11-12T14:29:24+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":6,"countViews":102,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/39596\/complex-if-and-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/39596\/complex-if-and-formulas","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-01\/99\/5a\/995ac7b912aec1dc4b53afe1755539eb.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Slide1.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":249,"urlcode":"education","name":"Education"},{"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":39641,"type":"discussion","name":"Why won't my Nested COUNTIFS work?","excerpt":"Hoping the community can assist! These two COUNTIFS work separately. =COUNTIFS({Finish}, >TODAY()) =COUNTIFS({PctComplete}, <1) But why isn't it working when I nest them together? (it returns #Incorrect Argument Set?) =COUNTIFS({Finish}, >TODAY({PctComplete}, <1)) If you care to, I'd appreciate answers to a few additional…","categoryID":322,"dateInserted":"2019-01-23T09:32:53+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-23T13:18:34+00:00","insertUserID":76021,"insertUser":{"userID":76021,"name":"Jon's Smartsheet","url":"https:\/\/community.smartsheet.com\/profile\/Jon%27s%20Smartsheet","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-01-22T15:19:25+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-26T14:46:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":72,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/39641\/why-wont-my-nested-countifs-work","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/39641\/why-wont-my-nested-countifs-work","format":"Html","groupID":null,"statusID":0,"image":{"url":"\/libraries\/smiley\/images\/regular_smile.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"smiley"},"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":27971,"type":"discussion","name":"Multiple If Statements","excerpt":"I have found quite a bit of useful information to make Nested If statements; however, they are set-up to be \"if this, then that or if this, then that\". What I need is: \"If this is equal to this, and this is equal to this, then this\" Here is what I have come up with: =IF(AND(Firm2 = {Building Code}, Firm = {Firm},),…","categoryID":322,"dateInserted":"2018-07-02T20:36:23+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-23T12:39:27+00:00","insertUserID":52411,"insertUser":{"userID":52411,"name":"@ChrisMcKay","url":"https:\/\/community.smartsheet.com\/profile\/%40ChrisMcKay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-07-04T00:35:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":61581,"lastUser":{"userID":61581,"name":"ssanchez","url":"https:\/\/community.smartsheet.com\/profile\/ssanchez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-01-23T12:24:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":15,"countViews":1483,"score":null,"hot":15,"url":"https:\/\/community.smartsheet.com\/discussion\/27971\/multiple-if-statements","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/27971\/multiple-if-statements","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":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":38951,"type":"discussion","name":"Issue with COLLECT and duplicate dates","excerpt":"We are trying to achieve a formula that finds the most current Tracked task's Variance from the Baseline date. Tasks are arranged in a table\/schedule in step by step order. I'm having an issue with this formula here: =INDEX([Baseline Variance]5:[Baseline Variance]128, MATCH(MAX(COLLECT([Task Complete Actual]5:[Task…","categoryID":322,"dateInserted":"2019-01-14T11:33:37+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-23T07:36:21+00:00","insertUserID":74936,"insertUser":{"userID":74936,"name":"RMRGSA","url":"https:\/\/community.smartsheet.com\/profile\/RMRGSA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-09-18T11:39:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":39511,"lastUser":{"userID":39511,"name":"eric.o","url":"https:\/\/community.smartsheet.com\/profile\/eric.o","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-11\/b4\/72\/nb47282e48b112cb30b474010a6cdfb22.jpg","dateLastActive":"2019-02-26T06:44:46+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":93,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/38951\/issue-with-collect-and-duplicate-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/38951\/issue-with-collect-and-duplicate-dates","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-01\/ac\/36\/ac36fad5b1588e395a5b4a3daf52734c.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Schedule Smartsheet.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":208,"urlcode":"workspaces","name":"Workspaces"},{"tagID":218,"urlcode":"construction","name":"Construction"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"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":39631,"type":"discussion","name":"File name of the sheet in a cel?","excerpt":"Hello all, Maybe simple question, but I would like to have the a cel inside a smart sheet filled with the filename of the sheet? How can I do this easy? e.g. CLIENT-001-sheet011 in a cell? Thanks, Eric.","categoryID":322,"dateInserted":"2019-01-23T06:05:18+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-23T06:37:44+00:00","insertUserID":74856,"insertUser":{"userID":74856,"name":"egdk","url":"https:\/\/community.smartsheet.com\/profile\/egdk","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-01\/b2\/85\/nb28530a54bf4b2c6e693dbb632fc518c.jpg","dateLastActive":"2019-01-23T06:02:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":24411,"lastUser":{"userID":24411,"name":"Marcin P","url":"https:\/\/community.smartsheet.com\/profile\/Marcin%20P","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-09\/b9\/54\/nb954f24aea6d9da6778d1e49f99fa373.jpg","dateLastActive":"2019-04-09T01:27:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":679,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/39631\/file-name-of-the-sheet-in-a-cel","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/39631\/file-name-of-the-sheet-in-a-cel","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":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":17441,"type":"discussion","name":"Merging Cells and Exporting Reports to PDF via the App","excerpt":"Hi there, I love Shartsheet, but one constant aggravation for me is the inability to merge cells. In my quest for a solution, I've come across a few posts on the blog (some as old as 2015) where similar requests were answered with a generic \"we'll pass this along to our developers\" type response. Just curious: is this…","categoryID":322,"dateInserted":"2018-01-08T12:32:35+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-22T15:36:12+00:00","insertUserID":33976,"insertUser":{"userID":33976,"name":"Chase Arthur","url":"https:\/\/community.smartsheet.com\/profile\/Chase%20Arthur","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-04\/cc\/ca\/nccca783dffcecdfc5fb6bc34d32765a6.png","dateLastActive":"2020-02-20T19:02:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":10881,"lastUser":{"userID":10881,"name":"Michelle Vonderau","url":"https:\/\/community.smartsheet.com\/profile\/Michelle%20Vonderau","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/e6\/e2\/ne6e2b30945899693d6aa02699789a368.jpg","dateLastActive":"2019-01-22T15:08:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":276,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/17441\/merging-cells-and-exporting-reports-to-pdf-via-the-app","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/17441\/merging-cells-and-exporting-reports-to-pdf-via-the-app","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":220,"urlcode":"hospitality","name":"Hospitality"},{"tagID":246,"urlcode":"mobile","name":"Mobile"},{"tagID":250,"urlcode":"printing","name":"Printing"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":265,"urlcode":"reports","name":"Reports"},{"tagID":281,"urlcode":"support","name":"Support"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">