I am trying to make it so people filling out my form can’t choose the weekend for a drop off. I have tried the expression
[Barrel Drop Off Date/Time] is Weekday
Any ideas on how i can make this work?
Solved! Go to Solution.
In Valid if:
NOT(
IN(
WEEKDAY([Barrel Drop Off Date/Time]),
LIST(1, 7)
)
)
@Mitchell_Daly
Your syntax is not correct. Have you checked this page?
I’ve gone over that info, but I am still not sure how to restrict the column to just Monday through Friday. Am I missing it?
In Valid if:
NOT(
IN(
WEEKDAY([Barrel Drop Off Date/Time]),
LIST(1, 7)
)
)
This worked perfect for what I was looking for. Thanks!
IN(WEEKDAY([Barrel Drop Off Date/Time]), LIST(2,3,4,5,6))
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |