1

I'm needing some assistance with Form Validation.

I have a column inside my sharepoint listed called "Payroll Close Day". This column allows the end user to select from a choice of values being "Monday, Tuesday, Wednesday, Thursday and Friday".

I have added another column called "Period End Processing Day", set up the exact settings.

I need some advice to understandable if it is possible to:

  1. Stop the user selecting the same day in the "Period End Processing Day" as what is selected in the "Payroll Close Day".
  2. When the user selects the "Period End Processing Day", ensure the day selected is the "Payroll Close Day" + 1. So if they select Tuesday in the "Payroll Close Day", the "Period End Processing Day" must be Wednesday.

Thanks in advance and any suggestions would be appreciated.

2 Answers 2

0

Go to list Settings - > Validation Settings

Add following formula there inside text area :

    =EXACT(TEXT(WEEKDAY(Date1)+1,"ddd"),TEXT(WEEKDAY(Date2),"ddd"))

Replace Date1 and Date2 with your field names.

And in User Message input area add suitable validation message.This message will be displayed in the form when your condition does not satisfy.

0
0

If the Period End Processing Day is always the next working day, perhaps best to avoid the user having to complete it. Instead, run some workflow to look at the Payroll Close Day and populate the PEPD accordingly.

1
  • Never thought of this idea. Easy enough to do. :) May 13, 2017 at 0:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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