Web Forms和Dropbox
我可以将web表单保存到共享Dropbox文件夹中，以便我的客户端可以访问它吗?他们总是把链接弄丢，让我重发。我怎样才能避免这种情况的发生
评论
-
Alina安德森 员工您的客户是否需要定期通过网络表格提交信息?也许他们可以在浏览器栏中将链接收藏起来，以便在需要的时候方便地找到它。
-
Jaye Casciano ✭✭✭✭✭✭就像Alina说的，书签可能是最好的选择。这是我们的同事在组织中定期需要表单时所做的事情。
类别
Please try this - presuming you are inserting the formula on rows 13-15 in the Total column of your screenshot:<\/p>
=SUMIFS(Total$2:Total$9, Variable$2:Variable$9, CONTAINS(Variable@row, @cell))<\/p>
Hope this helps!<\/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":106200,"type":"question","name":"How do I automatically calculate a due date based on the timeframe a form has been submitted?","excerpt":"Some background: I receive requests for funding through a form that then auto-populates into my sheet. On the first of every month, 3 individuals receive an email notifying them that the applications from the previous month are available for review. The due date to review them is the one week from the day they get the…","categoryID":322,"dateInserted":"2023-06-08T14:51:16+00:00","dateUpdated":null,"dateLastComment":"2023-06-08T15:36:26+00:00","insertUserID":162194,"insertUser":{"userID":162194,"name":"Faith","url":"https:\/\/community.smartsheet.com\/profile\/Faith","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxYH2KVOSzmj2vhmfD_q8s6DrUSZWCbalNMPPcnr=s96-c","dateLastActive":"2023-06-08T15:35:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162194,"lastUser":{"userID":162194,"name":"Faith","url":"https:\/\/community.smartsheet.com\/profile\/Faith","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxYH2KVOSzmj2vhmfD_q8s6DrUSZWCbalNMPPcnr=s96-c","dateLastActive":"2023-06-08T15:35:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":30,"score":null,"hot":3372476862,"url":"https:\/\/community.smartsheet.com\/discussion\/106200\/how-do-i-automatically-calculate-a-due-date-based-on-the-timeframe-a-form-has-been-submitted","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106200\/how-do-i-automatically-calculate-a-due-date-based-on-the-timeframe-a-form-has-been-submitted","format":"Rich","lastPost":{"discussionID":106200,"commentID":379633,"name":"Re: How do I automatically calculate a due date based on the timeframe a form has been submitted?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379633#Comment_379633","dateInserted":"2023-06-08T15:36:26+00:00","insertUserID":162194,"insertUser":{"userID":162194,"name":"Faith","url":"https:\/\/community.smartsheet.com\/profile\/Faith","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxYH2KVOSzmj2vhmfD_q8s6DrUSZWCbalNMPPcnr=s96-c","dateLastActive":"2023-06-08T15:35:58+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-08T15:35:54+00:00","dateAnswered":"2023-06-08T15:30:29+00:00","acceptedAnswers":[{"commentID":379622,"body":"
Ok. SO the 7th of the month after submission would look something like this (in a Date type column):<\/p>
=DATE(YEAR([Submission Date]@row) + IF(MONTH([Submission Date]@row) = 12, 1, 0), IF(MONTH([Submission Date]@row) = 12, 1, MONTH([Submission Date]@row) + 1), 7)<\/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":106193,"type":"question","name":"Multiple Forms, One Smartsheet","excerpt":"I created two identical forms (except for the name) and both of them populated into the same smartsheet. Is there a way to only see one form's submissions?","categoryID":321,"dateInserted":"2023-06-08T13:28:04+00:00","dateUpdated":null,"dateLastComment":"2023-06-08T13:47:26+00:00","insertUserID":152102,"insertUser":{"userID":152102,"name":"AllieB","url":"https:\/\/community.smartsheet.com\/profile\/AllieB","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T13:49:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":66106,"lastUser":{"userID":66106,"name":"Peggy Parchert","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Peggy%20Parchert","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/YYRDMWWFX83G\/nC7HLGW82ACPT.jpg","dateLastActive":"2023-06-08T16:12:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":41,"score":null,"hot":3372467730,"url":"https:\/\/community.smartsheet.com\/discussion\/106193\/multiple-forms-one-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106193\/multiple-forms-one-smartsheet","format":"Rich","lastPost":{"discussionID":106193,"commentID":379551,"name":"Re: Multiple Forms, One Smartsheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379551#Comment_379551","dateInserted":"2023-06-08T13:47:26+00:00","insertUserID":66106,"insertUser":{"userID":66106,"name":"Peggy Parchert","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Peggy%20Parchert","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/YYRDMWWFX83G\/nC7HLGW82ACPT.jpg","dateLastActive":"2023-06-08T16:12:58+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-08T13:46:06+00:00","dateAnswered":"2023-06-08T13:44:25+00:00","acceptedAnswers":[{"commentID":379548,"body":"
