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