Version Notes
1.2.3
Updates:
Added a tooltip to the "Total Cells Referenced" stat, to explain that this metric is calculated by Smartsheet and may have a delay. The tooltip explains why the metric might be too high.
Added a tooltip to the "Sheet Stats" popup which explains that all of the metrics are calculated by Smartsheet.
Bug Fixes:
- Fixed a bug where the first option in the SSFeatures menu displayed when it should not have, for both reports and sheets.
1.2.2
Updates:
- Updated the Automation Sheet Improver Tooltip to hover above the "improvements" button to not block the button.
1.2.1
New Features:
View Column Info
This feature lets you see all of the information about your columns, such as the name, type, formulas, descriptions, dropdown options, etc.
You can export this information to Excel as well.
Automation Workflow Style Improvements
- This feature updates the CSS style for several HTML elements in the automation workflow editor. This makes the editor easier to use. For example, previously it was difficult to read the text content in an email alert, because the HTML element could not be resized. SSFeatures now let's you resize it. Also, several sheet names, column names, and other text fields were truncated which made it hard to read the content. This now fixes that.
Updates:
The Cross Sheet Reference Viewer now provides a link that opens up the source sheet for each reference. The URL of this link is exported to Excel as well.
Added more English words to the dictionaries, so that they do not show up as misspelled.
The en_US dictionary is now built directly into SSFeatures, so that it does not need to be fetched from the CDN. If a company has a VPN that blocks the SSFeatures CDN, the user will still be able to use the en_US dictionary.
Updated the spell checker logic so that it doesn't include punctuation marks, such as ? and ! as part of the word.
Fixed a bug in the PDF generator where workspace logos were not displaying properly.
Added a reset button to the Bulk CSR creator, so that people can reset the input to the default "{SHEET NAME} - {COLUMN NAME}" format.
Added an error message popup to the PDF generator. If an error occurs while generating the PDF, the user will see the error message and can send it to our support email.
Added advanced options to the Bulk CSR creator, so that users can specify a capitalization style, and a delimiter.
Added a way for users to select exactly which columns they want to rename, when using the "Prefix / Suffix" or "Find and Replace" modes, to rename columns.
Added CTRL + Alt + G as an alternative key combination for opening the "Go To Column" menu.
Permissions:
- Added the host_permissions for "*.smartsheet.com" so that we can access URLs on the Smartsheet CDN directories. This allows us to fetch CDN assets, such as logos that have been added to workspaces. We need these images for exporting PDFs.
Bug Fixes:
Fixed a bug in the Automation Workflow paster, where conditions with multiple "or" clauses, were treated as "and" clauses. In other words, SSFeatures was not considering the proper logical operator for the conditions.
Fixed a bug in the Automation Workflow paster, where SSFeatures was unable to paste automations if they used sub-conditions underneath an action.
Fixed a bug where the user could use the bulk column creator, and bulk column renamer, to accidentally rename columns to be longer than 50 characters.
Fixed a bug in the PDF generator where certain characters would break the generator which would cause the spinner to spin forever. These characters were things like \n and 0x0009.
1.2.0
New Features
Bulk Column Renamer
- This feature allows you to quickly rename many columns at once. It supports 3 different modes, so that you can rename columns, find and replace column names, or add and remove prefixes from your columns.
Bulk Cross Sheet Reference Creator
- This feature allows you to quickly create multiple cross sheet references at once.
Cross Sheet Reference Copy and Paster
- This feature allows you to copy and paste cross sheet references between sheets.
Cross Sheet Reference Viewer
- This feature let's you view all of the information about your cross sheet references, and export the data to Excel.
Updates:
Improved the privacy of metrics that are sent to PostHog.
Improved the highlighting animation that shows the SSFeatures button for new users. This new animation makes the button way more apparent.
Improved the performance of unhiding all of the columns in the column visibility popup.
Removes the ability to "hide / unhide columns" if the user does not have the ACLs to do so.
Disables several buttons in the SSFeatures menu, and conditional formats menu, if the user does not have the ACLs.
Adds different date parsing options in the data importer. This allows the user to select how they want dates to be parsed, because the default logic was not working well for everyone. For example, it was not properly handing UK dates. Now the user can select between 2 different options, one that works better for non-NA time formats.
Added an explicit button in the "View Source Sheets" popup that lets the user open a location in a new tab.
Updated the sort popup, so that it automatically populates the initial settings based on the columns that the user currently has selected. Previously, it automatically populated using the most recent settings that the user had sorted with. However, multiple people mentioned that it would be better to use the columns that are selected, because these are the columns that the user is trying to sort with.
Updated the spellchecker popup to close when the user types a button, so that this popup gets out of the way of the user's vision.
Bug Fixes:
- Fixed a bug in the PDF exporter, where the spinner would sometimes spin forever. This was caused by SSFeatures trying to convert a hex color into an RGB color, but the hex color was not a valid format.
1.1.18
Bug Fixes:
Fixed a bug in the PDF and Excel exporter where cells with a value of '0' or '0%' were not being displayed in the output cell.
Fixed a bug while copy and pasting automation workflows, which caused the triggers for "Any Value" and "Blank" to be incorrect.
Fixed a copy and paste automation bug where "Clear Cell" actions were not populated correctly.
1.1.17
Updates:
Updated how the data importer handles dates from Excel. Previously, the code tried to convert it into a JS Date object and then pass that value into Smartsheet. This didn't work well with different timezones. Now the date is passed directly into Smartsheet, and it's up to Smartsheet to handle the date properly.
Added a warning in the data importer when the user tries to import dates, to help them understand how it works and to increase their chance of success.
Bug Fixes:
- Fix a bug where Smartsheet's menu remained open when opening the SSFeatures sort popup.
1.1.16
Updates:
- Updated the data importer to provide better error messages to the user, when they have an invalid filter.
Bug Fixes:
Updated a few places where the console would emit undefined errors on certain key presses.
Updated the data importer to support importing data directly into predecessor DATE_TIME columns.
1.1.15
Updates:
Updated the sort and automatic sorting feature to allow users to properly sort selected rows. Previously, if the user selected rows, then tried to sort, it would sort all of the rows, rather than the ones the explicitly selected. This is now fixed.
Sheet stats now shows the proper value for "Cross Sheet References". Previously, it only showed the value for the number of cross sheet references that were being used. Now it shows all of them, even the unused ones, which properly replicates Smartsheet's limits.
Bug Fixes:
Fixed a bug with the data importer, where filters were treating values as text, even when it made sense to treat the values as numbers. For example, the less than filter should always compare using numerical comparisons, rather than text comparisons. This was letting unexpected values through for users.
Optimized the spell checker to drastically improve performance when reading cells with large amounts of text.
1.1.14
Bug Fixes:
- Fixed a bug with the data importer, which did not respect Smartsheet's 4000 character cell limit. This caused Smartsheet to not be able to save the sheet with these cells in.
1.1.13
Updates:
- Added support for hyperlinks in the Excel importer. This only works when importing hyperlinks into a TEXT/NUMBER column.
Bug Fixes:
- Fixed a bug with the Excel importer, which prevented some sheets from loading. This occurred when the Excel file was missing a header row with column names.
1.1.12
New Features:
"Bulk Column Deleter"
- Allows you to delete more than 5 columns at a time.
"Bulk Column Creator"
- Allows you to create many columns all at once.
Bug Fixes:
- Fixed a bug with the spell checker that prevented it from correcting the misspelled word.
1.1.11
New Features:
"Copy and Paste Columns"
- Allows you to copy and paste columns between sheets, or within the same sheet.
"Column Templates"
- Allows you to create a template with columns, and apply the template to paste the columns into sheets.
Updates:
Updates SSFeatures to work with the Australian Smartsheet instance (https://app.smartsheet.au/).
Adds an "Unhide all button" into the "Hide / Unhide Columns" menu.
Adds a new menu to the SSFeatures debug menu which allows people to reset SSFeatures' settings. This is useful in case something breaks and they need to reset SSFeatures.
Adds a new menu to the SSFeatures debug which allows people to import their SSFeatures settings.
Adds progress spinners while generating PDFs and excel files.
Adds progress spinners when pasting automation workflows.
Bug Fixes:
- Predecessor "Date Time" columns used to appear as "Date". Now they properly reflect being "Date Time" columns.
1.1.10
- This version was built and released on Chrome but it didn't functionally have anything different than 1.1.9.
1.1.9
Updates:
Update SSFeatures to work with the Australian Smartsheet instance (https://app.smartsheet.au/).
The spellchecker now only runs on text columns. This will help improve the performance of the spellchecker by not needing to run on the other column types.
Optimized the spell checker by slowing down how fast SSFeatures tries to create the spell checker underlines.
Reduced the resource consumption for automatic sorting.
Bug Fixes:
- Fix a bug in in "Import data into this Sheet" which failed when the file had empty rows.
1.1.8
New Features:
"Report Column Descriptions"
Allows you to see column descriptions in your reports from the source sheet columns.
If your sheet contains more than 5 source sheets, the descriptions will only be pulled from up to 5.
"Report View Source Sheets"
Allows you to view information in your reports, about the source sheets used in your report.
This includes data such as:
- The workspace and folder where each sheet lives
- Buttons to open the sheet, folder, workspace, or report (in the same or a new tab)
- Your permission level on each sheet
- Who created it
- When it was created
- The sheet’s ID
- The direct link (URL) to the sheet
Updates:
- Removed some dictionaries because they loaded too slowly.
Bug Fixes:
Fixed a bug where the "Hide / Unhide Columns" quick menu "eye" icon briefly showed up in the top left corner while the page was loading.
Fixed a memory leak in the spell checker, caused by the highlight underlines not being cleaned up correctly.gg
1.1.7
New Features:
- "Export to Excel"
- Allows the user to export sheets and reports to Excel.
- Supports grouped and summarized reports.
- In sheets, supports exporting column descriptions.
Updates:
The "Import into this sheet" feature no longer allows the user to select columns with column formulas, as it doesn't make sense to import data into these columns.
The "Import into this sheet" feature will now try to automatically detect and map the columns for you, by attempting to match the file columns and the sheet columns by name.
The PDF generator now properly ignores hidden columns, and will not show them in the generated PDF.
1.1.6
Bug Fixes:
- Fix a bug with Import Sheet. Previously, SSFeatures attempted to use the parsed Date, even when the column wasn't a date column. This meant that values such as "01/01/2000 12:00" would be parsed as a date and inserted into the cell, even if the user wanted the raw text. Now we always try to use the raw text directly from the source file, and only try to convert into dates if the column is a Date column.
1.1.5
Bug Fixes:
- Fix the report and sheet PDF generator so that it works properly with Predecessors. Previously, the "start date" and "end date" did not appear correctly, and had the correct date but an incorrect time. This column now just shows the date. Also, the Predecessor column showed a JSON string, when it should have shown the human-readable string. These are both fixed.
1.1.4
Update:
- Fix the build process so that Mozilla developers can properly build the source code and verify it.
1.1.3
Updates:
Enabled the PDF generator in sheets.
Updates the stats popup to show the number remaining, and the capacity percentage for each stat that has a limit.
Adds a filter in "Find Column IDs" popup, that allows the user to search for specific columns by using their ID.
Retain usage metrics in the local browser storage, so that the user can track which features they use the most.
Disabling the spellchecker will now immediately remove all of the spellchecker highlights. Previously, you had to refresh the page.
The report PDF generator will remember your most recently used settings. When you generate a report PDF for the first time, the most recently used settings will be used automatically.
Hides the alert settings options when viewing stats in a Report, because it doesn't make sense to show these settings in reports. Alerts aren't used in reports.
Makes the stats popup smaller in a Report.
Bug Fixes:
- Fix a bug where certain types of popups were not showing user metrics.
1.1.2
Bug Fixes:
Fixed a bug in "Set Capitalization" for words like "McDonalds" which was converting it into "Mcdonalds" when using "First Letter Upper Case".
In the PDF generator, added more vertical spacing between the text for a grouped row. The texts were sometimes overlapping in the generated PDF.
In the PDF generator, fix a bug where cells were not appearing with certain types of complex cell or column formulas.
1.1.1
New Features:
Import Into Existing Sheet - SSFeatures now lets you import data directly into your sheet.
This supports Excel, CSV, TXT, and ODS files.
You can also filter your data, merge data into your sheet using a primary key, and replace the data in your sheet.
This gracefully handles all of the different column types in Smartsheet. For example, if you import emails into a contact column, SSFeatures will create all of the contacts for you.
Sheet Limit Alerts - SSFeatures will now send you alerts when your sheets start approaching a limit. You can configure these settings in the "Sheet Stats" menu.
The spellchecker now supports 80 languages and dialects.
You can disable the spellchecker on specific columns.
Updates:
Made many improvements to the spellchecker dictionaries to be more accurate.
Made many performance improvements to the spellchecker to make it less laggy.
Removed columns with column formulas from the "Set Capitalization" popup.
Updated the capitalizer to not modify cells that have cell formulas.
Added the standard column filters to the "Go to Column" and "Find Column IDs" popups.
Renamed "Settings" to "Views" in the "Hide / Unhide Columns" popup.
Bug Fixes:
Fix a bug where the SSFeatures menu could be clicked, even when the Form editor was visible.
Fixed a bug while copy and pasting automations, which occurred when using "When a Date is Reached".
Fixed a bug where clicking on a tooltip in a popup would close the popup.
1.1.0
New Features:
Capitalization Manager - Allows you set the capitalization format for your columns. You can find this in the SSFeatures menu under the "Set Capitalization" menu.
Remove Columns from Conditional Format Rules - Allows you select a column, and then remove that column from all of your conditional format rules.
- Especially useful if you need to delete a column that is currently being used by the conditional formats.
"Hide / Unhide Columns" Settings Quick Menu - Added a button on the right hand side pane that lets you quickly open and load your "Hide / Unhide Columns" settings.
Updates:
Updated the "hide / unhide columns" popup to move the "fx" column formula icon to its own column.
Added tutorial popups to help users learn how to use SSFeatures.
1.0.15
New Features:
- Automation Workflow Copy and Paste
- Allows you to copy and paste automation workflows within the same sheet or between different sheets.
Updates:
- Added the total number of referenced cells into sheet stats, and displays the 25M limit.
- Updated "go to column" keyboard shortcut hint to be more apparent.
1.0.14
Updates:
- Removes the "Contact Us" button from the Safari version.
1.0.13
Updates:
- Adds additional guardrails to prevent the bug from version 1.0.10, which caused the subscription popup to appear when it shouldn't have.
1.0.12
Bug Fixes:
- Fix a bug that made it seem like people's subscriptions ran out.
1.0.11
Rollback:
- Rollback version 1.0.10 to version 1.0.9
1.0.10
Updates:
- Added a tooltip for new users to show them the SSFeatures toolbar button.
- Improved the "hide / unhide window"
- Tooltips to explain filters and settings
- Save button to help users who get stuck not realizing how to persist the data.
- Moved the save, load, and delete buttons to the top, next to the filters.
- Added tooltips to the sort popup.
1.0.9
Updates
- Adds support for Smartsheet Gov.
1.0.8
New Features:
- Filter Sort - Allows you to sort data even with filters enabled.
- Sort settings - Allows you to save, load, and delete sort settings.
- Added the column visibility manager into Reports.
Updates:
- Added text in the column visibility manager to show when a column is the primary column.
- Updated all of the icons to load quicker.
- Added new icons to the menu to make it easier to identify the menu options.
Bug Fixes:
- Fixed a bug in "report stats" which showed the row count as 2500 even when there were more than 2500 rows.
1.0.7
New Features:
- Column ID Finder
- Popup that helps you quickly find and copy the column IDs. This is especially useful for API and Smartsheet Bridge users, since Smartsheet does not natively provide a way to access the IDs.
- Sheet Stats
- Popup that displays statistics about your sheet or report. Currently supports the number of rows, columns, cells, and cross sheet erferences.
Updates:
- Added the column type to the "Hide / Unhide Columns" popup.
- Added the an icon to indicate if the column contains a column formula to the "Hide / Unhide Columns" popup.
- Added a "Hide / Unhide Columns" button into the toolbar for easier access.
1.0.6
Updates:
- Adds a highlight animation to the SSFeatures toolbar button for the first time that new users open the extension.
- Add new metrics for the conditional format copy paster, deleter, and bulk cloner.
Bug Fixes:
- Fix a bug while loading column visibility settings which sometimes caused 1 extra column to be visible, even when it wasn't included in the settings.
- Fix a bug while loading column visibility settings which sometimes the settings to not load correctly, if a column was previously deleted from the sheet.
- Fixes a bug in the PDF generator which did not show checkboxes if the cell contained unsaved modifications.
1.0.5
New Features:
- Conditional Format Copy and Paste
- Allows you to copy and paste conditional formats between sheets or within the same sheet.
- Conditional Format Mass Deleter
- Allows you to delete multiple conditional formats at the same time.
- Conditional Format Clone Rule for Columns
- Allows you to select a rule, then select columns, and then SSFeatures will clone the rule for each column.
- Added configurations that allow to quickly hide and unhide groups of columns in the "hide / unhide columns" menu.
- Added a "Go to Column" button that makes it easy to quickly find a column in a sheet or report. You can open this with Alt + G or Option + G.
- Added a "Go to Column" button in the column visibility popup.
- Added an option in the PDF generator that allows you to filter the rows down to just the grouped rows or just the non-grouped rows.
Updates:
- Updated all of the filter buttons to be fixed to the top of the popup, rather than scroll. This makes it easier to use the filters.
Bug Fixes:
- Fix a bug in the Conditional Format copy/paster and cloner which incorrectly set the selectable dropdown options.
1.0.4
New Features:
- [Beta] Conditional Format Copy and Paste
- Allows you to copy and paste conditional formats between sheets or within the same sheet.
- [Beta] Conditional Format Mass Deleter
- Allows you to delete multiple conditional formats at the same time.
- [Beta] Conditional Format Clone Rule for Columns
- Allows you to select a rule, then select columns, and then SSFeatures will clone the rule for each column.
Updates:
- Added support for Smartsheet EU (https://app.smartsheet.eu)
- Added support for Smartsheet WorkApps (https://workapps.smartsheet.com, https://workapps.smartsheet.eu)
Bug Fixes:
- Increased the PDF generator buffer deadline to reduce the chance of errors.
- Fixed a bug in the PDF generator that removed the background color on unchecked checkbox cells.
1.0.3
Updates:
- Added metrics for spell checking and hiding and unhiding columns.
- Added popups to display account status in the auto sort, PDF generator, and column visibility manager.
Bug Fixes:
- Fix a bug that caused some popups to be broken in Smartsheet. Typing keys was causing Smartsheet to edit cells, even when a popup was open.
1.0.2
New Features:
- Hiding and unhiding individual columns.
- Smartsheet does not let you unhide individual columns, they force you to unhide all of the columns, then manually re-hide the columns.
- This feature adds a "Hide / Unhide Columns" button, which opens a panel for you to manually hide and unhide the exact columns that you want.
Updates:
- Updated the PDF generator to include the company logo and workspace logo when "include logo" is enabled.
- Added support for the new Smartsheet symbols in the PDF generator.
- Added support for checkbox, flags, and star icons in the PDF generator.
- Updated the PDF generator to support column names wrapped on multiple lines.
Bug Fixes:
- Fixed a bug with the spell checker, which prevented the spell checker from working in the Card view.
- Fixed a bug where the SSFeatures menu sometimes did not show up.
- Fixed a bug in the PDF generator where the default row and column formats were not being applied to the cells.
