Excel Formulas That Work in Project and Dashboard Views
DESTINI Estimator utilizes Spreadsheet Gear for the Excel-like interface within the Project and Dashboard Views. We recommend building new Project View Workbooks and Dashboards within Excel for a more streamlined approach to building the templates; however, utilizing supported Excel formulas is critical for success.
Here is the link to the supported Formulas in Excel that can work in the Project and Dashboard Views - Supported Excel-compatible formulas.
Note: Our current Spreadsheet Gear Version is 9.3.52.102. Some formulas like XLookup will not work. Reference the unsupported functions link within the above documentation for a comprehensive list.