Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.

Start-to-Finish Predecessors Doesn't Work as Expected with Multiple Predecessors

Jane
Jane
edited 12/09/19 inArchived 2016 Posts

Hi there,

I'm running into a roadblock I'm hoping someone could help with.

I'm planning my schedule backwards from an end date, and using Start-to-Finish Predecessors as recommended in this article (http://help.smartsheet.com/customer/portal/articles/765727).

Here's the problem: I have a task (let's call it Task 1) that must be finished before two different tasks can start (let's call them Task 2 and 3). But, when I use the Start-to-Finish Predecessor (Task 1, shows 2SF and 3SF as Predecessors) it allows Task 2 to start before Task 1 finishes. However if I delete Task 3 as a SF Predecessorfor Task 1, it correctly aligns Task 2 to start after Task 1.

Any help is much appreciated.

Tags:

Comments

  • Start to Finish predecessor means that when Task 2 and 3 finish, task 1 will start.

    这听起来like you need to set it to Finish to start, meaning task 1's finish will be the start for task 2 and 3. Add a -1d to the predecessor if you want task 2 and 3 to start on the same day task 1 finishes. I hope this helps.

This discussion has been closed.
@Jmirata<\/a> <\/p>

I believe this requires you to change the column type to a contact-like one. <\/p>

Then you should be able to select it in this dropdown. <\/p>

Ryan<\/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":110640,"type":"question","name":"Sum Formula containing keywords?","excerpt":"I'm trying to keep a running sum of the amount of liquid we are holding for our business's transfer log and I am not even sure where to begin! We have to log transfers (IN) and (OUT) and I would like to write a formula to keep up with this if possible. (Adding the amount in rows with IN and subtracting the amount in rows…","snippet":"I'm trying to keep a running sum of the amount of liquid we are holding for our business's transfer log and I am not even sure where to begin! We have to log transfers (IN) and…","categoryID":322,"dateInserted":"2023-09-22T01:44:27+00:00","dateUpdated":null,"dateLastComment":"2023-09-22T12:05:15+00:00","insertUserID":151299,"insertUser":{"userID":151299,"name":"lcain","url":"https:\/\/community.smartsheet.com\/profile\/lcain","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-22T12:38:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":15741,"lastUser":{"userID":15741,"name":"ker9","url":"https:\/\/community.smartsheet.com\/profile\/ker9","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-24T18:20:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":37,"score":null,"hot":3390731982,"url":"https:\/\/community.smartsheet.com\/discussion\/110640\/sum-formula-containing-keywords","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110640\/sum-formula-containing-keywords","format":"Rich","lastPost":{"discussionID":110640,"commentID":396586,"name":"Re: Sum Formula containing keywords?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/396586#Comment_396586","dateInserted":"2023-09-22T12:05:15+00:00","insertUserID":15741,"insertUser":{"userID":15741,"name":"ker9","url":"https:\/\/community.smartsheet.com\/profile\/ker9","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-24T18:20:54+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\/I6ZQZFEI6SV8\/screenshot.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-22T12:09:07+00:00","dateAnswered":"2023-09-22T12:05:15+00:00","acceptedAnswers":[{"commentID":396586,"body":"

Hi @lcain<\/a> <\/p>

See if this formula will work for you - in a separate column\/cell. <\/p>

It should give you the balance remaining of IN - OUT<\/p>

=SUMIFS([Quantity (gal)]:[Quantity (gal)], [Reason for Opening Container]:[Reason for Opening Container], CONTAINS(\"IN\", @cell)) - SUMIFS([Quantity (gal)]:[Quantity (gal)], [Reason for Opening Container]:[Reason for Opening Container], CONTAINS(\"OUT\", @cell))<\/p>

Hope this helps! (It is not a running total but a grand total)<\/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":110624,"type":"question","name":"Could someone help me with this formula?","excerpt":"We are asking our managers to use SmartSheet to enter information about their employees (via the add form). Be are requiring them to enter the employee ID which has to be 9 digits, but many times they don't enter all the numbers. I read about helper columns to check whether or not the format is accurate and then send an…","snippet":"We are asking our managers to use SmartSheet to enter information about their employees (via the add form). Be are requiring them to enter the employee ID which has to be 9…","categoryID":322,"dateInserted":"2023-09-21T21:53:10+00:00","dateUpdated":"2023-09-22T23:36:16+00:00","dateLastComment":"2023-09-22T13:35:05+00:00","insertUserID":167225,"insertUser":{"userID":167225,"name":"Estephania","title":"People Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Estephania","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!Z-jR2YjcHjQ!nZFQX7DhE3w!USXSZFSV9Ma","dateLastActive":"2023-09-22T19:29:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":166028,"lastUserID":167225,"lastUser":{"userID":167225,"name":"Estephania","title":"People Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Estephania","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!Z-jR2YjcHjQ!nZFQX7DhE3w!USXSZFSV9Ma","dateLastActive":"2023-09-22T19:29:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":42,"score":null,"hot":3390724095,"url":"https:\/\/community.smartsheet.com\/discussion\/110624\/could-someone-help-me-with-this-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110624\/could-someone-help-me-with-this-formula","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":110624,"commentID":396597,"name":"Re: Could someone help me with this formula?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/396597#Comment_396597","dateInserted":"2023-09-22T13:35:05+00:00","insertUserID":167225,"insertUser":{"userID":167225,"name":"Estephania","title":"People Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Estephania","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!Z-jR2YjcHjQ!nZFQX7DhE3w!USXSZFSV9Ma","dateLastActive":"2023-09-22T19:29:53+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-22T13:33:27+00:00","dateAnswered":"2023-09-22T01:23:13+00:00","acceptedAnswers":[{"commentID":396566,"body":"

Hello @Estephania<\/a> <\/p>

You can use a checkbox as your helper column and trigger.<\/p>

The function will be verifying the length of the value and the box will be checked if it is too short and too long, or unchecked if it is correct.<\/p>

We will use the functions LEN and IF.<\/p>

=IF(LEN([EmployeeID]@row)=9,0,1)<\/p>

The checkbox is a variable that only recognizes true or false results. 0 means False (the ID is the correct length) and 1 means True (the ID is incorrect).<\/p>

You can also use =IF(LEN(EmployeeID]@row<>9,1,0) if it's easier for you to recognize. The results will be exactly the same.<\/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":254,"urlcode":"formulas","name":"Formulas"}]}],"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":[]}">

Trending Posts