Custom functions in G Sheets

Because Dextrous uses CSV data from Google sheets, it's not automatically compatible with Google sheet custom functions. (When you use custom functions in your g sheet, csv share to web doesn't work and results in cells containing #NAME?). Here is a cool solution provided by one of our legendary designers.
This work-around bakes the value results from a sheet that uses custom functions, to a new sheet. You can share the new sheet to csv as normal and that will work with Dextrous. Here's the custom function:
const bakeSourceName = 'Dex';
const bakeDestinationName = 'Export';

function BakeExport() {
const ss = SpreadsheetApp.getActive();
const src = ss.getSheetByName(bakeSourceName);
const dst = ss.getSheetByName(bakeDestinationName) || ss.insertSheet(bakeDestinationName);

// Get full data range from source sheet
const lastRow = src.getLastRow();
const lastCol = src.getLastColumn();

// Get only evaluated values (not formulas)
const values = src.getRange(1, 1, lastRow, lastCol).getValues();

// Clear and overwrite Export sheet
dst.clearContents();
dst.getRange(1, 1, values.length, lastCol).setValues(values);
}

function onEdit(e) {
const sh = e.range.getSheet();
if (sh.getName() == bakeDestinationName) return;
BakeExport();
}