Simple IF THEN logic has me stumped.

Rebecca Menning

Trying to automate a status for the baseline audit status:

If Baseline Audit Date Complete is not blank - Then complete

If Baseline Audit Start Date is not blank and Complete is blank - Then in progress

If Baseline Audit Start Date is blank - Then not started

jmyzk_cloudsmart_jp

Hi @Rebecca Menning

I used the ISDATE function instead of the ISBLANK function.

[Status] =IF(ISDATE([Baseline Audit Date Complete]@row), "Complete", IF(ISDATE([Baseline Audit Start Date]@row), "In Progress", "Not Started"))

jmyzk_cloudsmart_jp

Hi @Rebecca Menning

I used the ISDATE function instead of the ISBLANK function.

[Status] =IF(ISDATE([Baseline Audit Date Complete]@row), "Complete", IF(ISDATE([Baseline Audit Start Date]@row), "In Progress", "Not Started"))

Rebecca Menning

Perfect. Thank you very much.

jmyzk_cloudsmart_jp

Happy to help!😁