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