Operator or expression '( )" is not supported in this context

[DessiG]

Hi Everyone,

New here and would highly appreciate your help. 

I am getting the error "Operator or expression '( )" is not supported in this context"

I checked a couple of times, but in my opinion the formula is correct - at least this is how I would write it in Excel. Please can someone help out 

Thanks in advance, 

Dessi

[jdbuchanan71 · Accepted solution]

You had some extra () in there and one of your conditions was outside the IF().  Give this a try.

Discussion Points =
IF (
    Data[Follow-upDate] <= TODAY (),
    "To Be Discussed",
    IF (
        ISBLANK ( Data[Follow-upDate] ),
        "To Be Discussed",
        IF (
            AND ( ISBLANK ( Data[Completion Date] ), ISBLANK ( Data[Follow-upDate] ) ),
            "To Be Discussed",
            "OK"
        )
    )
)

[DessiG]

 Both solutions worked - THANK YOU so much for the pormpt help!!!!

[jdbuchanan71 · Accepted solution]

You can also use a SWITCH instead of nested IFs, makes it easier to read sometimes.

Discussion Point =
SWITCH (
    TRUE (),
    Data[Follow-upDate] <= TODAY (), "To Be Discussed",
    ISBLANK ( Data[Follow-upDate] ), "To Be Discussed",
    AND ( ISBLANK ( Data[Completion Date] ), ISBLANK ( Data[Follow-upDate] ) ), "To Be Discussed",
    "OK"
)

[DessiG]

Thank you so much for your help!!! One more question, please: I am trying to exclude specific test from a column, but the "NOT" does not to be acceptable. Please could you help with the way to exclude / filter out based on specific test, please. THANKS

Discussion Point =
SWITCH (
TRUE (),
Data[Follow-upDate] <= TODAY (), "To Be Discussed",
ISBLANK ( Data[Follow-upDate] ), "To Be Discussed",
AND ( ISBLANK ( Data[Completion Date] ), ISBLANK ( Data[Follow-upDate] ) ), "To Be Discussed",
Data[Status] not "COMPLETED", "To be Discussed",
"OK"
)

[jdbuchanan71]

Try it like this.

Discussion Point =
SWITCH (
    TRUE (),
    Data[Follow-upDate] <= TODAY (), "To Be Discussed",
    ISBLANK ( Data[Follow-upDate] ), "To Be Discussed",
    AND ( ISBLANK ( Data[Completion Date] ), ISBLANK ( Data[Follow-upDate] ) ), "To Be Discussed",
    Data[Status] <> "COMPLETED", "To be Discussed",
    "OK"
)

[jdbuchanan71 · Accepted solution]

You had some extra () in there and one of your conditions was outside the IF().  Give this a try.

Discussion Points =
IF (
    Data[Follow-upDate] <= TODAY (),
    "To Be Discussed",
    IF (
        ISBLANK ( Data[Follow-upDate] ),
        "To Be Discussed",
        IF (
            AND ( ISBLANK ( Data[Completion Date] ), ISBLANK ( Data[Follow-upDate] ) ),
            "To Be Discussed",
            "OK"
        )
    )
)

[jdbuchanan71]

Please post the text of your meaure here instead of a screen shot so we don't have to re-type it out to test it.

[DessiG]

Apologies 🙂 and here it is

Discussion Points = (if((Data[Follow-upDate]<=TODAY(),"To Be Dicussed", IF(ISBLANK(Data[Follow-upDate]),"To Be Diecussed",IF(AND(ISBLANK(Data[Completion Date]),ISBLANK(Data[Follow-upDate])),"To Be Discussed"),"OK"))))