Switch Statement Not Working

[Anonymous]

None of my other columns required a switch function.  The if statements are working on their own, but not when put together.  Any help would be appreciated.

Days for IV Approval =

SWITCH (

IF(ISBLANK([Ready for Treasury Approval]) && ISBLANK([Ready for Credit Approval]) && ISBLANK([Ready for Tax Approval]) && ISBLANK([Ready for Category Manager Approval]) && NOT(ISBLANK([Submitted to Workflow])) && NOT(ISBLANK([Ready for Independent Validation Approval])),

    [Ready for Independent Validation Approval] - [Submitted to Workflow]),

IF(ISBLANK([Ready for Treasury Approval]) && ISBLANK([Ready for Credit Approval]) && ISBLANK([Ready for Tax Approval]) && NOT(ISBLANK([Ready for Category Manager Approval])) && NOT(ISBLANK([Ready for Independent Validation Approval])) && NOT(ISBLANK([Submitted to Workflow])),

    [Ready for Independent Validation Approval] - [Ready for Category Manager Approval]),

IF(ISBLANK([Ready for Treasury Approval]) && ISBLANK([Ready for Credit Approval]) && NOT(ISBLANK([Ready for Tax Approval])) && NOT(ISBLANK([Ready for Independent Validation Approval])) && NOT(ISBLANK([Submitted to Workflow])),

    [Ready for Independent Validation Approval] - [Ready for Tax Approval]),

IF(ISBLANK([Ready for Treasury Approval]) && NOT(ISBLANK([Ready for Credit Approval])) && NOT(ISBLANK([Ready for Independent Validation Approval])) && NOT(ISBLANK([Submitted to Workflow])),

    [Ready for Independent Validation Approval] - [Ready for Credit Approval]),

IF(NOT(ISBLANK([Ready for Treasury Approval])) && NOT(ISBLANK([Ready for Independent Validation Approval])) && NOT(ISBLANK([Submitted to Workflow])),

    [Ready for Independent Validation Approval] - [Ready for Treasury Approval])

)

[Anonymous]

Thank you!

[johnt75 · Accepted solution]

You don't need the IF statements within SWITCH, try

Days for IV Approval =
SWITCH (
    TRUE (),
    ISBLANK ( [Ready for Treasury Approval] )
        && ISBLANK ( [Ready for Credit Approval] )
        && ISBLANK ( [Ready for Tax Approval] )
        && ISBLANK ( [Ready for Category Manager Approval] )
        && NOT ( ISBLANK ( [Submitted to Workflow] ) )
            && NOT ( ISBLANK ( [Ready for Independent Validation Approval] ) ), [Ready for Independent Validation Approval] - [Submitted to Workflow],
    ISBLANK ( [Ready for Treasury Approval] )
        && ISBLANK ( [Ready for Credit Approval] )
        && ISBLANK ( [Ready for Tax Approval] )
        && NOT ( ISBLANK ( [Ready for Category Manager Approval] ) )
            && NOT ( ISBLANK ( [Ready for Independent Validation Approval] ) )
                && NOT ( ISBLANK ( [Submitted to Workflow] ) ),
        [Ready for Independent Validation Approval] - [Ready for Category Manager Approval],
    ISBLANK ( [Ready for Treasury Approval] )
        && ISBLANK ( [Ready for Credit Approval] )
        && NOT ( ISBLANK ( [Ready for Tax Approval] ) )
            && NOT ( ISBLANK ( [Ready for Independent Validation Approval] ) )
                && NOT ( ISBLANK ( [Submitted to Workflow] ) ), [Ready for Independent Validation Approval] - [Ready for Tax Approval],
    ISBLANK ( [Ready for Treasury Approval] )
        && NOT ( ISBLANK ( [Ready for Credit Approval] ) )
            && NOT ( ISBLANK ( [Ready for Independent Validation Approval] ) )
                && NOT ( ISBLANK ( [Submitted to Workflow] ) ), [Ready for Independent Validation Approval] - [Ready for Credit Approval],
    NOT ( ISBLANK ( [Ready for Treasury Approval] ) )
        && NOT ( ISBLANK ( [Ready for Independent Validation Approval] ) )
            && NOT ( ISBLANK ( [Submitted to Workflow] ) ), [Ready for Independent Validation Approval] - [Ready for Treasury Approval]
)