0

In adding an item to the list/library. I want to make Actual(Hrs) field required if only the Status input is Completed

enter image description here

enter image description here

2
  • Tried the above code with the Category field when it is "Meeting", if Meeting is chosen than the All Day Event must not be empty =IF(Category="Meeting",AND(NOT(ISBLANK([All Day Event]))),TRUE) When I tried to save this error came up One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas. Help please Jul 5 '17 at 5:58
  • Try validate it in Presaveaction ..social.technet.microsoft.com/wiki/contents/articles/…
    – Nag1987
    Jul 5 '17 at 6:02
1

You can keep the below text in List Validation settings. You check your field name properly while keeping the validation Status, Actual(Hrs)

=IF(Status="Completed",AND(NOT(ISBLANK([Actual(Hrs)]))),TRUE)

Validation message Actual(Hrs) should not be blank

7
  • I thought that column validation can not be based on other columns.
    – newbie
    Jun 20 '17 at 10:31
  • not column Validation, there is a list Validation settings under list settings. Please look at it. Jun 20 '17 at 10:32
  • Woow thats a good and new feature for me :) Thank you.
    – newbie
    Jun 20 '17 at 10:35
  • can you vote if this works for you :) Jun 20 '17 at 10:42
  • check your list column names properly. Status, Actual(Hrs). may be some space or any other characters exist. I can see in the screen shot Actuals (hrs). change this in the formulae Jun 20 '17 at 10:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.