Skip to main content
Question

Help with If Statement

  • July 20, 2017
  • 0 replies
  • 17 views
Forum|alt.badge.img+7
Can someone take a look at this formula and let me know what I am doing wrong?

If(not IsNull([Override Actual Complete Date]),[Override Actual Complete Date]),
If([Total # of Active In-Service Tasks - Job] > 0,
     If([Total # of Active In-Service Tasks - Job] = [Total # of Active In-Service Tasks Completed - Job], [Latest Actual In-Service Complete Date - Job]),
     If([Total # of Tasks Completed - Job] = [Total # of Active Tasks - Job], [Latest Actual Complete Date - Job])
)
      This topic has been closed for replies.

      I might be late in answering this, but it looks like you've got an extra ")" at the end of your first line, which means you closed your initial IF statement before specifying what to do if [Override Actual Complete Date] is Null.
      Terms & ConditionsAccessibility statement