Formulas and Functions

Try: =IF([Daily Income]@row > Target@row, ([Daily Income]@row - Target@row) * 0.6)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":104626,"type":"question","name":"Formula to show total costs or TBD","excerpt":"Hi I am wondering if you can help me figure out a formula for my total cost coloumn. I need a formula that will total the section but if there is a \"TBD\" for a line item then instead of total numbers the top row just shows \"TBD\". So for this instead of show 19218.86 it would show TBD","categoryID":322,"dateInserted":"2023-04-28T17:29:26+00:00","dateUpdated":null,"dateLastComment":"2023-04-28T18:28:58+00:00","insertUserID":159377,"insertUser":{"userID":159377,"name":"abbey123","url":"https:\/\/community.smartsheet.com\/profile\/abbey123","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxY0JnL8LPZ9U2B3EHv1dOH36vkyoooTXv0xuE3-=s96-c","dateLastActive":"2023-04-28T18:25:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":143631,"lastUser":{"userID":143631,"name":"Dan W","url":"https:\/\/community.smartsheet.com\/profile\/Dan%20W","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ELNK7KGOI8EK\/n9ZGXA7RRPRGD.jpg","dateLastActive":"2023-04-28T18:25:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":24,"score":null,"hot":3365411304,"url":"https:\/\/community.smartsheet.com\/discussion\/104626\/formula-to-show-total-costs-or-tbd","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104626\/formula-to-show-total-costs-or-tbd","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":104626,"commentID":373747,"name":"Re: Formula to show total costs or TBD","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/373747#Comment_373747","dateInserted":"2023-04-28T18:28:58+00:00","insertUserID":143631,"insertUser":{"userID":143631,"name":"Dan W","url":"https:\/\/community.smartsheet.com\/profile\/Dan%20W","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ELNK7KGOI8EK\/n9ZGXA7RRPRGD.jpg","dateLastActive":"2023-04-28T18:25:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/6X4AHGW9Q55C\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-04-28T18:28:10+00:00","dateAnswered":"2023-04-28T18:25:27+00:00","acceptedAnswers":[{"commentID":373744,"body":"

This should work<\/p>

<\/p>

=IF(CONTAINS(\"TBD\", [Total column]1:[Total column]16), \"TBD\", SUM( [Total column]1:[Total column]16))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":104618,"type":"question","name":"Using ISBLANK with a checkbox cell","excerpt":"I'm trying to create a formula for my sheet that is counting a total number of items in the sheet within certain parameters, I've gotten the formula down for most of them but where I've run into issues is that my final formula either needs to be based on a column that is a checkbox OR if another column is NOT blank. The…","categoryID":322,"dateInserted":"2023-04-28T15:38:37+00:00","dateUpdated":"2023-04-28T15:45:57+00:00","dateLastComment":"2023-04-28T16:17:06+00:00","insertUserID":154905,"insertUser":{"userID":154905,"name":"Galadriel975","url":"https:\/\/community.smartsheet.com\/profile\/Galadriel975","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!knMqvzomcgo!3GtrPzY0BLo!ed-Utf2KUko","dateLastActive":"2023-04-28T18:54:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":154905,"lastUserID":154905,"lastUser":{"userID":154905,"name":"Galadriel975","url":"https:\/\/community.smartsheet.com\/profile\/Galadriel975","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!knMqvzomcgo!3GtrPzY0BLo!ed-Utf2KUko","dateLastActive":"2023-04-28T18:54:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":25,"score":null,"hot":3365396143,"url":"https:\/\/community.smartsheet.com\/discussion\/104618\/using-isblank-with-a-checkbox-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104618\/using-isblank-with-a-checkbox-cell","format":"Rich","tagIDs":[249,254],"lastPost":{"discussionID":104618,"commentID":373720,"name":"Re: Using ISBLANK with a checkbox cell","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/373720#Comment_373720","dateInserted":"2023-04-28T16:17:06+00:00","insertUserID":154905,"insertUser":{"userID":154905,"name":"Galadriel975","url":"https:\/\/community.smartsheet.com\/profile\/Galadriel975","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!knMqvzomcgo!3GtrPzY0BLo!ed-Utf2KUko","dateLastActive":"2023-04-28T18:54:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-04-28T16:17:11+00:00","dateAnswered":"2023-04-28T16:11:43+00:00","acceptedAnswers":[{"commentID":373718,"body":"

The ISBLANK should work, but generally I use slightly different syntax to say \"is checked\" or \"Is not checked\".<\/p>

<\/p>

Is checked<\/p>

@cell = 1<\/p>

<\/p>

Is not checked<\/p>

@cell <> 1<\/p>

<\/p>

=COUNTIFS({Range}, @cell = 1)<\/p>

=COUNTIFS({Range}, @cell <> 1)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":249,"urlcode":"Education","name":"Education"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">