I need to write a rule to conditionally require data in a field based on the values in two other columns:

Status Column: Values include "Active" or "Inactive"

Type Column: Values include "Full Time","Part Time","Temporary"

I need a third column, Name to be required when Status="Active" AND Type="Full Time" OR "Part Time"

My current attempt is this: =IF([@[Status]]="Active",AND([@[Type]]="Full Time",OR[@[Resource Type]]="Part Time",TRUE,FALSE)TRUE)

This does not work. Any assistance would be greatly appreciated.

  • 2
    Do you mean (Status="Active" AND Type="Full Time") OR "Part Time", or do you mean: Status="Active" AND (Type="Full Time" OR "Part Time") – Mike2500 Jan 10 at 18:13
  • If Type column includes either Full time or Part time. Why would you want to add it in formula. Select anyone as default choice. And use formula based on Status column only. Also you have used Type as well as Resource Type in your formula. What does this Resource Type column? – Ganesh Sanap Jan 10 at 18:24
  • @Mike2500 I mean the second statement. – Leslie Jones Jan 10 at 18:55
  • @GaneshSanap For Type, there is actually a third value so I need to exclude that one. I've edited the original question to reflect this. – Leslie Jones Jan 10 at 18:56

Since you're referring to different fields, the validation logic will go in the list settings --> validation settings, not the validation settings for the individual column.

=NOT(AND(AND(Status="Active",OR([Job Type]="Full Time",[Job Type]="Part Time")),[Employee Name]=""))

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.