I am seeking assistance with a specific formula.
I am creating an employee snow deactivation request and tracker. Employees can schedule time off during winter operations. The issue is that we have two periods, Preseson and In-Season. The Preseason period to submit your vacation is 7/15/25 thru 8/15/25 and In-Season is 10/1/25 thru 4/30/26. Requests cannot be more than 30 day out from the created date, but no less than two days. Here is the formula that is not working for the submission criteria:
=IF(Status@row = "Preseason", IF(AND([Created Date]@row >= [Start Date]@row - 30, [Created Date]@row <= [Start Date]@row + 2), 0, 1), IF(Status@row = "In-Season", IF(AND([Created Date]@row >= [Start Date]@row - 30, [Created Date]@row <= [Start Date]@row + 2), 0, 1, ""), ""))
It does not check the box, and I have no errors.
Thank you!
Ron Anderson