Best Of
Re: Grouping in reports is gone when sending it via email as excel spreadsheet?
Hi @Primoz,
I created a browser extension and implemented a new PDF generator to solve this problem. You can click here to download the browser extension.
Then click the "SSFeatures" button at the top, and then click "Generate PDF".
Here is an example of what the generated PDF looks like, notice how it has all of the grouped and summary rows:
I hope this PDF generator solves the issue for you! Please let me know if you have any feedback!
SSFeatures
Re: Auto Sort Smartsheet
Hi @Petra and @johngraham78,
I created a browser extension that adds automatic sorting into SmartSheet. You can can click here to download the browser extension.
Then click "Sort Rows":
Then click "Sort Automatically":
Then the browser extension will automatically sort whenever the data changes. The browser extension also saves your sort settings, so that you don't need to manually re-enter them.
Also, this automatic sorting works with filters. So if you enable automatic sorting, and then add a filter, the extension will automatically sort the data even with a filter enabled.
Please let me know if you have any questions!
SSFeatures
Conditional formatting based in incoming and outgoing cell links
When linking activities/tasks across project sheets, they are identified with a little triangle that is very easy to miss. In our context, these are some of the most important tasks because they create cross project dependencies. I'd love to be able to apply conditional formatting based on incoming and outgoing cell links so they are highly visible.
I'd also like to be able to generate a report that shows just these linked activities across sheet.s
Kate OK
Free Smartsheet Webinar Series by DigitalRadius
I wanted to share an exciting resource that I think a lot of you will find valuable!
Our Customer Success team here at DigitalRadius is hosting a Free Smartsheet Webinar Series now through the end of the year, designed to help you unlock the full potential of the Smartsheet platform. It starts tomorrow!
Here’s what’s included in the series:
Smartsheet 101: How to get started, column types, forms, automations, parent-child hierarchy, conditional formatting
Smartsheet 201: How to build reports and dashboards
Smartsheet 301: How to build automations and using formulas
Register with the link below (Really cool Smartsheet Dashboard)
ChristianFinke
Re: Provide users with the ability to Print a Grouped Report
@Genevieve P. - Please give us an update on this subject or provide us with a contact (manager) who CAN assist us with this rediculous unanswered basic issues.
Providing generic responses with 🚫 NO follow-up, is becoming a reoccuring theme of SS, making it easier for some of us to just 🏃♀️LEAVE the Software for something more functional/useful/$$. Its VERY sad that people have to develop add-ons for your product to address basic core features that other platforms are currently providing for FREE. 😤
Julie Becker
Re: Is there a way to send out automate sending out dashboards weekly?
@itSmE Yes this is live now.
Just set the schedule, enter who you want the dashboard to go to, and copy the URL for your dashboard into the body of the message.
Isis Taylor
Remove User Sharing
Smartsheet recently changed what happens when you click "Remove Sharing" from a user you are deactivating or has been deactivated.
Previously, a banner would appear indicating if that person was NOT shared to anything. If they were shared, the banner would say check back later. When you checked back, it would show the user no longer shared to anything.
Currently, the only feedback you get is to check back later. Even 24 hours later, it says check back later. Now you have to download a sheet access report to confirm the user is not shared to anything. If they aren't shared, you get an empty excel file. Incredible waste of time.
Bring back the banner showing not shared or automatically remove sharing upon removing the user from the account.
(Not a problem if you remove 1 user occasionally, we might add and then remove 40+ interns at a time.)
ker9
Display hyperlinks as hyperlinks in update request or alert
I have hyperlinks to other sheets within a tracking sheet for easy access by team members.
The hyperlinks are displayed by "Display Test", not the actual URL:
When I insert the column in an update request or alert, it only displays the Display Text. It is not a hyperlink. The URL is not accessible from the email or update form.
How can I get the hyperlink from the Sheet to behave like a hyperlink when embedded in an email or included in an update form?
Many thanks,
Justin
Justin Silva
Re: Counting Blank Cells
If your cells are blank, then this should work:
=COUNTIF({Status Blank}, "")
However, this will also capture any blank rows (such as those at the bottom of your sheet, so I would use an alternative with another reference to your sheet where there will always be data if the row is to be used:
=COUNTIFS({Status Blank},"",{Other column}, <>"")
This will count the blank status where there is data in the other column but ignore any blank rows.
Hope this helps, but if you've any questions or problems then just post! 😊
Nick Korna
Re: NEW! Wider dashboard canvases and dashboard zoom
PLEASE make it so we can revert it back!!
Team members keep hitting this button and we are stuck with this horrid "feature"/bug.
Mark4555666
