the report run from the jet portal found the name error as i run from the excel the all data are fine no error but same report run from the jet portal gets error ie. name error i check all the possible solution but didn't get solution.
your help is appreciate please suggest me the solution.
i use the formula =IF($O22=""," ",DAYS(today(),O22)) to caculate days. O22 contain a date example 7/17/2018 and some cell contain blank date i.e. no any date. after running report from jet web portal and i open in excel but the result is #NAME error. i checked the it support all the function.
Are you using the latest version of the Jet Hub?
Again, I am not able to duplicate any issue with that Excel function. I am able to schedule that same report, send it via SMTP, and open in Excel.
I would suggest you submit a request to the Jet Tech Support team.