How do I check for valid predecessor input?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I have a Task records with Planned Start and Planned Finish. There is also a formula text field called Progress that updates based on a number of conditions. Is it possible to create a formula for Progress that changes to a warning if a Planned Start won't work due to a Predecessor, ie the Planned Start is set before the Planned Finish of the preceding task?
Photo of Ben


  • 40 Points

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
To my knowledge; the native predecessor fields will not calculate that.  You would need some a child table of dependancies to the tasks themselves.  Then a mess of formulas and conditionals passing to make it all happen.  We've done it a few times, but its not as straight forward as you'd hope.