总浮动问题

伊恩第九
伊恩第九 ✭✭✭✭✭✭
在公式和函数

你好,

我在掌握totalfloat()函数的窍门方面遇到了麻烦。

首先，我的许多任务返回的总浮点值都是负数。这似乎与开始到结束函数有关，但我不知道如何解释它，或者这只是无意义的数据:

image.png

此外，在许多情况下，当一个任务距离成为关键路径只有一天时，它的浮点数不是1，而是一些疯狂的东西，比如-58天成为关键路径。然后当它变成关键路径时，它下降到零，而原始的关键路径跳到另一个大的负数。

如有任何见解，将不胜感激。

伊恩

· 在Facebook上分享 在Twitter上分享

答案

  • 吉纳维芙P。
    吉纳维芙P。 员工管理
    编辑04/13/22

    嗨@Ian第九

    TOTALFLOAT是一个相当新的函数，所以我实际上不确定当使用自定义的前任链接时，预期的功能是什么。

    我可以复制您在SF前任中看到的情况:它将当前任务结束到前任任务结束的时间视为负的浮动时间，尽管事实并非如此。我建议联系支持这样他们就可以研究和确认这个函数的预期行为。这将有助于他们看到您的表的完整屏幕捕获与前任列充分显示和行编号，以便他们可以复制这，太。

    欢呼,

    吉纳维芙

    · 在Facebook上分享 在Twitter上分享
  • B.Kirk
    B.Kirk ✭

    很有可能你正在使用延迟，这是混乱的浮点计算;)消除创造性任务的延迟，你应该会很好!希望这个有帮助。

    · 在Facebook上分享 在Twitter上分享

帮助文章资源欧宝体育app官方888

在Smartsheet中创建和编辑公式

交叉表引用的公式组合

内容功能列表

类别

@Vane<\/a> <\/p>

If you only want to add those if the Status is Approved, you'd use this formula:<\/p>

=SUMIFS([Approved Change Order Amount.]:[Approved Change Order Amount.], Category:Category, CONTAINS(\"Regulatory Submissions\", @cell), Status:Status, \"Approved\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-21 21:33:13","updateUser":{"userID":154015,"name":"Vane","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Vane","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-21T22:08:16+00:00","banned":0,"punished":0,"private":true,"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":96887,"type":"question","name":"Help with COUNTIF","excerpt":"Currently I am counting the number of rows assigned to a particular person using a separate sheet. Currently it counts every row based on the value of the adjacent column. The current entry in the cell that displays the count is =COUNTIF({Sheet - Request Tracker Range 9}, Category26). I need to be able to count the number…","categoryID":322,"dateInserted":"2022-10-21T17:48:50+00:00","dateUpdated":null,"dateLastComment":"2022-10-21T17:59:27+00:00","insertUserID":154002,"insertUser":{"userID":154002,"name":"SmartSheet Newbie","url":"https:\/\/community.smartsheet.com\/profile\/SmartSheet%20Newbie","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu1VcnmvyGv6lWBPJmcBlo2-f4c9qfr0HlrcGUdo=s96-c","dateLastActive":"2022-10-21T18:00:34+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":"2022-10-21T17:57:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":15,"score":null,"hot":3332750297,"url":"https:\/\/community.smartsheet.com\/discussion\/96887\/help-with-countif","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96887\/help-with-countif","format":"Rich","lastPost":{"discussionID":96887,"commentID":348294,"name":"Re: Help with COUNTIF","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348294#Comment_348294","dateInserted":"2022-10-21T17:59:27+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":"2022-10-21T17:57:45+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-10-21T18:04:48+00:00","dateAnswered":"2022-10-21T17:59:27+00:00","acceptedAnswers":[{"commentID":348294,"body":"

You would switch over to a COUNTIFS to include multiple range\/criteria sets, include the new range, and then include the new criteria.<\/p>

=COUNTIFS<\/strong>({Sheet - Request Tracker Range 9}, Category26, {New Range}, AND(@cell <> \"Closed\", @cell <> \"Cancelled\")<\/strong>)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-21 18:04:48","updateUser":{"userID":154002,"name":"SmartSheet Newbie","url":"https:\/\/community.smartsheet.com\/profile\/SmartSheet%20Newbie","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu1VcnmvyGv6lWBPJmcBlo2-f4c9qfr0HlrcGUdo=s96-c","dateLastActive":"2022-10-21T18:00:34+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":96877,"type":"question","name":"Cross Reference","excerpt":"Can you have some rows reference one column in a sheet and other rows reference a different column in the same sheet? It seems like I am getting a message that when I reference a column all 1000+ cells are changed to that reference, but I have 26 rows I want to point to a different column. Do I have to relocate them to…","categoryID":322,"dateInserted":"2022-10-21T15:21:09+00:00","dateUpdated":null,"dateLastComment":"2022-10-21T18:04:50+00:00","insertUserID":141122,"insertUser":{"userID":141122,"name":"Amy Swan","url":"https:\/\/community.smartsheet.com\/profile\/Amy%20Swan","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!m4nQn5jNYzw!!MnaATF4cmro","dateLastActive":"2022-10-21T22:06:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":141122,"lastUser":{"userID":141122,"name":"Amy Swan","url":"https:\/\/community.smartsheet.com\/profile\/Amy%20Swan","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!m4nQn5jNYzw!!MnaATF4cmro","dateLastActive":"2022-10-21T22:06:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":32,"score":null,"hot":3332743559,"url":"https:\/\/community.smartsheet.com\/discussion\/96877\/cross-reference","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96877\/cross-reference","format":"Rich","lastPost":{"discussionID":96877,"commentID":348298,"name":"Re: Cross Reference","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348298#Comment_348298","dateInserted":"2022-10-21T18:04:50+00:00","insertUserID":141122,"insertUser":{"userID":141122,"name":"Amy Swan","url":"https:\/\/community.smartsheet.com\/profile\/Amy%20Swan","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!m4nQn5jNYzw!!MnaATF4cmro","dateLastActive":"2022-10-21T22:06:22+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-10-21T18:05:00+00:00","dateAnswered":"2022-10-21T17:52:54+00:00","acceptedAnswers":[{"commentID":348289,"body":"

Ok. So it sounds like you are clicking on \"Edit Reference\". Instead... Highlight the entire reference so that the cross sheet link in the formula helper box reads \"Reference another Sheet\". Then try selecting the new column from your source sheet.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-21 18:05:00","updateUser":{"userID":141122,"name":"Amy Swan","url":"https:\/\/community.smartsheet.com\/profile\/Amy%20Swan","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!m4nQn5jNYzw!!MnaATF4cmro","dateLastActive":"2022-10-21T22:06:22+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":[]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">