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.
thank you.
Hello Ramesh,
it seems that you use a function from Excel that is not supported by the Jet Hub. If you want to know, which function is currently supported by the Jet Hub, then please have a look here:
https://jetsupport.jetreports.com/hc/en-us/articles/219402987
Let me know, if this helps.
Best Regards.
in report
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.
Hello Ramesh.
Are you sure that is the cell that is causing your issue? I am able to use the function in both Excel and the Jet Hub:
Are you using the latest version of the Jet Hub?
I am using this as report running for scheduler to send mail daily
Hello Ramesh -
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.
