I have a Sharepoint column that is supposed to capture date and time values. How can I display a value of "N/A" when the field is null (is blank) and also display the actual value if one was entered?
+2
A:
Put a calculated value in the default value for the column? This will of course depend on when the Date is supposed to get populated.
=IF(ISBLANK[myDate],"N/A","[myDate])
Add a new column that is based on the Date column that is actually a calculated column referencing the Date column utilizing the same calculation.
Neil Wood
2010-07-02 15:59:37
I am getting the following Sharepoint error:The formula contains a syntax error or is not supported
Lawrence Smith
2010-07-02 16:43:44
Fixed formula - brackets in wrong place
Ryan
2010-07-02 18:48:35
I am still getting that errorFYI I am using Sharepoint 2007
Lawrence Smith
2010-07-02 19:21:15
should it be =IFF()?
NLV
2010-07-03 12:13:13
I tried the following formula and still is getting syntax error message in Sharepoint 2007=IF(ISBLANK[myDate],"N/A","[myDate])
Lawrence Smith
2010-07-09 11:55:14