0

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]))

1 Answer 1

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.
1
  • 1
    Ganesh saves the day!
    – BeerusDev
    Dec 23, 2022 at 16:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.