Product Ideas

Share your suggestions and ideas. Vote on ideas you find valuable.

Web Portal does not support all commands

I have created various reports having e.g. Excel formula's. These reports run fine on my local PC but on the web portal I get problems loading / running these reports. Having the supported commands 100% in sync would be much approciated

  • Gert Leen
  • Aug 14 2017
  • Planned
  • Nov 28, 2018

    Admin Response

    With each new major release, Jet adds more Supported Excel Functions to our Jet Hub.  The complete list can be found in this kb article:  https://support.jetglobal.com/hc/en-us/articles/219402987-Jet-Web-Portal-Feature-Support

    Several ideas have been created in this portal for individual functions. Please review and vote and/or submit an idea about a function you would like to see supported in Jet Hub.

    Excel function support releases:

    Jet 2019 CU2 (19.2.18311.1):  SEARCH

    Jet 2019 (19.0.18268.1):  WORKDAY.INTL

    Jet 2018 (18.0.17307.5):

    RADIANS

    FACTDOUBLE

    SEC, SECH, CSC, CSCH, COT, COTH, ACOT, ACOTH

    RANK, RANK.EQ, RANK.AVG

    CEILING.MATH, FLOOR.MATH

    STDEVA, STDEVPA, VAR.S, VAR.P, VARA, VARPA

    TIMEVALUE

  • Attach files
  • Kim Duey commented
    September 06, 2017 19:19

    We are certainly looking at adding other Excel function support.  In order to help us prioritize, which are the most significant unsupported functions to you at the moment?

  • Johannes Herlitzius commented
    June 08, 2018 14:09

     I didn't read this comment so I posted the sames message already as a comment here:

    https://jetideas.ideas.aha.io/ideas/JETPRO-I-159

    I don't know, if it helps you to prioritize functions, but for me it would be very helpful, if the CONCAT() function is supported by the Web Portal. Sorry for double posting. Thank you.