Goal: Calculated column called "Certificate Status" (Data type returned: single-line of text) that identifies if an individual has provided the certificate for a required training.
If the column "Certificate Date" is blank, the formula returns "Missing." If there is a date in "Certificate Date" and the difference between the "Certificate Date" and "Today" is greater than 365, then the formula returns "Expired", if that is not the case, the formula returns "Good".
I keep getting the error:
"The formula contains a syntax error or is not supported."
Columns feeding into calculated column "Certificate Status":
- Certificate Date = mm/dd/yyyy
- Today = mm/dd/yyyy (Defaults to "Today")
DATEDIF(Certificate Date) = DATEDIF([Certificate Date],Today*,"D")---(Data type returned: Number)
DATEDIF(Certificate Date) and going back in to inspect the formula, SharePoint removes the brackets around "Today".
Any support in identifying the discrepancy and/or clearing up that SharePoint calculated columns cannot support what I'm trying below is greatly appreciated.
"Certificate Status" formula is as follows:
=IF(ISBLANK[Certificate Date], "Missing", IF([DATEDIF(Certificate Date)]>365, "Expired", "Good" ) )