Top priorities on our roadmap:

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

Dragging a cell to copy 👉

• You can drag a cell to copy it over a range the same way you could in Google Sheets or Excel

Force refresh 🔄 👉

• You can now refresh your raw data manually if at any point you want to make sure you have the latest data.
• You just have to click on the refresh icon at the top right
• You can also use the shortcut on Mac option + 9

👈 Loader in filter by values

• When you import data, it takes us a bit of time to index all of the values of each column
• This means that when opening the filter by values menu, it could be blank
• Now we have a loader there so you know your list of uniques values is coming

Bug fixes 🦟

• The border formatting was not working anymore, it's now fixed.
• The message error during spreadsheet loading was appearing very often, we made some fixes to prevent this.
• The contextual menu was not disappearing after choosing an option within it, this is now fixed.
• Cutting and pasting a cell or range would lead to unexpected grey formatting, this is now fixed.
• As a collaborator, you couldn't edit the import created by another user from your workspace. This is now fixed.
• The highlighting of table columns when writing formula was not working when the said column had a space in it, now fixed.
• Resizing a column or row where there's a hidden column or row was not working well. now fixed.

Quality of life improvements 🍹

• When formatting numbers to dollars, you now will have no more than 2 decimals. You could previously have many decimals which was frustrating.
• The average and counta formula can now be used on any range of the spreadsheets (before that, it was only using table columns)

🤝 Work with your colleagues in Actiondesk

• You can now invite collaborators to Actiondesk
• Head to the profile icon and click on Invite Collaborators
• Enter the email addresses of your collaborators
• They will then receive an invite to create their account

• If they're okay, we can just delete their account. Shoot us an email and we'll do that for you
• Another workaround is to invite a different email address. If you want to invite jonathan@actiondesk.io who already has an account, then send the invite to jonathan+actiondesk@actiondesk.io

🏎 You can now fly through the import menu with your keyboard

• Press enter to enter in any dropdown
• Press tab to go to the next step
• When selecting columns, you can navigate in the list with up and down arrows, and select / unselect a column by pressing space
• Once you're done selecting column, press tab and then enter to proceed with the import

🛠 Manage your data sources 👉

• You can now see the list of all your data sources and delete the ones you don't need anymore
• Press on your profile icon, and then Manage data sources to access this menu
• Soon, you'll be able to edit them as well

😻 Emoji in folders

• You can now add emojies to your folder
• Open the left menu, hover over the folder, and you'll see the emoji icon appearing, press on it and then select your emoji

🎨 See active sheet and open sheets in the left menu 👉

• You'll have a purple dot on any sheet that's open
• The active sheet (the one you're currently looking at) will also have a purple bar on the left

🐞 Bug fixes

• There was a bug where a lookup function written in small letter wouldn't work. Fixed ✅
• There were some issues with Airtable imports where some formulas would return errors and calculations would generally be slow. This is now fixed and the performance has been greatly improved. ✅
• There was a bug where if you clicked on the formula bar when you your cursor on a calculated column, the content of the column would disappear. Fixed ✅
• The import button sometimes didn't work properly. Fixed ✅
• Formulas would be broken if you changed the name of the sheet containing the data used in the formula. Fixed ✅
• The loader on the Add a data source button wouldn't always display. Fixed ✅
• The operator >= didn't work for some time, now fixed ✅
• Finally, when applying percentage formatting, you'd have many decimals that you'd have to reformat. Fixed as well ✅

Quality of life improvements

• Shortcuts to fix cell references.
• Instead of adding $ manually to fix a cell reference, you can just use Option + 4 (Mac) / F4 (Windows).
• Use it once to fix the reference entirely (both rows and columns)
• Twice to fix the row
• Thrice to fix the column
• If you're used to using F2 to enter in a cell (like in Excel), it now has the same behavior in Actiondesk too

New Stripe and intercom imports

• You can now import companies from Intercom
• You also import charges and Balance transactions from Stripe

New search bar to search sheets

• We've added a search bar to search your sheets. Hit Cmd + P (Mac) / Ctrl + P (Windows) to access the search bar on the left menu.

Filters within filters

• Filters: If you apply a filter on a first column, then the available option in the filters of other columns will be filtered out

Bug fixes

• Fixed multiple issues linked to download csv
• Fixed an issue that led to the RIGHT formula not to work properly

Drastically improved stability and reliability

• We fixed most of the issues that could lead to table data not being loaded and formulas not returning a result.
• Formula errors: You now have a detailed error message when a formula you write is wrong. We'll keep on improving these to make it as easy as possible to debug a formula.

New integrations

• Stripe. See all Stripe related use cases
• Intercom: See all Intercom related use cases
• Airtable: See all Airtable related use cases

Quality of life improvements

• If you write a formula or add a filter on the right of your screen, it will be offset so that it's not hidden by the end of the screen.
• If you scrolled down a table, and then apply a filter, it will scroll up automatically

Bugs

• We fixed 67 bugs 🐛in the past 9 weeks 🤯mainly improving the way writing a formula works
• There was a bug that didn't let you erase the last sheet at the root of a folder. This is now fixed ✅

New features

• New import menu 👇
• It's now easier to choose columns you want to import with checkboxes.
• We also added a select all and clear options

• You can now hide several columns or rows at the same time. Just select columns, rows or a range, right click and then choose Hide columns or Hide rows

• If you add emojis to your sheets, they'll now be displayed also in the bottom tabs ☝️

Before:

After:

• Just hover on your sheet title
• Click on the emoji icon
• Choose your emoji

Folders and organizing sheets 🗂 👉

• Create folders
• Move sheets to a specific folder
• Create sub folders and sub sub folders
• Delete folder
• Rename your workspace
• Expand / collapse the content of each folder

Bug fixes and improvements 🛠

• ✅ Fixed some issue with the copy paste to a table.
• ✅ In the case where you had a lookup using data from a user generated table, and you changed the data in that table, it wouldn't change immediately the results of the lookup. It's now fixed
• ✅ Fixed a bug that prevented some users to download a sheet to csv
• ✅ Fixed some bugs related to SQL queries imports
• ✅ Fixed several issues related to writing and editing data into a user generated table

UI improvements 🎨

• Tabs
• Formula bar

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)