Adjusting my formula

Hi RonaldvdH ,

We can adjust your formula to following:

Test =
IF (
    AND (
        Adressen[Status Site-Survey] <> "";
        Adressen[Status Site-Survey] <> "null"
    );
    IF (
        AND (
            Adressen[site-survey gesloten] = BLANK ();
            Adressen[Sisu gepland] = BLANK ()
        );
        "Sisu nog niet gepland";
        IF (
            Adressen[site-survey gesloten] <> BLANK ();
            "Sisu gereed";
            IF (
                Adressen[Sisu gepland] > TODAY ();
                "geen idee";
                IF (
                    Adressen[Sisu gepland]
                        > TODAY () - 1;
                    "Sisu inleveren binnen 1 dag(en)";
                    IF (
                        Adressen[Sisu gepland]
                            > TODAY () - 2;
                        "Sisu inleveren binnen 2 dag(en)";
                        IF (
                            Adressen[Sisu gepland]
                                > TODAY () - 3;
                            "Sisu inleveren binnen 3 dag(en)";
                            IF (
                                Adressen[Sisu gepland]
                                    > TODAY () - 4;
                                "Sisu inleveren binnen 4 dag(en)";
                                IF (
                                    Adressen[Sisu gepland]
                                        > TODAY () - 5;
                                    "Sisu inleveren binnen 5 dag(en)";
                                    "Sisu te laat"
                                )
                            )
                        )
                    )
                )
            )
        )
    )
)

Or the SWITCH Function Version:

Test =
IF (
    AND (
        Adressen[Status Site-Survey] <> "";
        Adressen[Status Site-Survey] <> "null"
    );
    IF (
        AND (
            Adressen[site-survey gesloten] = BLANK ();
            Adressen[Sisu gepland] = BLANK ()
        );
        "Sisu nog niet gepland";
        IF (
            Adressen[site-survey gesloten] <> BLANK ();
            "Sisu gereed";
            VAR temp =
                Adressen[Sisu gepland] - TODAY ()
            RETURN
                SWITCH (
                    TRUE ();
                    temp > 0; "green idee";
                    temp > -1; "Sisu inleveren binnen 1 dag(en)";
                    temp > -2; "Sisu inleveren binnen 2 dag(en)";
                    temp > -3; "Sisu inleveren binnen 3 dag(en)";
                    temp > -4; "Sisu inleveren binnen 4 dag(en)";
                    temp > -5; "Sisu inleveren binnen 5 dag(en)";
                    "Sisu te laat"
                )
        )
    )
)

If it doesn't meet your requirement, kindly share your sample data and expected result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.