耶!智能表单中的文本格式

2»

评论

类别

@chooley<\/a> If you are getting #REF I believe you will unfortunately have to redo everything. I don't quite understand how your intake sheet is set up but definitely lock that row too when you are done. <\/p>

If by \"Project ID is a protected field\" you mean that column is an autonumber system column... you could change the column type to text, put in the project numbers you want for whatever row, and then change it back to an auto number. It will keep the number you entered and continue where it left off (you might have to tell it which number to start at when you switch it back). However this won't fix your #REF problem.<\/p>"},{"commentID":355717,"body":"

Hi @chooley<\/a> <\/p>

I hope you're well and safe!<\/p>

If you turn off the Autonumbering and then add a new row at the top with the information manually or use the Request Snapshot feature to paste the information back on that new row, it should work (I think).<\/p>

Did that work\/help? <\/p>

I hope that helps!<\/p>

Have a fantastic week & Happy New Year!<\/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","log":{"dateUpdated":"2023-01-03 18:32:37","updateUser":{"userID":156412,"name":"chooley","url":"https:\/\/community.smartsheet.com\/profile\/chooley","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!259vf8ZI4vI!unDmp3-Skvo!RO65iWGdrJu","dateLastActive":"2023-01-03T18:49:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]},{"discussionID":99208,"type":"question","name":"Creating Forms","excerpt":"I am trying to create a form where each time I receive information I input it on the form, then send the form to someone else to have more information input on the exact same form. Is this possible?","categoryID":321,"dateInserted":"2023-01-03T16:12:45+00:00","dateUpdated":null,"dateLastComment":"2023-01-03T16:29:48+00:00","insertUserID":156414,"insertUser":{"userID":156414,"name":"lakshe","url":"https:\/\/community.smartsheet.com\/profile\/lakshe","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-03T16:46:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":86866,"lastUser":{"userID":86866,"name":"Jeff Reisman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Reisman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3V8W2AM105QE\/nIDXI4I7VDS7W.JPG","dateLastActive":"2023-01-03T22:27:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":24,"score":null,"hot":3345526353,"url":"https:\/\/community.smartsheet.com\/discussion\/99208\/creating-forms","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99208\/creating-forms","format":"Rich","lastPost":{"discussionID":99208,"commentID":355711,"name":"Re: Creating Forms","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/355711#Comment_355711","dateInserted":"2023-01-03T16:29:48+00:00","insertUserID":86866,"insertUser":{"userID":86866,"name":"Jeff Reisman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Reisman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3V8W2AM105QE\/nIDXI4I7VDS7W.JPG","dateLastActive":"2023-01-03T22:27:29+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-01-03T16:49:30+00:00","dateAnswered":"2023-01-03T16:29:48+00:00","acceptedAnswers":[{"commentID":355711,"body":"

@lakshe<\/a> Yes, this is possible, in a roundabout way. <\/p>

To do this, you'll want to create a workflow automation that is triggered by adding a new row, which sends an update form to the next user. When creating the automation, you designate which data columns the next user should have on their update form. <\/p>

Here's a link to some help on working with update requests:<\/p>

https:\/\/help.smartsheet.com\/learning-track\/smartsheet-intermediate\/update-requests<\/a><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-03 16:49:30","updateUser":{"userID":156414,"name":"lakshe","url":"https:\/\/community.smartsheet.com\/profile\/lakshe","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-03T16:46:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]},{"discussionID":99172,"type":"question","name":"Automation Workflows to add multiple Multi-Select field values","excerpt":"Is it possible to have multiple automation workflows that will simultaneously or sequentially process to add multiple values into a single cell? Here's my scenario. I've got data that gets entered into a sheet that has the potential to be missing elements. The hope is that my users will correct those gaps, but once…","categoryID":321,"dateInserted":"2022-12-30T20:05:37+00:00","dateUpdated":null,"dateLastComment":"2023-01-03T11:18:10+00:00","insertUserID":121055,"insertUser":{"userID":121055,"name":"Jake Gustafson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jake%20Gustafson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-lnW91tuGTw!bO9UmyNQSXQ!WUYBUm0HF6t","dateLastActive":"2023-01-03T21:51:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2023-01-03T18:04:49+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":31,"score":null,"hot":3345176627,"url":"https:\/\/community.smartsheet.com\/discussion\/99172\/automation-workflows-to-add-multiple-multi-select-field-values","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99172\/automation-workflows-to-add-multiple-multi-select-field-values","format":"Rich","tagIDs":[334],"lastPost":{"discussionID":99172,"commentID":355673,"name":"Re: Automation Workflows to add multiple Multi-Select field values","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/355673#Comment_355673","dateInserted":"2023-01-03T11:18:10+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2023-01-03T18:04:49+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/BGBF7435OPL6\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-01-03T14:04:24+00:00","dateAnswered":"2022-12-30T20:14:41+00:00","acceptedAnswers":[{"commentID":355610,"body":"

Alright, I think I figured it out. I had three separate automation workflows looking at the same field. I put that into one workflow with multiple condition paths and it looks to be working as expected. The other issue was a bad trigger. Guess I just needed to write it out to you all. Thanks for the support.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-03 14:04:24","updateUser":{"userID":121055,"name":"Jake Gustafson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jake%20Gustafson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-lnW91tuGTw!bO9UmyNQSXQ!WUYBUm0HF6t","dateLastActive":"2023-01-03T21:51:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}}},"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"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">