I was curious if anyone knows why some functions in Excel will cause errors while others will not. For example on the report tab if you use the function CONCATENATE it works perfectly fine but if you use CONCAT the function will throw an error until you click the enable editing button when you first load the report.

It's not a problem if you are going to be opening the report, but if you have a graph or chart that relies on that data it will not load on the dashboard.

I'm pretty sure his has something to do with what version of Excel Geotab supports. CONCATENATE is a deprecated function that has been replaced by the newer CONCAT. I have a report that relies on the use of MAXIFS and MINIFS but until I load the report itself and enable editing I just see all NAME errors.

If this is because of Geotab not supporting the newer Excel functions are there any plans to add them in the future?

Thanks,