欢迎来到Smartsheet论坛档案


在这个论坛的帖子不再被监控的准确性和他们的内容可能不再是最新的。如果这里有你感兴趣的讨论,你想找到(或创建)一个更最新的版本,请访问当前论坛。

每个web表单提交10个文件

我们正在使用webform功能从我们的承包商那里收集文件,有两件事阻碍了这个过程:

1.你一次只能上传一个文件,而不是点击“上传”,然后选择多个文件

2.每个webform最多只能有10个文件

有人有什么建议吗?

标签:

评论

这次讨论已经结束了。
Try specifying an exact match within the MATCH function.<\/p>

=INDEX({Data SHPType}, MATCH(Course@row, {Data Course}, 0<\/strong>))<\/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":[]},{"discussionID":106455,"type":"question","name":"Formula to count items in a cell separated by a semicolon","excerpt":"Good afternoon, could someone help me with a formula to count items in a cell separated by a semicolon and put the total in another? I have a column called: \"MRA Actives codes\", in which there are different medical codes separated by a semicolon, for example: I70.0: Atherosclerosis of aorta; I50.9: Heart failure…","categoryID":322,"dateInserted":"2023-06-14T19:20:24+00:00","dateUpdated":null,"dateLastComment":"2023-06-15T11:46:15+00:00","insertUserID":162381,"insertUser":{"userID":162381,"name":"VirginiaLazor","title":"Medical Risk Adjustment Auditor","url":"https:\/\/community.smartsheet.com\/profile\/VirginiaLazor","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!b1Dom3_UQfo!xekpcXON8bo!9w33zAjZR8S","dateLastActive":"2023-06-15T12:10:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-15T12:44:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":41,"score":null,"hot":3373603599,"url":"https:\/\/community.smartsheet.com\/discussion\/106455\/formula-to-count-items-in-a-cell-separated-by-a-semicolon","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106455\/formula-to-count-items-in-a-cell-separated-by-a-semicolon","format":"Rich","lastPost":{"discussionID":106455,"commentID":380725,"name":"Re: Formula to count items in a cell separated by a semicolon","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380725#Comment_380725","dateInserted":"2023-06-15T11:46:15+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-15T12:44:43+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-06-15T12:03:29+00:00","dateAnswered":"2023-06-15T11:44:52+00:00","acceptedAnswers":[{"commentID":380724,"body":"

Hi @VirginiaLazor<\/a>,<\/p>

This should do the trick:<\/p>

=LEN([MRA ACTIVES CODES]@row) - LEN(SUBSTITUTE([MRA ACTIVES CODES]@row, \";\", \"//www.santa-greenland.com/community/discussion/7121/\"))<\/p>

This calculates the length of the MRA codes cell, then does the same if the semi-colons were removed and subtracts it to get the answer on how many of them there were.<\/p>

Hope this helps - if you have any issues then just post! 😊<\/span><\/p>"},{"commentID":380725,"body":"

If you remove the semi-colons and subtract that character count from the total character count WITH the semi-colons, that will tell you how many entries are in the cell.<\/p>


<\/p>

=LEN(Column Name]@row) - LEN(SUBSTITUTE([Column name]@row, \";\", \"//www.santa-greenland.com/community/discussion/7121/\"))<\/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":[]},{"discussionID":106453,"type":"question","name":"Row Status Indicator in Schedule","excerpt":"Wrote a formula to check two items and change and indicator light. Here is the code but it is saying incorrect argument set? =IF(Status@row <> \"Complete\", [Due Date]@row < TODAY(), \"Red\", IF(Status@row <> \"Complete\", [Due Date]@row >= TODAY(2), \"Yellow\", \"Green\")) I have reviewed everything multiple times and cannot figure…","categoryID":322,"dateInserted":"2023-06-14T19:15:28+00:00","dateUpdated":null,"dateLastComment":"2023-06-15T10:03:13+00:00","insertUserID":162256,"insertUser":{"userID":162256,"name":"delaurellc","title":"Senior Consultant","url":"https:\/\/community.smartsheet.com\/profile\/delaurellc","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T22:59:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-15T12:58:48+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":18,"score":null,"hot":3373594721,"url":"https:\/\/community.smartsheet.com\/discussion\/106453\/row-status-indicator-in-schedule","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106453\/row-status-indicator-in-schedule","format":"Rich","lastPost":{"discussionID":106453,"commentID":380712,"name":"Re: Row Status Indicator in Schedule","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380712#Comment_380712","dateInserted":"2023-06-15T10:03:13+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-15T12:58:48+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"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-06-15T10:03:03+00:00","dateAnswered":"2023-06-14T22:55:59+00:00","acceptedAnswers":[{"commentID":380684,"body":"

I figured out the code and here it is in case anyone is trying to do the same thing<\/p>

=IF(AND([Due Date]@row < TODAY(), Status@row <> \"Complete\"), \"Red\", IF(AND([Due Date]@row = TODAY(2), Status@row <> \"Complete\"), \"Yellow\", \"Green\"))<\/p>

Caroline<\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&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":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

热门文章