Combining two If-Then formulas into one.

  • 0
  • 1
  • Question
  • Updated 5 years ago
  • Answered

Here is my current date-formula:

If ([Override Scheduled Start Date?]=true, [New Scheduled Start Date])

Now I'd like to add an additional condition where:

If ([Override Scheduled Start Date?]=false, ([Est Project Start]+Days([Task - Start Day]))-Days(1)

Each formula works by itself but I'm having trouble combining the two.

Please advise.

Photo of NP

NP

  • 10 Points

Posted 5 years ago

  • 0
  • 1
Photo of Tobias

Tobias

  • 20 Points
Try this...

If ([Override Scheduled Start Date?]=true, [New Scheduled Start Date], ([Est Project Start]+Days([Task - Start Day]))-Days(1))
Photo of NP

NP

  • 10 Points
Yes! Woohoo, thank you!