Formulas and Functions

0, \"0\" )), ([Net Profit]2667 - 100) * 0.4) I would greatly appreciate your help. Thank you.","categoryID":322,"dateInserted":"2020-08-04T20:52:47+00:00","dateUpdated":null,"dateLastComment":"2020-08-05T19:05:39+00:00","insertUserID":103186,"insertUser":{"userID":103186,"name":"Yeshaya","url":"https:\/\/community.smartsheet.com\/profile\/Yeshaya","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-08-05T19:04:50+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-18T20:45:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":72,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/70362\/multiple-if-functions-nested","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70362\/multiple-if-functions-nested","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-08-05T19:04:47+00:00","dateAnswered":"2020-08-05T18:49:21+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":70363,"type":"question","name":"Double Notifications","excerpt":"I have a work flow set up for vacation requests at our company. This is what happens: Enter information on a form Form is sent to relevant project Manager for approval If approved it is copied to another sheet to populate a calendar view on our dashboards, if it is denied it kicks an email back to the submitter. I only…","categoryID":322,"dateInserted":"2020-08-04T21:39:25+00:00","dateUpdated":null,"dateLastComment":"2020-08-05T19:01:49+00:00","insertUserID":123087,"insertUser":{"userID":123087,"name":"KC Fife","url":"https:\/\/community.smartsheet.com\/profile\/KC%20Fife","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!e0_UB_iDGHw!kwvVn79of_4!QfHibJQS8qB","dateLastActive":"2020-08-24T21:03:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":93956,"lastUser":{"userID":93956,"name":"Brian Campbell","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Brian%20Campbell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/DD9DQEP8RM65\/nZX0DUWQ2IMP3.jpg","dateLastActive":"2022-08-04T19:51:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":137,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/70363\/double-notifications","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70363\/double-notifications","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/Q93Y0M0BNYE3\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-08-05T19:02:27+00:00","dateAnswered":"2020-08-05T19:01:49+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":68304,"type":"question","name":"//www.santa-greenland.com/community/categories/formulas-and-functions/\"Smartsheet Formula Examples\" template cell references issues","excerpt":"The \"Smartsheet Formula Examples\" template, while very helpful, appears to have a variety of issues with cell references that have been moved over time. Somewhere around row 26 things start to get weird. Is this only on my copy of this sheet? I did delete it from my workspace and reload it to see if it would be fixed, but…","categoryID":322,"dateInserted":"2020-05-14T01:50:26+00:00","dateUpdated":"2020-05-14T01:51:08+00:00","dateLastComment":"2020-08-05T18:52:47+00:00","insertUserID":120919,"insertUser":{"userID":120919,"name":"Jamie Bedford","url":"https:\/\/community.smartsheet.com\/profile\/Jamie%20Bedford","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-19T19:15:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":120919,"lastUserID":120919,"lastUser":{"userID":120919,"name":"Jamie Bedford","url":"https:\/\/community.smartsheet.com\/profile\/Jamie%20Bedford","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-19T19:15:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":13,"countViews":384,"score":null,"hot":13,"url":"https:\/\/community.smartsheet.com\/discussion\/68304\/smartsheet-formula-examples-template-cell-references-issues","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68304\/smartsheet-formula-examples-template-cell-references-issues","format":"rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/584\/ZSBGJ9TC0LRI.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet Formula Examples issues.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-04-28T23:09:10+00:00","dateAnswered":"2020-08-05T18:45:19+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":215,"urlcode":"Templates","name":"Templates"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"}],"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":70388,"type":"question","name":"IF(OR) trying to OR 3 expressions","excerpt":"From what I can see I should be able to 'OR' 3 expressions, but I keep getting unparseable. =IF(OR(Required@row = \"Full Topo including underground services\",(Required@row = \"Full Topo excluding underground services\",(Required@row = \"Drainage trace only\"), \"Yes\", \"No\") Any help appreciated. Regards Paul","categoryID":322,"dateInserted":"2020-08-05T17:35:01+00:00","dateUpdated":null,"dateLastComment":"2020-08-05T18:07:26+00:00","insertUserID":94521,"insertUser":{"userID":94521,"name":"vipa2000","url":"https:\/\/community.smartsheet.com\/profile\/vipa2000","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-04T08:00:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":94521,"lastUser":{"userID":94521,"name":"vipa2000","url":"https:\/\/community.smartsheet.com\/profile\/vipa2000","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-04T08:00:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":103,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/70388\/if-or-trying-to-or-3-expressions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70388\/if-or-trying-to-or-3-expressions","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-08-05T18:14:56+00:00","dateAnswered":"2020-08-05T17:39:12+00:00","acceptedAnswers":[]}},"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":70379,"type":"question","name":"Can someone help me get my SUMIF formula to work??","excerpt":"I am not as savvy as I want to be with SmartSheet, but I am hoping someone can help me manipulate this data the way I want to. I am trying to to summarize each individuals resource hours spent in meetings within a certain project. I have created a basic sheet that shows all of the meetings, the meeting length, and then who…","categoryID":322,"dateInserted":"2020-08-05T15:30:05+00:00","dateUpdated":null,"dateLastComment":"2020-08-05T18:03:15+00:00","insertUserID":122559,"insertUser":{"userID":122559,"name":"Erika Haskell","url":"https:\/\/community.smartsheet.com\/profile\/Erika%20Haskell","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nrDB_-7PHGQ!gs1CH4aQtEQ!jGkLmKiCbD6","dateLastActive":"2020-08-05T17:58:32+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-18T20:45:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":75,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/70379\/can-someone-help-me-get-my-sumif-formula-to-work","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70379\/can-someone-help-me-get-my-sumif-formula-to-work","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/SUY04ZI6TD4U\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-08-05T17:58:58+00:00","dateAnswered":"2020-08-05T17:58:01+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":70377,"type":"question","name":"Trying to create a simple IF..OR..ISBLANK formula","excerpt":"I'm getting an invalid operation error and I know I'm making a simple mistake but I've tried everything... =IF(AND(NOT(ISBLANK([Launch Date\/Prod Release\/Go Live)]4)), >=TODAY(-7)), 1) IF the Launch Date\/Prod Release\/Go Live cell is not blank and the date in the cell is greater than or equal to the date 7 days ago, the…","categoryID":322,"dateInserted":"2020-08-05T15:21:12+00:00","dateUpdated":null,"dateLastComment":"2020-08-05T17:53:06+00:00","insertUserID":111476,"insertUser":{"userID":111476,"name":"Sarah Brelage","url":"https:\/\/community.smartsheet.com\/profile\/Sarah%20Brelage","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-07-13T13:56:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":124372,"lastUser":{"userID":124372,"name":"Mathieu PERSICO","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mathieu%20PERSICO","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/JL9RVWFGDJGG\/nEXC7GUEA748S.jpg","dateLastActive":"2022-10-12T17:19:24+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\/70377\/trying-to-create-a-simple-if-or-isblank-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70377\/trying-to-create-a-simple-if-or-isblank-formula","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-08-05T17:39:57+00:00","dateAnswered":"2020-08-05T15:34:38+00:00","acceptedAnswers":[]}},"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":70165,"type":"question","name":"Update triggered on completion of a subtask","excerpt":"Hi all, I need some help changing the status of an item to 100% when the first subtask for that Item in another sheet is completed. The working sheet has the following columns and I'm trying to update the \"Complete Percentage\" column The Target sheet has the following: So when the 1st subtask of \"General Arragement…","categoryID":322,"dateInserted":"2020-07-27T21:08:53+00:00","dateUpdated":null,"dateLastComment":"2020-08-05T17:37:56+00:00","insertUserID":124533,"insertUser":{"userID":124533,"name":"James Chestnut","url":"https:\/\/community.smartsheet.com\/profile\/James%20Chestnut","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xA9UscdVJno!XelWnyd6Ebo!sbGYRxU32c6","dateLastActive":"2020-12-08T14:23:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-08-19T18:57:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":95,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/70165\/update-triggered-on-completion-of-a-subtask","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70165\/update-triggered-on-completion-of-a-subtask","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/1E1T4CHEPR35\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-08-05T17:36:08+00:00","dateAnswered":"2020-07-30T10:26:52+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":70385,"type":"question","name":"COUNTIFS formula with a percentage but I need it to round up","excerpt":"Hi I am using this formula =COUNTIF({DA Audit Tracker Range 1}, \"Y\") \/ 273 * 100 + \"//www.santa-greenland.com/community/categories/formulas-and-functions/\" + \"%\" It is giving me the right % answer which in this case at the moment is 67.76557%. But I just want it to round up to two decimal places ..... how do I do that? Thanks Blayne","categoryID":322,"dateInserted":"2020-08-05T16:52:05+00:00","dateUpdated":null,"dateLastComment":"2020-08-05T17:37:27+00:00","insertUserID":124852,"insertUser":{"userID":124852,"name":"Blayne","url":"https:\/\/community.smartsheet.com\/profile\/Blayne","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xNDV8e9JLWY!!NoMCSdU_6YB","dateLastActive":"2020-08-05T17:35:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":124852,"lastUser":{"userID":124852,"name":"Blayne","url":"https:\/\/community.smartsheet.com\/profile\/Blayne","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xNDV8e9JLWY!!NoMCSdU_6YB","dateLastActive":"2020-08-05T17:35:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":277,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/70385\/countifs-formula-with-a-percentage-but-i-need-it-to-round-up","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70385\/countifs-formula-with-a-percentage-but-i-need-it-to-round-up","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-08-05T17:37:26+00:00","dateAnswered":"2020-08-05T17:35:03+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":70378,"type":"question","name":"COUNTIFS with 2 arguments","excerpt":"Hello, I want to count all the open tasks with are less than 1 week due, I have tried to =COUNTIF({Range 1}, \"Open\", {Range 2}, <7)), the reference sheet have Open and Range 2 has Days left, in number. But i am getting error incorrect argument. I am sure am doing something wrong. Thank you.","categoryID":322,"dateInserted":"2020-08-05T15:28:35+00:00","dateUpdated":null,"dateLastComment":"2020-08-05T16:43:07+00:00","insertUserID":124573,"insertUser":{"userID":124573,"name":"Manish Govindji","url":"https:\/\/community.smartsheet.com\/profile\/Manish%20Govindji","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-03-26T09:45: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-18T20:45:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":82,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/70378\/countifs-with-2-arguments","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70378\/countifs-with-2-arguments","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-08-05T18:11:12+00:00","dateAnswered":"2020-08-05T15:49:21+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":70380,"type":"question","name":"comparing two columns to find blanks","excerpt":"I was using countifs:field1,\"isnotblank\"@cell, field2,\"isblank\"@cell...that the jist of the formula. Am I on the right track? The columns are names and I need know when someone has entered a name in the \"Last\" field but not in the \"First\" field. Getting an \"unparceable\" error.","categoryID":322,"dateInserted":"2020-08-05T15:46:47+00:00","dateUpdated":null,"dateLastComment":"2020-08-05T16:29:09+00:00","insertUserID":114741,"insertUser":{"userID":114741,"name":"Storme Dunn","url":"https:\/\/community.smartsheet.com\/profile\/Storme%20Dunn","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-14T12:17:23+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-18T20:45:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":93,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/70380\/comparing-two-columns-to-find-blanks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70380\/comparing-two-columns-to-find-blanks","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-08-05T16:18:48+00:00","dateAnswered":"2020-08-05T15:59:15+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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