I have a SharePoint list with a number of various columns.

One column titled Salary Step Processing. Whenever the value of this column is not set to Not Required, I require another column titled Birthday Updates to be set to Automatic - Use Salary Step Processing Post Payrun.

I was hoping to use the Validation settings to assist, but I'm not sure exactly how.

Any ideas?


Validation settings can prompt the user to set the conditionally required column with something like:


=IF([Salary Step Processing]<>"Not Required",IF([Birthday Updates]<>"Automatic - Use Salary Step Processing Post Payrun",TRUE,FALSE),TRUE)

User Message: Birthday Updates must be set to "Automatic - Use Salary Step Processing Post Payrun" if Salary Step Processing is required.

If you would like the column to be updated automatically when Salary Step Processing not equals Not Required, I believe that would require some code.

  • Hello Ornery, Thank you for replying. Helped a lot! Do you know if there is a way to add multiple verification? – Daniel Watson May 24 '17 at 1:03

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.