Encountering NULL as the outcome of the DR.GET() formulas is common and can typically be resolved by following these steps:

1. Ensure that your Excel Spreadsheet is connected to Datarails by verifying that you can see the "Submit" icon in the Datarails Ribbon.

2. Ensure that the function used in the formula is added to the spreadsheet.
You can verify this by following these steps:

  a. Navigate to the "Datarails Addin" menu, then select "Functions" and choose "Manage Functions."

  b. Locate the necessary function in the list.

  c. Ensure that you see a "-" icon next to it.

If not, click on the "+" icon and then click on the "Datarails Refresh" icon.

3. Confirm that the formula parameters contain the correct values and references.

November 13, 2023 13:18