Hello fellow Appsheet users - first time that I’m posting a question here but have been working in Appsheet regularly since Feb 2020. I hit a wall when trying to integrate MMULT() as a “Spreadsheet Formula” into one of my columns.
Has anyone found a workaround on how to apply Excel formulas that are unsupported by Appsheet?
The interesting thing is that the formula shows up in the “Spreadsheet Formula” field of my column but it won’t apply it when new rows are added. Rather, it causes the app to error out if I leave it there.
I’ve resorted to copying down (Ctrl-D) the formula in Excel manually for new rows but this isn’t ideal.
Any native or third party workaround suggestions are welcome. I already checked out integromat but their support team told me that copying down a formula isn’t something they support.