Best Of
Ask Me Anything! Jennie Ives, ENGAGE 2021 Event Team
Checking in with a short video message for you all! Drop your ENGAGE 2021 questions below once you watch and I'll be right there to answer. PS. Bean says hello!
Introducing our next class of Overachievers! 🎉
Please join us in welcoming our new class of Smartsheet Overachievers!
These customer champions come to us from all over the world and represent a wide array of industries, roles, and perspectives. They've been chosen to positively impact not only our product but our global community at large. Help us welcome them in the comments below and read their stories here!
Keep a lookout in our Community for tips, tricks, and best practices from this wonderful group!
Dark Theme - or other options - via User Options or Workspace Options
Would it be possible to use some of the CSS to control the color of the (currently hard-coded as the elements are rendered) cells and other backgrounds using the settings for "Personal Colors and Logos.." and the workspace colors and logos dialogs?
I have a browser extension for css overrides which I use to reduce opacity and blend-modes of all the white backgrounds, but it really would be nice to have a fully "dark" theme available to use while tap tap tapping away late at night.
I'm guessing there are some companies which would like to embed smartsheet charts, data, forms, etc.. into their online presence, but the hard-coded entities' colors are preventing them from doing so.
Printing Grouped Reports
I have a report that i have used the new grouping function on and i'm wanting to print it with the group headings but each time i print as pdf or export it only shows the standard cells, without the group headings, is this correct or is there something i'm missing?
Re: Why are unlicensed users asked to upgrade to Premium?
We just started rolling out smartsheet to our office. About 150 employees. We also went the enterprise route, and thought we had 'right sized' our licensing, based on the premise that the vast majority of users will be viewers only to the various sheets and reports. When I saw the 'upgrade' banner across the top of an 'unlicensed user' account connected with our domain, all I could think of is how our staff will feel. Bummed. We made an investment into the smartsheet platform, worked with smartsheet to develop custom API's, integrated Control Center... like I said, an investment. But from our staff's perspective, it will look like we cheaped out with some "free platform". I am posting this here in the hopes that this is being reviewed for enterprise clients with an option to turn this off.
Quick way to copy formulas across sheets I found
Problem: I had the need to copy a list of 26 formulas to 56 sheets maintaining the formulas for each sheet. to increase the data collection across the sheets. All sheets have the same column names. Smartsheet defaults to saving the end result, and doesn't offer the ability to just copy the formulas from one column in one sheet to another.
Solution: I found that if you type ' before the formula, and copy and paste the desired range between sheets, smartsheet doesn't recognize the ' and will post the formula from the cells. This way you can copy an entire rows formulas, and post the formulas into another sheet in rapid succession
Why are unlicensed users asked to upgrade to Premium?
Hi there,
Not sure whether this is request for change or an error in our licensing/configuration, but the unlicensed users in our configuration see a message that reads "You have limited access to Smartsheet. Upgrade to use premium features" whereas the licensed users do not see that message.
We have (we think) a properly licensed implementation of Smartsheet and that allows for a mixture of legitimately licensed and unlicensed users. The latter wonder why they are being asked to upgrade all of the time.
Advice?
Re: Why are unlicensed users asked to upgrade to Premium?
@Rob Hagan I agree this constant nagging to upgrade (i.e., pay money) is annoying and confusing to many non-licensed users. Collaboration is the key to Smartsheet so to constantly tell people who have a Smartsheet login that they need more is not helpful. I spend a fair amount of time fielding questions and requests for licenses that will never be granted in our organization. Given what we pay for a Business or Enterprise account, we should have the option to turn those messages off.
Re: Automating document creation
Hi folks! I'm the Product Manager on document builder. I'm glad to hear that you're finding it valuable. Adding an automated workflow action to generate documents is a highly requested enhancement and will make document builder even better. I don't have an ETA at this time, but using the enhancement request form linked above is a great way to submit feedback directly to our team!
Thank you for your feedback! Let us know if you have more enhancement requests or run into any issues.
New! Scatter charts
Hi Community,
Hot off the press, I am excited to announce a new, highly requested, chart type is now available in dashboards: Scatter charts! A fan favorite originally introduced in Smartsheet labs, we are happy to finally make this available in the main Smartsheet app.
In addition, this update will introduce a new option for the x-axis called “numeric axis”, an option to change the x-axis to display number-based data points accurately on the axis instead of evenly distributing the data points.
You will be able to create a scatter chart from the data in your sheets and reports. To get started, create a chart widget or edit an existing widget, select “Add Data”, and choose the sheet or report you’d like to use as the source for your chart.
Note: At this time “numeric axis” is only available on scatter charts.
If you'd like to learn more, check out our help content on charting in dashboards.
As always, let us know what you think through the Product Feedback form (available from the menu here in Community), and thank you to everyone who submits feedback and requests for dashboards — we appreciate everything you send us!
-Brendan