I currently have two date fields, start and end. How do I create a relationship between two rows, e.g.
Have the start date of Task B be days before Task A end date?
I currently have two date fields, start and end. How do I create a relationship between two rows, e.g.
Have the start date of Task B be days before Task A end date?
You’d have to link the two records together (specifically, in Task B’s record, link Task A in the linked record field)
You’d then have to add a lookup field to grab the due date you’ve set, and then use a formula to calculate the start date
And finally, you’d need a formula field that summarizes between the two start dates that you have: the one that you set up manually and the one that you’ve calculated
Thank you! So in the Gantt chart - the bars will probably auto update. Are you still able to drag the bars to change the date or do they become locked?
Thank you! So in the Gantt chart - the bars will probably auto update. Are you still able to drag the bars to change the date or do they become locked?
Ahh, ouch, they would become locked
Hmm, if we want that functionality, the Gantt chart will have to reference actual date fields, so we’d have to:
This should do what you’re looking for I think
thank you! will give it a try
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.