2017年发布的文章

<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":334,"urlcode":"automations","name":"Automations"}]},{"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":29,"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"}]}],"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">