Calculate datetime based on selected value in lookup[Sharepoint 2007] RRS feed

  • Question

  • Hi All,

    I have a list in which Priority column is a choice menu with low, medium and high as the field. I am trying to add another datetime column(due date) which is calculated based on the value selected in Priority column. The due date should be current date +10 days if priority is low, current date +5 is priority is medium and current date +2 is priority is high. I am unable to crack the formula for the same. Please help in this regard.



    Tuesday, October 23, 2012 7:09 AM