Help with If Statement

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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])
)
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Michelle

Michelle

  • 230 Points 100 badge 2x thumb
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.