How do I fix this error #INCORRECT ARGUMENT SET

PeterM

Working Formula:

=IF(ISBLANK([Site Occupancy Meeting

Date]@row), "01_SOR Needed", IF(ISBLANK([Right of Entry Received

Date]@row), "02_ROE Needed", IF(ISBLANK([Matterport Inspection

Date]@row), "03_Matterport Needed", IF(ISBLANK([Notice of Eligibility Sent

Date]@row), "04_NOE Needed", IF(ISBLANK([Comps Completed Date]@row), "05_Comps

Needed", IF(ISBLANK([Relocation Scheduled]@row),

"06_Relocation Not Scheduled", IF(ISTEXT([Relocation Scheduled]@row), "09_Check

Relo Status", IF([Relocation Scheduled]@row > TODAY(),

"07_Relocation Scheduled", "08_Relocation Complete"))))))))

I want to add this to the formula above that is currently working, but I add the formula below I’m getting an error of #INCORRECT ARGUMENT SET. How do I fix it. Thank you

 IF([SAFE Case Flag]@row = "true",

"08_Relocation Complete", ISDATE([Vacancy Inspection]@row,

"08_Relocation Complete"))

Notes:

If Safe case is flagged then return "08_Relocation

Complete", if Vacancy Inspection

has a date then return "08_Relocation

Complete".

=IF(ISBLANK([Site Occupancy Meeting

Date]@row), "01_SOR Needed", IF(ISBLANK([Right of Entry Received

Date]@row), "02_ROE Needed", IF(ISBLANK([Matterport Inspection

Date]@row), "03_Matterport Needed", IF(ISBLANK([Notice of Eligibility Sent

Date]@row), "04_NOE Needed", IF(ISBLANK([Comps Completed Date]@row), "05_Comps

Needed", IF(ISBLANK([Relocation Scheduled]@row),

"06_Relocation Not Scheduled", IF(ISTEXT([Relocation Scheduled]@row), "09_Check

Relo Status", IF([Relocation Scheduled]@row > TODAY(),

"07_Relocation Scheduled", "08_Relocation Complete", IF([SAFE Case Flag]@row = "true",

"08_Relocation Complete", ISDATE([Vacancy Inspection]@row,

"08_Relocation Complete"))))))))))

Paul Newcome

Yes, but now you need to take a closing parenthesis from the very end and use it to close out that last ISDATE function.

.......IF([SAFE Case Flag]@row = "true", "08_Relocation Complete", IF(ISDATE([Vacancy Inspection]@row), "08_Relocation Complete", IF([Relocation Scheduled]@row > TODAY(), "07_Relocation Scheduled",.......

Paul Newcome

Try an IF before the ISDATE function.

 IF([SAFE Case Flag]@row = "true", "08_Relocation Complete", IF(ISDATE([Vacancy Inspection]@row, "08_Relocation Complete"))

PeterM

@Paul Newcome

I made the changed, but I am still getting the same error.

=IF(ISBLANK([Site Occupancy Meeting Date]@row), "01_SOR Needed", IF(ISBLANK([Right of Entry Received Date]@row), "02_ROE Needed", IF(ISBLANK([Matterport Inspection Date]@row), "03_Matterport Needed", IF(ISBLANK([Notice of Eligibility Sent Date]@row), "04_NOE Needed", IF(ISBLANK([Comps Completed Date]@row), "05_Comps Needed", IF(ISBLANK([Relocation Scheduled]@row), "06_Relocation Not Scheduled", IF(ISTEXT([Relocation Scheduled]@row), "09_Check Relo Status", IF([Relocation Scheduled]@row > TODAY(), "07_Relocation Scheduled", "08_Relocation Complete", IF([SAFE Case Flag]@row = "true", "08_Relocation Complete", IF(ISDATE([Vacancy Inspection]@row, "08_Relocation Complete")))))))))))

Paul Newcome

You are adding it AFTER the "value if false" portion of your first nested IF.

Here is what you essentially have:

=IF(.....IF(.....IF(....., final value if true, value if false, IF(.....IF(.....

PeterM

@Paul Newcome

Should I add it before the final If statement? Thank you.

=IF(ISBLANK([Site Occupancy Meeting Date]@row), "01_SOR Needed", IF(ISBLANK([Right of Entry Received Date]@row), "02_ROE Needed", IF(ISBLANK([Matterport Inspection Date]@row), "03_Matterport Needed", IF(ISBLANK([Notice of Eligibility Sent Date]@row), "04_NOE Needed", IF(ISBLANK([Comps Completed Date]@row), "05_Comps Needed", IF(ISBLANK([Relocation Scheduled]@row), "06_Relocation Not Scheduled", IF(ISTEXT([Relocation Scheduled]@row), "09_Check Relo Status", IF([SAFE Case Flag]@row = "true", "08_Relocation Complete", IF(ISDATE([Vacancy Inspection]@row, "08_Relocation Complete", IF([Relocation Scheduled]@row > TODAY(), "07_Relocation Scheduled", "08_Relocation Complete")))))))))))

Paul Newcome

Yes, but now you need to take a closing parenthesis from the very end and use it to close out that last ISDATE function.

.......IF([SAFE Case Flag]@row = "true", "08_Relocation Complete", IF(ISDATE([Vacancy Inspection]@row), "08_Relocation Complete", IF([Relocation Scheduled]@row > TODAY(), "07_Relocation Scheduled",.......