smartshew.com\/discussion\/comment\/413096#很高兴它为您服务.++/p
下公式检查单元格[完成日期]@row为空,如果为空,它会预写公式,如果非空,它会弹出\"完成\"将单词[完成日期]替换为填全列名/p
=IF([Completed Date]@row=\"\",NETWORKDAYS([DATE RECIVED FROM PLANNER]@row, (TODAY())),\"Completed\")<\/p>
You can replace the word at the very end in quotes \"Completed\" with whatever you want it to say or make it blank with \"\"<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","description":"Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":["discussion","question"]},"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":[]},{"discussionID":115470,"type":"question","name":"Remove duplicates from a row?","excerpt":"Is there a way to remove duplicate zip codes in a row of columns so only unique zip codes will be available when I concatenate them all into a combined zip code column?例子:如果我有四列拉链代码和第一栏和第四栏重复,我只要显示第一栏Zip代码一次,当我合并所有列时...snippeExample:…","categoryID":322,"dateInserted":"2024-01-11T16:10:58+00:00","dateUpdated":"2024-01-11T16:22:56+00:00","dateLastComment":"2024-01-11T19:41:11+00:00","insertUserID":148855,"insertUser":{"userID":148855,"name":"cabbsman","url":"https:\/\/community.smartsheet.com\/profile\/cabbsman","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!88cq90f5xTs!8sDpd7uL9Ps!kj4X4avpgGN","dateLastActive":"2024-01-11T19:44:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":148855,"lastUserID":172637,"lastUser":{"userID":172637,"name":"John Shane","title":"General Manager","url":"https:\/\/community.smartsheet.com\/profile\/John%20Shane","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/G28IW003LKK0\/nFWA215YFY9BT.jpg","dateLastActive":"2024-01-12T00:30:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":37,"score":null,"hot":3409993329,"url":"https:\/\/community.smartsheet.com\/discussion\/115470\/remove-duplicates-from-a-row","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/115470\/remove-duplicates-from-a-row","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":115470,"commentID":413115,"name":"Re: Remove duplicates from a row?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/413115#Comment_413115","dateInserted":"2024-01-11T19:41:11+00:00","insertUserID":172637,"insertUser":{"userID":172637,"name":"John Shane","title":"General Manager","url":"https:\/\/community.smartsheet.com\/profile\/John%20Shane","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/G28IW003LKK0\/nFWA215YFY9BT.jpg","dateLastActive":"2024-01-12T00:30:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"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\/PQRKD9GWVV5D\/image.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/PQRKD9GWVV5D\/image.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/PQRKD9GWVV5D\/image.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/PQRKD9GWVV5D\/image.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/PQRKD9GWVV5D\/image.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/PQRKD9GWVV5D\/image.png"},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2024-01-11T18:00:04+00:00","dateAnswered":"2024-01-11T17:34:29+00:00","acceptedAnswers":[{"commentID":413083,"body":"
