Formula works in Sheets not Only Office

Docs
, , , ,
1

Document Server version: idk (cryptpad.fr)
OS: Windows 10 Version 22H2 (Build 19045.3208)
Browser version: Vivaldi 6.1.3035.111
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36

I’m trying to get the most recent date from a speaker (reference: microsoft excel - Return First Column Header of Instance of String - Super User) The answer I provided works in Google sheets but not in onlyoffice. Is there a syntax I’m missing some where? Each of the formula components look to be identical but I’m getting #VALUE! in onlyoffice.

2

Hello @depperm

Document Server version: idk (cryptpad.fr)

I would like to get information about version of Document server. I’m not familiar with this installation, so if it’s possible, please contact their support team and ask them.

As for the issue in general, please provide us with test file and exact issue scenario. We will check it out.