Best Of
Re: Today is not shown in report timeline of a dashboard
I would hardly consider this functionality an "Enhancement" It seems more like an issue with the report widget. The setting to "Open to today's date" is available in both the Sheet and Report settings and it displays the dotted line, that Frank eludes to in his original question, in both. The report widget does not honor this setting when it renders the report.
I have entered this into the request system and discussed it with our technical representative.
Re: View "Today" line in Gantt on Dashboard
I think it is absolutely mental that this isn't a standard feature. I've used Smartsheet on and off over the years and still cannot fathom how this hasn't been sorted yet. Everyone expects to see a date line on a gantt chart in the dashboards. Please please could this be added :(
Re: View "Today" line in Gantt on Dashboard
Absolutely needed - right now I screen capture the views with the dotted "today" line and paste that into docs for my customers because they have asked for the line! I need it in a Gantt Report - and then i can show it the Dashboards too.
Re: Formula Assistance - Pulling values after delimiter in text string
Hi @ConnorForm ,
You use a combination of RIGHT(), LEN(), FIND(), and SUBSTITUTE(). Here is an example of a formula that works.
Formula in "Last characters" field
=RIGHT([Primary Column]@row, LEN([Primary Column]@row) - FIND("~", SUBSTITUTE([Primary Column]@row, "_", "~", 3)))
Results
Explanation
- SUBSTITUTE creates a unique character in place of the third "_". Adjust the number "3" in the substitute to be "14" for your application.
- FIND identifies the position of that unique character in the string.
- LEN provides the length of the entire string.
- LEN - FIND provides the number of characters for the RIGHT function.
- RIGHT provides the characters at the end of the string.
Regards,
Neil Egsgard
Re: Group Columns in Grid
It would be great to be able to group columns... for various reasons.
One major one for me would be for hiding & unhiding info.
Similar to the way you can click the filter button once to filter versus unfiltered, it would be nice to be able to "Hide Column Group" or "Unhide Column Group"... this is something that would come in handy for quick data entry on sheets that are used by multiple people but controlled & kept clean by one or two individuals.
Re: Hidden Columns List
Having a hide/unhide checklist is the intuitive/obvious way to handle this, as noted by the other commenters. Please implement this function. Unhide all is complete overkill, and very inefficient way to show the columns. I may have 50 hidden columns tracking different metrics, etc.. and to unhide one of them the only option is to unhide all 50 and then re-hide the 49 that I want to remain hidden??? This is a great example of why there are comments online about Smartsheet making simple functions much harder than they should be.
Re: Be aware of upcoming changes to your Smartsheet login options
Our organization works extensively with external collaborates. One of the biggest risks we face is when we grant access to an employee of another organization and we are not informed when they leave. Without email-based one-time passcode authentication (tied to their corporate email domain), an external employee at another org could use their corp email address and password to access information in a Sheet / Workspace. Connecting the one-time passcode (OTPC) to email allows us to rely on that entity removing access to their email address as a control. As terrible as OTPC is, it is the simplest method we can conceive of to minimize this risk and add some additional authentication method.
The functionality recently released for external collaborator SSO / MFA authentication is not practical to rollout without extensive documentation and dialogue with the IT Departments at external organizations. We've tired - it doesn't work. It's a never ending loop of failing authentication that continuously takes users back to the main auth page of SmartSheet - https://www.smartsheet.com/content-center/secure-external-collaboration-new-require-corporate-account-and-require-multi-factor
For what it's worth, we greatly appreciate this soon to come OTPC option. Amongst all the haters, than you for implementing this.
Re: March Question of the Month - Join the conversation and receive a badge
I love the new song by Bleachers called "Modern Girl". It so cool to see a band in todays age still making 80's inspired pop rock hits! This song makes me want to DANCE DANCE DANCE!!!!!
Create automation to move attached image to a cell
SmartSheet should include the function to add an attached image (.jpg) to a cell as an automation, or, allow images to be added directly to a cell via a form.
This would be a very useful tool that would replace other services we pay for now with other vendors etc…