Forms - Leave application. Issue: Forms dont allow leave application more than 2days

I have a leave application form that I have used for our company's leaves application online. When we apply for leave, we will receive an email notification of said leave being applied and an email notification to the approver.

The problem: When we apply a leave more than 1 day i.e. 2days, the form does not register the application nor it will send an email notification of said leave to us, and to the approver.

What we tried:
1. The system has worked for a long time, and the last application with success of more than 2 days is back in December. There wasn't any issue till January.
2. We have tried with different browser, different PC, different email and caches, and anything more than 1day, the problem arises.
3. Anything like 1 day or less, there is no issue. A notification will be sent to the applicant and the approver where the leave can be approved.
4. We have not modified or changed anything with the leave application form between the time period.
5. The form is attached from a sheet, where any approved leave will go to the sheet to be manually adjusted and reviewed by the office administrator.

If anyone has an idea what went wrong, please let me know. (I'm thinking it's a broken script connecting forms to sheet? but I'm not sure)

Forms:Leave application
docs.google.com/forms/d/1S739TgPdFvLO4gSMzazdrR56scHLSrdorsWRV2SD4k8/edit[/url]

If required: Sheets: Paid Leave
docs.google.com/spreadsheets/d/1-BVujWAcqPCfv6urOJgKXmw94jvHw5KmU_h9NFXiX3k/edit?usp=sharing[/url]

Once the forms are filled and approved, the leave will be automatically be registered to the sheets.
Note that both are not connected as I can only copy each sheet one by one.

Thank you for looking into it.

there are no scripts attached to the form, and there are no email scripts attached to the spreadsheet, so its not possible to find if there is any scripting issues.

that being said, i did have a look at the format used for some of the date columns, and when i checked if they are numbers i discovered that a lot of the data is actually text, and that is not a good thing to do.

you can see them highlighted orange in the screenshot.

to troubleshoot further we really need to have a limited set of example data (1800 rows is too much, 20 rows is enough) along with any required scripts that the data would be used for creating the email.

Screen Shot 2022-01-29 at 12.35.26 am.png

This is the new sheet in question:
docs.google.com/spreadsheets/d/1EkZHmxZZQvLEyr5gXhKWDonfPlDLAPLngSEadYg47x4/edit#gid=299715453

I believe that the problem maybe stemming from how the data is transferred from the forms to the sheets. However, date wise it looks like everything is in order, so I couldn't figure out what is triggering the #value! problem.
In the sheets, the green arrow is referring to those leaves that are more than 2days and wasn't able to show proper value (#value!). The ones with pass are days with less than or equal to 1 day leave.

There are no appscripts attached to the original google form in post #1 and new google sheet from post #4.

3. I accidentally deleted the master formula while redacting. I have pasted the row back with the formulas in place.

4. the name is used in the "url" but there are no names on the form responses sheet, so we have no idea how/where the name is obtained from
Not sure what you are refering to, but I have added a name on row 135. On the original forms, there is actually a list of of names to choose from which is pulled from the employee list sheet (google sheet post 4), It is disabled and redacted in the copy version.

Thank you for your patience.

the problem is that only the "Form Responses 1" has data that is accessible to anyone else.

and you still have not addressed the issue of where the columns A, B, W, X, AE, AF, AJ get their data from.
that is to say, you must at the very least provide sample data AND put the formulas back in their place.

no one will ever be able to tell you why a cell has a VALUE error when you cannot provide the formula and sample data that show the issue in action.

im sorry, i will not continue further until you have addressed these issues.

Thank you for your reply and help. I have connected everything as per original. (including the add on copydown and form mule)

The below is the form in question. If you fill the form below, it will exactly replicate the issue that occurred above. Regarding the name, it is filled in manually on the (edit)forms so you can select it when filling the live form.

docs.google.com/forms/d/e/1FAIpQLSe4l7ReGe5D1XLc2xT0s0jSYAfn0mOi8T1vt4Elgh1VSWY27Q/viewform

If you fill in 1day, then it will send an automated email to you, but anything more than 1day, it will not send anything and it will give the #value! on the sheets. The data will appear under form response 2.
//docs.google.com/spreadsheets/d/1EkZHmxZZQvLEyr5gXhKWDonfPlDLAPLngSEadYg47x4/edit#gid=1605730071


I hope the above is sufficient for you to check the issue.

Thank you!

It is resolved. Thank you so much Janmorris