表单响应是跳过表单上的行
最好的答案
-
马克要崩溃的 ✭✭✭✭✭✭
我与同样的挣扎,但发现,随着床单增加行差距变小。现在,删除新记录和上一个记录之间的行。只要你的自动号码还能用,这只是一个格式问题。
另一种方法是将新行贴到顶部。你不会有差距的。
马克
我很感激你的“投票赞成”或“见解深刻”。谢谢你对社区的贡献。
0 -
马克要崩溃的 ✭✭✭✭✭✭
嗨,史黛西,
这只是个人喜好,但为了帮助管理新记录,我在我的表格底部插入了一个彩色行,并在一个不会影响计算的文本列中将其标记为“新记录以下”。它是一个可视分隔符,可以让我立即识别新行。作为例行维护的一部分,我剪切并粘贴我的行上面的新行,并删除任何空白行。
感谢您对社区的贡献。
马克
我很感激你的“投票赞成”或“见解深刻”。谢谢你对社区的贡献。
1
答案
-
马克要崩溃的 ✭✭✭✭✭✭
我与同样的挣扎,但发现,随着床单增加行差距变小。现在,删除新记录和上一个记录之间的行。只要你的自动号码还能用,这只是一个格式问题。
另一种方法是将新行贴到顶部。你不会有差距的。
马克
我很感激你的“投票赞成”或“见解深刻”。谢谢你对社区的贡献。
0 -
史黛西Maplesden ✭✭✭✭✭✭
有趣。谢谢@Mark假冒的来确认不是我干的我不确定是我错过了一个设置,还是在设置的形式中有其他的东西。有相当多的人在处理问题,所以我希望能有一个解决方案。不过,这是可控的。也许在某个时候它会被固定。
再次感谢!
史黛西
0 -
马克要崩溃的 ✭✭✭✭✭✭
嗨,史黛西,
这只是个人喜好,但为了帮助管理新记录,我在我的表格底部插入了一个彩色行,并在一个不会影响计算的文本列中将其标记为“新记录以下”。它是一个可视分隔符,可以让我立即识别新行。作为例行维护的一部分,我剪切并粘贴我的行上面的新行,并删除任何空白行。
感谢您对社区的贡献。
马克
我很感激你的“投票赞成”或“见解深刻”。谢谢你对社区的贡献。
1 -
巴里·代顿 ✭
我也有同样的问题。从这个帖子开始到现在已经一年多了。
0 -
GraesonG ✭
我有同样的问题,但当我检查空白行属性,它规定它是由用户创建的。
用户否认这样做,它也显示在活动日志。
0
帮助文章资源欧宝体育app官方888
类别
I hope you're well and safe!<\/p>
Unfortunately, adding a formula using a Workflow is not possible now, but it's an excellent idea!<\/p>
Please submit this as a Product Feedback or Idea <\/strong>(If it hasn't been added already)<\/em><\/strong> when you have a moment.<\/strong><\/a><\/p> Here's a possible workaround or workarounds <\/strong><\/p> Would that work\/help? <\/p> I hope that helps!<\/p> Be safe, and have a fantastic weekend!<\/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":"2022-09-23 11:02:53","updateUser":{"userID":152771,"name":"Brandon Austin","url":"https:\/\/community.smartsheet.com\/profile\/Brandon%20Austin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-23T13:16:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":95833,"type":"question","name":"SumIFS Formula Issue","excerpt":"Hi I need to count the number of total Artefacts if the Process column equals one of four process options. I'm doing this calculation in the Sheet Summary function and I've followed the help guide to set up the formula but I'm still having issues. Here is what I have: =SUMIFS(Total # of Artefacts:Total # of…","categoryID":322,"dateInserted":"2022-09-23T01:55:10+00:00","dateUpdated":null,"dateLastComment":"2022-09-23T03:29:27+00:00","insertUserID":152210,"insertUser":{"userID":152210,"name":"Michelle McN","url":"https:\/\/community.smartsheet.com\/profile\/Michelle%20McN","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-23T06:24:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":152210,"lastUser":{"userID":152210,"name":"Michelle McN","url":"https:\/\/community.smartsheet.com\/profile\/Michelle%20McN","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-23T06:24:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":26,"score":null,"hot":3327804277,"url":"https:\/\/community.smartsheet.com\/discussion\/95833\/sumifs-formula-issue","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95833\/sumifs-formula-issue","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":95833,"commentID":344513,"name":"Re: SumIFS Formula Issue","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/344513#Comment_344513","dateInserted":"2022-09-23T03:29:27+00:00","insertUserID":152210,"insertUser":{"userID":152210,"name":"Michelle McN","url":"https:\/\/community.smartsheet.com\/profile\/Michelle%20McN","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-23T06:24:23+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":"2022-09-23T13:40:55+00:00","dateAnswered":"2022-09-23T03:24:49+00:00","acceptedAnswers":[{"commentID":344512,"body":" @Michelle McN<\/a> Ahh, I should have checked the syntax before answering. You are missing the first range that you want to sum.<\/p>