locked
How calculate column in list RRS feed

  • Question

  • I have a column STATUS and DATA.
    This column DATA should be updated (must display Today data) if the value of another column STATUS is New 
    and if column DATA is still empty!
    How would i calculate filed DATA?
    Wednesday, November 21, 2012 1:29 PM

All replies

  • Just want to understand, where will you get today's data? Could you please explain little more?


    Sekar - Our life is short, so help others to grow

    Whenever you see a reply and if you think is helpful, click "Alternate TextVote As Helpful"! And whenever you see a reply being an answer to the question of the thread, click "Alternate TextMark As Answer

    Wednesday, November 21, 2012 2:15 PM
  • I want get today data at column DATA if column DATA is empty.
    Thursday, November 22, 2012 6:19 AM
  • Hi,

    You need to make the DATA column as a calculated column & may be its formula can be

    =IF([Status]="New", "Today", "")

    For more information on Calculated Columns visit http://msdn.microsoft.com/en-us/library/bb862071(v=office.14).aspx


    Regards, Md Rizwan Khan

    Tuesday, January 8, 2013 7:12 AM