locked
SharePoint calculated field displaying #value! RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    In SharePoint calculated field if the value is empty, then its displaying #value! Does anyone has any idea how to remove it?
    Sunday, April 28, 2013 4:54 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Sujit,

    We could add an If statement similar like following.

    if(([ColumnA]=""),"",ColumnA)

    Display date in ColumnA when ColumnA is not empty. Otherwise, display nothing (“”).

    Thanks & Regards,
    Emir Liu
    TechNet Subscriber Support in forum
    If you have any feedback on our support, please click here.

    Emir Liu
    TechNet Community Support

    • Marked as answer by Emir Liu Friday, May 3, 2013 10:04 AM
    Monday, April 29, 2013 5:26 AM