Total Float Issues
Hello,
I'm having trouble getting the hang of the totalfloat() function.
For one thing, many of my tasks are returning with a negative total float value. It seems to be related to the start-to-finish function, but I don't know how to interpret this, or if it's just nonsense data:
Additionally, there are many cases where when a task is one day from being critical path, its float is not 1, but something crazy like -58 days from being critical path. Then when it becomes critical path, it shoots down to zero, and the original critical path jumps to some other large negative number.
Any insight would be appreciated.
Ian
Answers
-
Genevieve P. Employee AdminHi@Ian Ix
TOTALFLOAT is a fairly new function so I'm not actually sure what the intended functionality is when used with custom Predecessor links.
I can replicate what you're seeing with SF predecessors: it sees the time from when the current task ends to when the Predecessor task ends as negative float time, even though it's not. I would recommendcontacting Supportso that they can investigate and confirm the intended behaviour of this function. It would be helpful for them to see full screen captures of you sheet with the Predecessor column fully showing and row numbers so they can replicate this, too.
Cheers,
Genevieve
-
B.Kirk ✭Theres a good chance you are using lag, and that is messing up the float calculations ;) Eliminate lag with creative tasks and you should be good to go! Hope this helps.
Help Article Resources
Categories
=VLOOKUP(INDEX(Code:Code, 1)<\/strong>, {Cross Sheet Reference}, .......)<\/p>"},{"commentID":390435,"body":" Try using INDEX(Code:Code, 1) instead of $Code$1<\/p> Note: Also, I would recommend you use INDEX\/MATCH instead of VLOOKUP. Much more reliable.<\/p> I hope this helps you.<\/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":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":108902,"type":"question","name":"Average with criteria","excerpt":"Hi I need some help regarding making an average. There is multiple rows with the text \"Mekanisk\" in it at \"System\" column, and a corresponding \"%\" at the \"Fullført\" colum. How do I make an average of all these uniqe % values? Thank's! :)","snippet":"Hi I need some help regarding making an average. There is multiple rows with the text \"Mekanisk\" in it at \"System\" column, and a corresponding \"%\" at the \"Fullført\" colum. How do…","categoryID":322,"dateInserted":"2023-08-14T09:59:21+00:00","dateUpdated":null,"dateLastComment":"2023-08-14T10:52:15+00:00","insertUserID":165045,"insertUser":{"userID":165045,"name":"TorAtle Myrmel","title":"Planner","url":"https:\/\/community.smartsheet.com\/profile\/TorAtle%20Myrmel","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!DsVQA8BS3SQ!clfQx3iu-bw!1fQKS1hybet","dateLastActive":"2023-08-14T12:26:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":151203,"lastUser":{"userID":151203,"name":"Nick Korna","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Korna","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-14T12:50:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":31,"score":null,"hot":3384019296,"url":"https:\/\/community.smartsheet.com\/discussion\/108902\/average-with-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108902\/average-with-criteria","format":"Rich","lastPost":{"discussionID":108902,"commentID":390420,"name":"Re: Average with criteria","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/390420#Comment_390420","dateInserted":"2023-08-14T10:52:15+00:00","insertUserID":151203,"insertUser":{"userID":151203,"name":"Nick Korna","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Korna","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-14T12:50:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"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\/B8WAXBBWC0OC\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-14T10:47:17+00:00","dateAnswered":"2023-08-14T10:42:33+00:00","acceptedAnswers":[{"commentID":390418,"body":"
<\/p>
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/Z5QK0GLKBAUW\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
