locked
Default Date with Text "TBD" RRS feed

  • Question

  • I'm using a custom list with Date Columns [START DATE], [FINISH DATE] and need to display "TBD" when left blank by user. 

    Is there a calculated formula to be used? Any examples?

    Thursday, January 12, 2012 8:28 PM

Answers

  • Hello,

    When you create a calculated column, users wont be able to enter any data to those columns. So, I am assuming that your columns [START DATE] & [FINISH DATE] are Date Time columns and they cannot be Calculated columns.

    However if you want any such functionality as you mentioned, you can another column, and this can be a calculated column which can display TBD if [START DATE] is empty else, it will display the entered date.

    Create another column of type Calculated and use the below formula,

    =IF([START DATE]="","TBD",TEXT([START DATE],"mm/dd/yyyy"))
    Check the column names in the above formula with your list structure.

     


    Ram Prasad Meenavalli | MCTS SharePoint 2010 | MCPD SharePoint 2010
    • Proposed as answer by ddpatil Friday, January 13, 2012 5:32 AM
    • Marked as answer by Mike Walsh FIN Friday, January 13, 2012 4:05 PM
    Friday, January 13, 2012 5:25 AM

All replies

  • Hi, i dont think you can store "TBD" in the Date column , you can store null as blank while displaying you can check the value of the field and change the value as "TBD" in the forms.
    Anil
    Thursday, January 12, 2012 10:08 PM
  • Hi,

    Since "TBD" is a String value this can not be stored in the column of DateTime.

    You can instead show it as null or any other default value that signifies the same.


    Thanks, Rahul Rashu
    Friday, January 13, 2012 3:52 AM
  • Hello,

    When you create a calculated column, users wont be able to enter any data to those columns. So, I am assuming that your columns [START DATE] & [FINISH DATE] are Date Time columns and they cannot be Calculated columns.

    However if you want any such functionality as you mentioned, you can another column, and this can be a calculated column which can display TBD if [START DATE] is empty else, it will display the entered date.

    Create another column of type Calculated and use the below formula,

    =IF([START DATE]="","TBD",TEXT([START DATE],"mm/dd/yyyy"))
    Check the column names in the above formula with your list structure.

     


    Ram Prasad Meenavalli | MCTS SharePoint 2010 | MCPD SharePoint 2010
    • Proposed as answer by ddpatil Friday, January 13, 2012 5:32 AM
    • Marked as answer by Mike Walsh FIN Friday, January 13, 2012 4:05 PM
    Friday, January 13, 2012 5:25 AM
  • Thank you to everyone for commenting here, very helpful!

    Friday, January 13, 2012 4:04 PM