Quick Base Discussions

Expand all | Collapse all

Help with If Statement

  • 1.  Help with If Statement

    Posted 07-20-2017 14:35
    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])
    )


  • 2.  RE: Help with If Statement

    Posted 08-11-2017 17:14
    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.