Best Of
Bulk toggling of 'Record a Date' automations
I have nice little script to iterate through hundreds of sheets and update contact fields that lack a display_value, so that names consistently show up instead of email addresses. But there are 'record a date' automations tied to those cells that need to be turned off temporarily to avoid triggering them and overwriting the originally recorded dates.
I've only been able to get simple one-step notification automations returned by Sheets.list_automation_rules . . . any suggestions or tricks on how to approach this with the API or otherwise would be appreciated!
Texmati
Issue With Recent Announcements Side Tab
When recently exploring a page I came across the following:
As you can see on the left side of the screen, the tags for a post on the recent announcements seem to eclipse the rest of the box with the data for view count and the timestamp. This may be due to the number of tags associated with that particular announcement post, but I figured I'd give a heads up to the web devs on this one.
Will Duplex
Smartsheet Add-in Login Issue in New Outlook View
Good Day Smartsheet,
My team is now using the new Outlook view, but the Smartsheet Add-in is not logging in & continuously displays a login error (see attached screenshot).
Please add this issue to your bug fix list for the next sprint. For reference, we primarily use Chrome & Edge browsers.
Champ
Re: Attachments Not Being Sent with Automated Email
I also have the same question about smartsheet as i need to send a pdf attachment which is user produced
optimist
Re: Formula inquiry
@Zach_ Glad you got it sorted. You could also use similar logic and add all rows that are less than or equal to the current row number.
=SUMIFS([Hours Saved (Accumulating)]:[Hours Saved (Accumulating)], [Auto Number]:[Auto Number], @cell <= [Auto Number]@row)
Paul Newcome
Re: Preparing for a Password-Free Future in Smartsheet: Share Your Feedback!
This sounds good!
My only ask is that you iron out the service account solution BEFORE removing standard authentication, as it would potentially break solutions that still require it but cannot use access tokens (for example: Microsoft Power BI integrations).
As well, would love the ability to utilize a separate code-generating application, like Duo or Microsoft Authenticator rather than using Email OTPs across the board.
eliweitz
Re: Provide API Access to Upgrade or Downgrade Users under User Subscription Model (USM)
We need the API updated allow for us to manage the new user subscription model. Specifically, we need the new user types returned from your users endpoint (Member, Provisional Member, Viewer, Guest) along with the supported event counts over a period of time that one of our users took an action that qualified them for that user type so we can manage these outside of Smartsheet. This example below is from the user report, however the aggregated days need to shorter, starting at 30 days, in order to properly manage users in the new model.
User domain | User Type | System Admin | Group Admin | Plan Asset Admin | Number of assets shared with user | Highest permission given on assets | Number of assets with Viewer permissions | Number of assets with Editor or Commentor permissions | Number of assets with Admin permissions | Last activity | Number of asset views (Last 30 days) | Number of asset views (Last 60 days) | Number of asset views (Last 90 days) | Number of asset views (Last 180 days) | Number of comments (Last 30 days) | Number of comments (Last 60 days) | Number of comments (Last 90 days) | Number of comments (Last 180 days) | Number of edits (Last 30 days) | Number of edits (Last 60 days) | Number of edits (Last 90 days) | Number of edits (Last 180 days) | Number of created assets (Last 30 days) | Number of created assets (Last 60 days) | Number of created assets (Last 90 days) | Number of created assets (Last 180 days) | |||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Re: Hot key for Expand and Collapse Row
+1, this is a critical feature for both base sheets and reports
Jon A
Re: Hot key for Expand and Collapse Row
Not to be snarky, but do smartsheet employees actually use smartsheet for challenging workloads ever? Not having a hotkey for expanding and collapsing rows, in the year 2025 now, is a crime against end users.
Zrob
Re: Hot key for Expand and Collapse Row
Need this shortcut implemented! I'm in favour of the Ctrl+ and Ctrl- for expand row. Another shortcut for expand/collapse ALL would also be necessary. Level up, Smartsheet!
TheSloppyJoe