This forum is closed. Thank you for your contributions.

Remove From My Forums

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

Question
0

Sign in to vote

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.

Regards,

Amit

Tuesday, October 23, 2012 7:09 AM

Answers

1

Sign in to vote
Hi,

Create calculate column and follow the below blog to set datetime based on your priority field:

http://sarahlhaase.wordpress.com/2012/07/24/modifying-calculated-column-formulas-based-on-values-selected-in-other-metadata-fields/

Hope it could help
Hemendra:"Yesterday is just a memory,Tomorrow we may never see"
whenever you see a reply and if you think is helpful, click "Vote As Helpful"! And whenever you see a reply being an answer to the question of the thread, click "Mark As Answer
- Marked as answer by AmitAgarwal129 Tuesday, October 23, 2012 9:22 AM
Tuesday, October 23, 2012 8:27 AM

Moderator