• Using formulas in spreadsheets

  Conduit offers two ways to transfer data to spreadsheets: Building block “Save dataset to Google Sheets” Formulas In this article, I will talk about using formulas. Conduit supports two formulas to be used in Google Sheets. REPORT - Place a table to a spreadsheet METRIC - Place a single metric to a spreadsheet REPORT The Report formula copies a table from Conduit into a spreadsheet. It has four parameters: report startdate days rowcount report- data sourPopular

• Time range in formulas

  Every REPORT and METRIC formula has a time range. In order to guarantee high speed of processing the time range has a limit. By default the limit is 30 days. You can change it. There are two ways to define a time range for the formula: Direct parameters of the formulas Set a time range for the workflow The first approach is better for the “production” spreadsheets. The second approach is better for prototyping, because you don’t waste your time on entering these parameters. DirectFew readers

• Writing data to spreadsheets: Overwrite and Update

  Conduit offers two distinct methods for writing data to spreadsheets: Overwrite and Update. Overwrite Method: In this approach, Conduit clears all existing content within the spreadsheet before writing new data. This method is straightforward but removes any previous information. Update Method: This method preserves existing data, appending new rows at the spreadsheet's end. It's particularly useful for adding more columns and applying specific formatting without losing existing data.Few readers