Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Make field required based on another value

  Asked By: Pallavi    Date: Jun 12    Category: Sharepoint    Views: 3711

I have 2 fields in a list: Status and Revised Finish Date

I would like to make the 'Revised Finish Date' required if the 'Status' = Delayed, otherwise do nothing. I've tried to create a calculated field but my formula is incorrect:

=IF([Status]="Delayed", IsNot Null, " ")

Is my approach correct? If so, please help correct the formula. Otherwise can someone show me how I can accomplish this?



1 Answer Found

Answer #1    Answered By: Dipesh Bhanani     Answered On: Jun 12

I don't think you can do it through formula. You can use PreSaveAction() JavaScript function to validate any list field  on save button.
PreSaveAction() is undefined function and when save button is clicked on list  forms, SharePoint checks for the function and calls before postback.

Didn't find what you were looking for? Find more on Make field required based on another value Or get search suggestion and latest updates.