文本到不同的行-按分隔符分隔。
答案
-
保罗新来的 ✭✭✭✭✭✭ -
芭芭拉·T。 ✭
是的!
这就是我一直在做的(和努力lol)。
-
保罗新来的 ✭✭✭✭✭✭
@Barbara T。看起来您只需要在find函数后面加上一个“-1”来去掉逗号。
=IFERROR(LEFT([assign To]#， FIND(CHAR(10)， [assign To]#)－ 1)，[分配到]#)
第二个抛出错误的公式。你好像放错了括号。您过早地关闭了RIGHT函数，并且忘记在单元格引用之后关闭LEN函数。如果您在第一个[Primary Column]1之后使用右括号，并将其移动到第二个之后，则应该可以消除该错误。
thinkspi.com
-
芭芭拉·T。 ✭
-
保罗新来的 ✭✭✭✭✭✭
@Barbara T。看起来您将FIND函数中的单元格引用更改为[Column2]。现在我们已经从单元格中删除了逗号，FIND函数输出一个零。LEN - 0 = LEN，这意味着我们让它拉所有东西。如果您在[Primary Column]中搜索逗号，就可以了。
thinkspi.com
-
芭芭拉·T。 ✭
-
保罗新来的 ✭✭✭✭✭✭
类别
Hi @moraki<\/a> <\/p> There currently isn't a way to remove the Reply button or the reply-to email function for @mentions in Smartsheet. (Here's the Help Article on this functionality: Using @mentions in comments<\/a>)<\/p> Please submit your feature request to the Product team by creating an Idea Post<\/strong> in the Smartsheet Product Feedback and Ideas topic<\/a> here in the Community. This will allow other users to vote on your enhancement idea!<\/p> Cheers,<\/p> Genevieve<\/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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":441,"urlcode":"comments-and-conversations","name":"Comments and Conversations"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}]},{"discussionID":106398,"type":"question","name":"Is there a way to send a multiple-row update request that allows multiple (as-you-go) submissions?","excerpt":"New user and new to the community. Trying to figure out if there's a way to send a multiple-row update request that allows the requestee to submit one row update at a time, save along the way, and\/or use the update request link multiple times vs. the requestee having to provide every row update before clicking submit.…","categoryID":321,"dateInserted":"2023-06-13T20:49:40+00:00","dateUpdated":null,"dateLastComment":"2023-06-14T15:59:53+00:00","insertUserID":162342,"insertUser":{"userID":162342,"name":"mgreenwalt","title":"coordinator","url":"https:\/\/community.smartsheet.com\/profile\/mgreenwalt","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T15:22:47+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-06-15T15:29:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":46,"score":null,"hot":3373449573,"url":"https:\/\/community.smartsheet.com\/discussion\/106398\/is-there-a-way-to-send-a-multiple-row-update-request-that-allows-multiple-as-you-go-submissions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106398\/is-there-a-way-to-send-a-multiple-row-update-request-that-allows-multiple-as-you-go-submissions","format":"Rich","tagIDs":[446],"lastPost":{"discussionID":106398,"commentID":380525,"name":"Re: Is there a way to send a multiple-row update request that allows multiple (as-you-go) submissions?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380525#Comment_380525","dateInserted":"2023-06-14T15:59:53+00:00","insertUserID":8888,"insertUser":{"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-06-15T15:29:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-14T15:22:45+00:00","dateAnswered":"2023-06-13T22:19:44+00:00","acceptedAnswers":[{"commentID":380402,"body":" Hi @mgreenwalt<\/a> <\/p> I hope you're well and safe!<\/p> Here's a possible workaround or workarounds <\/strong><\/p> Would any of those options work\/help? <\/p> I hope that helps!<\/p> Be safe, and have a fantastic week!<\/p> Best,<\/p> Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/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":446,"urlcode":"update-requests","name":"Update Requests"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=341&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":5378,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
