Best Of
Re: Multiple Approvals Based on Selection in Multi-Select Field
Hey @UrbanLawrence
Are you using the same Approval column for all your different requests?
You'll want to set up individual columns to record the different types of approval. That way it won't be registered as "Approved" for that row, since the associated column is set to "Submitted". Otherwise, the "Approve" in a single column will assume it's an Approve for all workflows - does that make sense?
Cheers,
Genevieve
Genevieve P.
Re: NEW! Dashboard center alignment and mailto links!
The mailto is pretty nice, any chance we can get this same functionality on forms too?
Samuel Mueller
Re: Folder-level permissions
This is a greatly needed enhancement. We manage very large Programs through Control Center with multiple workstreams and projects under that Program Workspace. The folder tree and artifacts are extensive with many being confidential. Like other commenters, because of the time-consuming process of giving access at each artifact level, we end up giving most people access to the entire Program workspace and confidential data they really should not have access to.
Brenda Merrill
Re: Sorting
Hi @Liz_Snavely I believe this is because it is treating those beginning with 0 as text rather than numbers.
If you add a leading 0 to them all they do sort correctly.
Hope this helps!
John
John_Foster
Re: Divide By Zero Error with Average
@Kariv You need to get the error removed from the cells you are referencing.
Paul Newcome
Re: Control Center - Cannot provision some projects using our blueprint
Hi @summetg
The first thing I would do is verify that parent project value in the intake sheet matches the project in Manage Program > All Projects.
Then the second thing to check is that the Parent Project Selection column in the blueprint is pointing to the correct column on the intake sheet.
If both of these things are correct, I would recommend reaching out to Smartsheet Support with additional screen captures of your blueprint configuration and intake sheet so they can troubleshoot with you in a private channel.
Cheers,
Genevieve
Genevieve P.
Re: How to change account Credentials
Hi @Riana,
You can edit details like your Username, Email, and Password by clicking on your User Icon in the top right corner of the browser window and going to Account & Privacy Settings. Please note that there can be restrictions to this if you are on an enterprise account where you have been granted a license. In that case you may have a different process, internal to your organization, in order to make these changes.
Hope this helps!
Zachary Hall
Re: Harvey Balls - two step rules
I'm not sure what you mean by %age of time. But so long as you can display what you want with 5 symbols, and create an IF function to identify which symbol is the most appropriate that would be certainly be possible.
You can apply harveys to the difference between start and due date easily (more easily than what you were doing which included knowing today's date). For something like this (I've used two different icon sets as I prefer the bar for progress):
The formula in both Column6 and 7 is:
=IF([End Date]@row - [Start Date]@row < 7, "Empty", IF([End Date]@row - [Start Date]@row < 30, "Quarter", IF([End Date]@row - [Start Date]@row < 60, "Half", IF([End Date]@row - [Start Date]@row < 360, "Three Quarter", "Full"))))
This means if the difference between start and due is less than a week put an empty ball. If that is not true but the difference is less than 30 days, put a quarter, etc, etc, to if more than 360 put a full ball.
Slightly off topic - I don't like these icons to be used like this as the icons suggest each part is the same size which here they are not (60 days fills the first half, 300 days fills the second). But that isn't specific to smartsheet. I would only use these if you can split your projects into 5 similar sized bands.
KPH
Re: Replying to Comment via email
Hello, nope. This issue has been raised to Tier 3 Escalations Engineers at SmartSheet and they are telling me that although this is standard functionality/feature in Smartsheet, it is currently NOT supported in the EU instance of Smartsheet. I've wasted a ton of time on support calls trying to get a clear answer on this. It took until Tier 3 to confirm that is is "an unsupported feature in the EU environment at this time in Smartsheet". !! I've still not gotten any explanation as to why this is -- if it is an oversight, or a regulatory issue, or...?
Of course this makes no business sense for us, and it makes the workflow much less defensible for ROI and use with Senior executives, who simply do not have the time/patience to go into a Sheet to reply.
Smartsheet is telling me that I have to submit this 'feature request' to the Product Team and then IF (and only IF), it happens to get a lot of up-votes, they will look at it and consider adding this functionality to EU.
Very frustrating. I will put it into Product Ideas, but I can almost guarantee that most folks will assume this is user error and not upvote it. Sigh.
Cynthia FUrlong
Re: November Question of the Month 💭 Join the conversation and receive a badge
So thankful for Dashboards! The ability to visualize the data we use every day has really built support from our executive team. They are able to quickly understand the pictures we paint with this data and have fully backed rolling out Smartsheet use cases across the organization after seeing more of its potential.
KMueller