Best Of
Re: How to transform a Multi-select dropdown into multiple rows
You have encountered a limitation of Smartsheet, and I wish there was a way to make this happen.
You could create a sheet that has a row for each possible selection for each person, and then filter that sheet to only show records where the person selected that choice, but in my experience, these sheets quickly run into Smartsheet formula limitations.
But KPH also has a workable Idea, which is a column for each possible answer choice. Then you use a cross-sheet reference to populate the columns.
User Management button should go directly to User Management, not Admin Center
When I click on the User Management button for the first time after opening my browser, it takes me to the Admin Center, not to User Management. There is not a link to User Mgmt on the Admin Center screen, so I have to close Admin Center. If I then click User Management again in the same browser session, it does take me to User Management. I initially reported this as a bug, but learned it's operating as designed, per the Support response below:
"And also upon testing on our end, we were also able to experience the exact behavior when we first login to the browser and access the User Management page. And as we reached out with our team, we were able to identify that this is by design. Because that is the first time that you login to the User Management/Admin Center using the browser, or closed browser. It is necessary to login first in the Admin Center, before accessing the other functionalities under it."
My request is simply that clicking the User Management button takes you directly to the User Management screen instead of Admin Center (saves a couple of clicks and some frustration). Alternatively, put a link to User Management on the Admin Center screen.
Easy way to locate Premium App assets created by Deactivated User
I just had this case where the Calendar App Owner left the company a few months ago, and I had to transfer ownership.
Before I could transfer the app's ownership, I had to locate the source sheet and share it with our System Admin account.
As both a Plan Asset Admin and a System Admin, we must have a notification or an easier way to track premium apps created by deactivated users. This would enable us to promptly transfer ownership to the appropriate user, a capability we currently lack.
Re: Hidden Columns List
@Nik Fuentes (and everyone else), that idea was added to the "Sheet Statistics" idea post last year. Maybe it should be a post of its own, but I'm concerned that that spreads the concept rather than concentrates it. Your further thoughts welcomed.
In the meantime, y'all, go upvote that idea!
Re: API Rename attachment
@Tim Wells I would love to to see this!
+1
https://github.com/smartsheet-platform/smartsheet-python-sdk/blob/master/smartsheet/attachments.py
Re: NEW! Dashboard color themes
Hi @Ray Lindstrom ,
Barak here from the Dashboards product team. To confirm, we have existing plans to expand our theme functionality to custom themes.
Happy to share more details if you're interested - I'll send you a message.
Re: NEW! Dashboard color themes
@Jason DelValle, this is awesome. And, I agree with @Ray Lindstrom, custom scheme would be amazing!
parent timelines when dependencies are enabled gantt Bar formatting
It would be very helpful to be able to format the gray bar in gaunt charts for parent rows when dependencies are enabled. Even having a few formatting options available to help these to stand out from other rows.
Re: COUNTIF functions returning 0
Someone else on a different post I recall got a COUNTIFS function to work better by adding "@cell=" in the criterion portion even though the official Smartsheet function page doesn't mention that. Give it a try, let me know if that does work?
=COUNTIFS({Dump: OPEN AND CLOSED REQS Range 1}, @cell=1, {Dump: OPEN AND CLOSED REQS Range 2}, @cell="Open")