Best Of
Re: Request for Rollback - create sheets in Sheets folder
I would like to also share my concerns. Like many others, getting Smartsheet adopted into our workflows took a lot of work. Having this change without any notice of it coming or how it was intended to work has forced my team to be bombarded with questions as to how to function. We are not able to handle these questions and it is causing our management lose confidence in the platform. Unfortunately for us, this change has came at a time that we are restructuring data and streamlining our smartsheet information. As I am in talks with others also responsible for classifying data, I do not have a solution to stand behind because I do not understand how this "update" is supposed to function.
I am assuming that this new structure, and it's migration, are actually well thought out and intended to have a roll-out. If there is a resource out there explaining how we are intended to use the new format to mirror our existing structures, please share it. If there is not a way to allow users to categorize the individual sheets shared with them, and have to rely on a mountain of workspaces based on others naming conventions, please roll it back.
Re: New USM Alternative
I would suggest that there be an activity based option, where if the user exceeds a number of edits only then will they be charged anything for collaboration as a Member. We literally have some users who edit 1 to 3 times in a single month, it is not justifiable to charge them a license. This USM creates additional overhead for the solution, I'm concerned that although the intention was to make Smartsheet more money, in the long run this will hurt them as a organizations scrutinize how their users are actually using it, thereby reducing the number of needed licenses.
Dynamic View Button
It would be nice to have the option of sending a custom email for Dynamic Views, that contains a clickable button to their dynamic view instead of them having to click or copy a link into their browser.
We share dynamic views via automated emails to stakeholders all the time. Currently the dynamic view links exhibit inconsistent behavior when it comes to hyperlinks.
Re: Formula for date range after two different dates
Hi @mreynolds66
So I have my date format set up for UK format DD/MM/YY but the formula that I would use is
=IFERROR(IF([Rehire_Date]@row <> "", DATE((YEAR([Rehire_Date]@row) + 3), MONTH([Rehire_Date]@row), DAY([Rehire_Date]@row)), DATE((YEAR([Hire_Date]@row) + 3), MONTH([Hire_Date]@row), DAY([Hire_Date]@row))), "")
Basically saying if the [Rehire_Date] column is anything other than a blank cell the date will equal DATE( Year, Month, Date) using the [Rehire_Date] column as your date starting point, and then else DATE(Year, Month, Date) again but this time using the [Hire_Date] as your date starting point.
The only reason the IFFERROR( ,"") is in there is just incase you have row entries without any of these dates in it. If you are always going to have those rows then you can change the formula to
=IF([Rehire_Date]@row <> "", DATE((YEAR([Rehire_Date]@row) + 3), MONTH([Rehire_Date]@row), DAY([Rehire_Date]@row)), DATE((YEAR([Hire_Date]@row) + 3), MONTH([Hire_Date]@row), DAY([Hire_Date]@row)))
Please double check if the date format changes the DATE(Year, Month, Date) function format
Ability to update the source item (sheet/report) in Smartsheet Calendar App
To ensure the published link isn't broken.
Data Shuttle Date Formats - current crazy conversion
Need to be able to specify date formats in data shuttle OR for it to adhere to the formats in the uploading CSV file and/or smartsheet.
For example: I have a CSV file to upload via data shuttle with date dd/mm/yyy. The smartsheet has the regional date setting of dd/mm/yyy BUT data shuttle takes a "best guess" and is converting my 01/05/2025 to 05/01/2025 which is total madness.
I have checked with support and YES this is what it does.
Please everyone vote to have the date formats fixed in data shuttle
SueinSpain
Re: Provide users with the ability to Print a Grouped Report
When will this issue be addressed? It's a major stumbling block to not be able to export a pdf of a report or dashboard as you see it on screen. Conditional formatting and grouping is lost in the translation.
Is there a way to change the highlighting color when using the FIND functionality?
Currently when we use "FIND" on a page, it highlights the cell in the found results in white? They can be a little hard to find on a sheet. Is there a way to change the color it uses to highlight the cell? Or can it highlight the word or change the text color on that word?
Thanks!
Re: Thin Blue Line Cell Highlight Hard to Find
Has this concern ever been addressed or corrected?
