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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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. 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.

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.

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.

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.

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. Bug Fixes: - Fix a bug that displayed the account popup when it was not supposed to. Updates - Add guardrails to prevent the account popup bug from happening again. - Removes the contact us button from the Safari version.

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.

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.

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.

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.

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.

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.

- Adds support for generating PDFs for Reports. - Generate PDFs for reports, grouped reports, and summarized reports. - Supports normal reports, and "grouped" and "summarized" reports - Supports PDF generation, printing, and emailing - Customizable PDF options, such as page style, scaling, row numbers, page numbers, and time stamps - Generates PDFs that use the same exact dimensions and data as your Report, unlike SmartSheet's PDF generator which changes the format and skips groups and summarizations - Adds a spell checker setting to enable spell checking on primary grid cells. - Provides a popup explaining the details about enabling this feature on primary grid cells.