SharePoint Calculated Column Multi Conditional Formula

Question

I have a Final Submission Due Date calculated column.

I am trying to create a condition to where if another column (Yes/No Boolean) is checked add a certain value, if not use the original value.

I receive this error:

The formula contains a syntax error or is not supported.

My formula:

=IF([Submit to] = True, 
    IF(ISBLANK([Initial Submission Due Date],
        "",([Initial Submission Due Date]+5)
        )
    )
    ),
    IF([Submit to] = False,
    IF(ISBLANK([Initial Submission Due Date],
        "", ([Initial Submission Due Date])
        )
        )
        )

I have also tried a simpler formula but it yields the same result

=IF([Submit to] = TRUE, IF(ISBLANK([Initial Submission Due Date],"",([Initial Submission Due Date]+ 5)), [Initial Submission Due Date]))

Answer 1

You can check true/false value of Yes/No column directly by referring column name as given in below example.

Try using formula in below format for your calculated column:

=IF([Submit to], IF(ISBLANK([Initial Submission Due Date]),"",[Initial Submission Due Date]+5), [Initial Submission Due Date])

Note:

1. Sometimes comma(,) does not work in formula (it is based on language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).

Official Documentations:

1. Calculated Field Formulas.
2. IF function.