欢迎来到Smartsheet论坛档案


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

不遵循的公式

丹尼尔·桑顿
丹尼尔·桑顿 ✭
编辑12/09/19 在2015年发布的文章

当我从web表单输入索赔时，它在我的工作表中显示得有点低，没有公式。当我有一个包含公式的行，然后我将其移动到具有相同列和公式的另一个工作表时也是这种情况，但它出现在底部行的后续工作表中，但没有公式。这是非常令人沮丧的，因为每次我移动一行或通过web表单接收索赔(行)时，我都必须不断复制公式。根据帮助文件，我知道有问题。请让我知道我做错了什么。非常感谢!

谢谢你！

丹尼尔·桑顿

标签:
· 在Facebook上分享 在Twitter上分享

评论

  • 特拉维斯
    特拉维斯 员工
    编辑04/28/15

    你好!这听起来和上周克里斯汀讨论的问题是一样的:https://community.smartsheet.com/discussion/row-gap-issue-web-form-entries

    只有当上面或下面的两行包含相同的公式时，才会在新行上自动填充公式。删除空白行应该解决您的公式问题。

    · 在Facebook上分享 在Twitter上分享
  • 丹尼尔·桑顿
    丹尼尔·桑顿 ✭

    你好,特拉维斯,

    感谢您的及时回复。不幸的是，我的问题到目前为止还没有解决。我试图删除所有的空白行，允许web表单插入我的新条目到最后一行，然而，当我移动到另一个工作表，我也删除了所有的空白行，我的公式仍然消失，我回到复制公式。我不确定哪个更糟糕，不断复制公式或反复删除空白行。在任何一种情况下，这都是一件持续的苦差事。

    尊重,

    丹尼尔·桑顿

    · 在Facebook上分享 在Twitter上分享
  • 特拉维斯
    特拉维斯 员工

    嗨，丹尼尔，这是很好的做法，删除一行，如果你完成了，而不是只是删除内容。如果您这样做，那么您就不必担心表单条目之间的空白行。您不必删除工作表末尾的所有行(这些是自动添加的“新”行)，而只需删除在某一点上包含数据的任何行。

    对于公式问题，在工作表之间移动行将剥离公式。但是，如果您通过突出显示单元格(不是行，只是行中的单元格)剪切或复制行内容，右键单击并选择复制或剪切，转到第二个工作表，右键单击空白行并选择粘贴，则公式将保持不变。

    · 在Facebook上分享 在Twitter上分享
  • 丹尼尔·桑顿
    丹尼尔·桑顿 ✭

    你好,特拉维斯,

    我想让表单填充在工作表的顶部，这样我就不用担心它在下面的位置它总是有公式。因为我在顶部创建了一个锁定的行。感谢你关于使用剪切和粘贴而不是移动的建议。我也会试试的!

    问候,

    丹尼尔

    · 在Facebook上分享 在Twitter上分享
这次讨论已经结束了。

类别

@Kirsteen Leckie<\/a> <\/p>

I made some tweaks to the formula, please try below<\/p>

=IF([Client review Required]@row = \"Yes\", IF([Actual Submit Date]@row = \"//www.santa-greenland.com/community/discussion/195/\", \"Pending\", (IF([Actual Compete date]@row = \"//www.santa-greenland.com/community/discussion/195/\", \"Internal Review\", (IF([Actual Date to Client]@row = \"//www.santa-greenland.com/community/discussion/195/\", \"Send To Client\", (IF([Actual Client comments]@row = \"//www.santa-greenland.com/community/discussion/195/\", \"Client Review\", (IF([Actual Piramal Response]@row = \"//www.santa-greenland.com/community/discussion/195/\", \"Addressing Comments\", (IF([Actual Final Client Approval]@row = \"//www.santa-greenland.com/community/discussion/195/\", \"Client Approval\", (IF([Actual submission to QA]@row = \"//www.santa-greenland.com/community/discussion/195/\", \"QA Review\", (IF([Actual Final or QA Approval]@row = \"//www.santa-greenland.com/community/discussion/195/\", \"QA Review\", \"Approved\"))))))))))))))), IF([Client review Required]@row = \"No\", IF([Actual Final or QA Approval]@row = \"//www.santa-greenland.com/community/discussion/195/\", \"QA Review\", \"Approved\")))\n<\/pre>"}]}},"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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":106601,"type":"question","name":"Please can someone help with this formula","excerpt":"I am trying to calculate how many \"qualification\" stages there are in a given fiscal period for example Q4-2023, I know I am missing something but every variation of Count if formulas I have tried do not seem to work, it will be something really simple, that I am trying to make to complicated, but any help will be…","categoryID":322,"dateInserted":"2023-06-19T15:46:15+00:00","dateUpdated":"2023-06-19T15:48:22+00:00","dateLastComment":"2023-06-19T15:54:15+00:00","insertUserID":150472,"insertUser":{"userID":150472,"name":"Mel C","url":"https:\/\/community.smartsheet.com\/profile\/Mel%20C","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T18:04:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":150472,"lastUserID":144360,"lastUser":{"userID":144360,"name":"Hollie Green","url":"https:\/\/community.smartsheet.com\/profile\/Hollie%20Green","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T22:11:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":28,"score":null,"hot":3374380230,"url":"https:\/\/community.smartsheet.com\/discussion\/106601\/please-can-someone-help-with-this-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106601\/please-can-someone-help-with-this-formula","format":"Rich","lastPost":{"discussionID":106601,"commentID":381177,"name":"Re: Please can someone help with this formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381177#Comment_381177","dateInserted":"2023-06-19T15:54:15+00:00","insertUserID":144360,"insertUser":{"userID":144360,"name":"Hollie Green","url":"https:\/\/community.smartsheet.com\/profile\/Hollie%20Green","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T22:11:33+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/MRW4VGYRA7HG\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-19T17:03:50+00:00","dateAnswered":"2023-06-19T15:54:15+00:00","acceptedAnswers":[{"commentID":381177,"body":"
It needs to be a countifs instead of countif<\/p>
=COUNTIFS([column4]2:[column4]5,\"Qualification\",[column5]2:[column5]5,\"Q4-2023\")<\/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":106596,"type":"question","name":"Changing a font in a dashboard","excerpt":"I have a dashboard using reports and metrics widgets, using sheet summaries and grid data, but the font is too large. How do I change that? In the screenshot, the red dot and the blue dot show the data that is coming from the grid data of a sheet. Is there any way of changing the font of the blue dot?","categoryID":321,"dateInserted":"2023-06-19T13:37:23+00:00","dateUpdated":"2023-06-19T13:49:50+00:00","dateLastComment":"2023-06-19T14:36:05+00:00","insertUserID":128842,"insertUser":{"userID":128842,"name":"Karen Bruer","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Karen%20Bruer","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5MPAuTrWZX4!elHDp9qhGX4!HMSKFvshvfI","dateLastActive":"2023-06-19T14:33:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":91566,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-06-20T04:02:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":52,"score":null,"hot":3374370208,"url":"https:\/\/community.smartsheet.com\/discussion\/106596\/changing-a-font-in-a-dashboard","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106596\/changing-a-font-in-a-dashboard","format":"Rich","lastPost":{"discussionID":106596,"commentID":381155,"name":"Re: Changing a font in a dashboard","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381155#Comment_381155","dateInserted":"2023-06-19T14:36:05+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-06-20T04:02:02+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/HHR250SXIUPY\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-19T14:35:02+00:00","dateAnswered":"2023-06-19T14:34:51+00:00","acceptedAnswers":[{"commentID":381154,"body":"
OMG, I didn't click on the widget box, now I see the edit option. Thanks so much, this is going to be a game changer for me!<\/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":[]}],"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":[]}">
             

               

                
热门文章

               

               
    
                
  • 有几个条件的公式
    嗨，我上周在做一个公式，但我仍然在努力解决这个问题的第二个标准。它的设置方式，根据输入的日期更新字段。它的工作原理如下:=IFERROR(IF([Client review Required]@row = "Yes"， IF([实际提交日期]@row = "" "Pending"， (IF([实际…]
    • 
                
  • 请问有人能帮我弄一下这个公式吗
    我试图计算有多少“资格”阶段有一个给定的财政期间，例如第四季度-2023年，我知道我错过了一些东西，但计数的每一个变化，如果我尝试过的公式似乎不起作用，这将是一些非常简单的东西，我试图使复杂，但任何帮助将是……
    • 
                
  • 在仪表板中更改字体
    我有一个使用报告和指标小部件的仪表板，使用表格摘要和网格数据，但是字体太大了。我该如何改变呢?在截图中，红点和蓝点表示来自工作表网格数据的数据。有办法改变蓝点的字体吗?
    •