Forum Discussion

ShontaySmith's avatar
ShontaySmith
Qrew Assistant Captain
7 years ago

Help with If Statement

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])
)

1 Reply

Sort By
  • MichelleMichell's avatar
    MichelleMichell
    Qrew Cadet
    7 years ago
    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.