Top priorities on our roadmap:

• Being able to create a table with manual inputs, and not only imported data
• Better error management for formulas
• Basic collaboration

Copy and paste CSV to a table

• If you need to use data from a CSV, you can now easily paste this data into a user generated table in Actiondesk and mix it with dynamic data coming from your data sources

Onboarding flow

• We now have a new onboarding flow to show new users the most important features of Actiondesk

Bug fixes and improvements 🛠

• Fixed a bug that made impossible the edition of custom SQL query imports
• Fixed many small bugs related to user generated tables

👻 Hide column or row 👉

• You can now hide a column or a row
  • Right click on a cell or on a column / row
  • Then choose Hide column or Hide row option
  • To unhide, simply click on the double arrow between the columns
• Limitations
  • You cannot hide several columns or rows at the same time

Bug fixes and improvements 🛠

• You can now rename the headers of a user generated table as well as notes columns
  • Limitation: Avoid renaming columns once you have computed columns or formulas using these columns. It will break things.

👈 User generated tables 🏓

• Previously, you could create a table only by importing data from a data source. You can now create a table from scratch and manually fill it
  • Right click anywhere and choose Insert table
  • Fill the table with data
  • To add a column, just write the title of the column on the right of the headers
  • To add a row, just write data in any of the cells right below the table
• Current limitations
  • You cannot rename the headers, we'll fix that asap
  • You cannot copy and paste data into the table

Bug fixes and improvements 🛠

• Fixed a bug that prevented users from editing a SQL imported table ✅
• Fixed one display issue with data overlaps ✅
• Fixed various bugs linked to the Notes columns feature that we released the week before ✅
• Fixed a bug that led to formulas not working when inserting a column. ✅
• Fixed a bug where aggregation formulas were displaying "..." forever if you made a syntax mistake in the column reference. It now returns an ERROR ✅

Notes columns 🗒️

• Previously, you could only add calculated columns
• Now, you can add a column and write text or numbers in it.
• What you write in these columns will always stay associated to the right record, even when you data refreshes

• This won't work for tables created before we shipped the feature, only for new tables
• For it to work, you need to make sure you import the primary key field of your table (generally the id for SQL, vid for Hubspot contacts, dealid for Hubspot deals, etc)

Insert / Delete column and row 👀

• You can now insert a row, insert a column, delete a row, delete a column
• Just right click on any cell / column / row and you'll have the various options available
  • Insert 1 column left
  • Insert 1 column right
  • Insert 1 row above
  • Insert 1 row below
  • Delete column
  • Delete row

Desktop app 🖥

• Brand new desktop app for Windows, Mac, Linux. Download it here

Bug fixed and improvements 🛠

• Fixed a bug that led to not being able to select a column from another sheet when this column was the same column as the one where you're writing the formula ✅
• Fixed a bug with the cut paste that led to some problem when copying and pasting something right after having cut something else ✅

SQL: Support for private schemas 👀

• If you have tables you need to use that not in the public schema, you can now use them as well
• They will appear in the dropdown "choose your table" prefixed with the schema name: schema_name.table_name

New formulas 🧮

• No need to do a sum / sumif and divide by a count anymore 😁
• Average
• Averageifs

Bug fixes and improvements

• Fixed a bug that led to the error message you already have a spreadsheet with this name when entering in the sheet title, doing nothing and pressing enter (or clicking anywhere else) ✅
• When you cut and pasted a range containing empty cells, it pasted a 0 instead of an empty cell. This is now fixed ✅
• Fixed a bug that led to the formula bar being empty when you were pressing escape on a cell containing text or a formula ✅
• Fixed an issue that led to a cell appearing empty if you applied the % format on an empty cell and then wrote on it ✅
• Fixed a bug that led to empty dates appearing as Invalid date for hubspot imports ✅
• Fixed an issue that made the selection of a column not possible when editing an existing formula from the formula bar ✅

Copy and paste Unique 🤯👉

• Right click on any cell of a column from an imported table
• Select "Copy Unique"
• Paste your unique values wherever you'd like

👈 Include function

• New function: INCLUDE(substring, string)
• Include returns TRUE if the string contains the substring, FALSE otherwise
• Include can be used in a computed column or in the spreadsheet

🤖AI experimentation

• This is not in production at the moment but we started playing with the GPT-3 API from OpenAI
• It could power a "Ask me Anything" function, which given a question as an input would give you what you need.
• See example where we ask the population of a list of countries 👉

Improvements made on the spreadsheet experience 🤓

• Modified the table loader, see screenshot on the right 👉
• Made improvements to the way aggregation calculations are made. Now when you change a parameter, only formulas that depends on this parameter will recalculate instead of all of them previously 🏎
• Fixed a bug: when you were selecting a range with Cmd + shift + arrow (or control + shift + arrow for windows), and part of the range was out of the screen, the screen was not moving. It's now solved. ✅
• Fixed a bug that led to some basic math operations (particularly ratios) to return ERROR ✅
• You can now write formula names in small letters, it will work whereas it previously didn't
• We now automatically close parenthesis if you forget a parenthesis in a formula both in the spreadsheet and in computed columns
• Improved cut paste: There was some issues with the paste of the format that are now fixed
• Fixed bug related to decimal formatting that led to users not being able to remove decimals from a calculation ✅

Improvements made to aggregation formulas 🧮

• Fixed a bug that led to aggregation formulas not calculating unless you opened the sheet with the raw data. ✅
• Fixed many bugs related to aggregation formulas. It happened frequently that some formulas wouldn't return a result unless you refresh the page. It's now not happening again. ✅

Improvements on imports 💪

• Fixed a bug with edit of imports which was not working properly anymore ✅
• Fixed a bug that messed up the order of columns when you edited your import after having added a computed column ✅
• Fixed a bug with led to the sheet not loading when adding a computed column after a filter. ✅

Error management 😓

• If there's a problem with a filter, instead of blocking you, you'll get an error message saying the filter has encountered an unexpected problem. The filter will be removed, and you'll be able to continue working on your data.
• If there'a an error with a computed column, or an aggregation formulas, it will now always return an error and not block you while working on your data.

Better management of null values 0️⃣

• Previously, null values were appearing as zero. They now appear as blank
• You can now do a condition test on null values. If the column "test_column" has some null values in some records, and you add a computed column with the formula =#test_column="" , these records will return true.
• If you a calculation with null values, they'll be considered as zero. If "test_column" is null, then =#test_column + 1 will return 1

New Hubspot integration

• Connect your hubspot account to Actiondesk
• Import deals, companies and contacts data
• See demo here

🔎 Lookup

• You can now retrieve columns in one table from another table using a matching key
• Tutorial here.

🏎 Computed columns

• You can now add a column to your imported tables and write a formula in this table using other columns from the table.
  • This formula will automatically apply to all the rows.
  • As your table refreshes with new data, the formula will automatically apply to the new rows.
• You can edit just by entering in any cell of the column and changing the formula
• You can delete a computed column by right clicking on any of the cell of the column and choose "Delete column"
• Some use cases
  • Calculate a price segment
  • Return the month of an order / event / etc with the format "YYYY_MM"

New formulas

• YEAR: returns the year of a specific date
  • Ex: YEAR(02/02/2020) will return 2020
• MONTH: returns the month (as a number) of a specific date
  • Ex: MONTH(02/02/2020) will return 2

Bug fixes & refinements

• Fixed a bug that led the input dropdown in the import menu to not be clickable
• If you write a cell reference in small caps, it now works
• Fixed a bug that led to duplicates in the filter by values component on dates
• Fixed a timezone related bug that led to problems connecting databases for some users
• Fixed a bug with the autocomplete component
• We changed the "In between" filters operator on dates. It used to exclude the start and end dates. It now includes them.
• Fixed a bug that led to the sheet freezing when doing cmd (or control) + bottom arrow and going to the bottom of the sheet
• New "New sheet" button right by the tabs. Easier to access.

New formulas

• Countif, Sumif
• Countunique, countuniqueif, and countuniqueifs

References between sheets 🔗

• In formulas, you can now reference to cells, ranges, columns from imported tables from other sheets.
• As Actiondesk doesn't have a concept of files, it means you can reference to any sheets that exist in your workspace 🤯

Significant performance improvements 🏎

• There were lags when scrolling down an imported table. You can now easily scroll down thousands of rows without any lag.
• You can import up to 100k records. Loading and computing of aggregation formulas will take 5-10 secs but it will work. We don't guarantee performance, but you can even try 500k rows
• There were lags in the spreadsheet when you had more than 10 aggregation formulas, this has been fixed

Bug fixes & Refinements 🔧

• When scrolling down on a table, you'll now still be able to access the filters
• You now don't have to click on the arrow for filter by condition and filter by values, you can just click on the text
• Fixed a bug that caused filter on date ranges to be inaccurate
• Fixed a bug that caused filter in exact date to not filter
• Fixed a bug that caused tab names not to be updated when renaming a sheet
• Fixed a bug that caused columns from an imported table to be loaded not at the same time

Filter by values

• Like in Google Sheets and Excel

Filter on dates

• Four date operators
  • Is exact date
  • Is after
  • Is before
  • Is between

New integration SQL Server 🥳

Edit cell content from the formula bar 🤓

Tabs!! 😇

• Have several sheets open
• Toggle easily between them through bottom tabs
• Coming soon: references between several sheets

• Is Equal to
• Is not Equal to

• Is Equal to
• Is not Equal to
• Is greater than
• Is greater than or equal
• Is less than
• Is less than or equal

• Filter by values like in Google Sheets and Excel
• Filter on dates

New functions

• TODAY: Returns the current date
• NETWORKDAYS: Returns the number of net working days between two provided days.

Aggregation formulas are now reactive

• The criteria columns is a column from an imported table
• The criteria is another cell

Three new shortcuts

• Open the left menu with Cmd + [ (Mac) / Ctrl + [ (Windows)
• Open the right import menu with the shortcut Cmd + \ (Mac) / Ctrl + / (Windows)
• Lock cells
  • Within a formula, you can toggle between locking the cell, locking the row, locking the column with Option + 4 (Mac) / F4 (Windows)