Best Of
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
Re: How to calculate days since a date
In a new column, you can use simple mathย to calculate the number of calendar days.ย
=netdays([Date Column Title]@row, Today())
Or you can calculate the number of workdays using:ย
=networkdays([Date Column Title]@row, Today())
ย
You can also add a list of holiday dates to this formula to adjust if you so desire.
For more Information:ย
Mike Wilday
Re: Track time in Resource Management by task, not by project overall
This is a serious limitation.
I have clients that want to track time by major deliverable. It's impossible.
Matt Suderman
Re: IF formula to check the box column
Hi @RaffyM
The cell will only be counted if it contains the exact phrase "Accepted", meaning it won't include cells that have extra text (e.g. "This says accepted").
However if you need to have other columns in between and they could have a cell that only says "Accepted", you can count each individual reference separately:
IF(John@row = "Accepted", 1, 0)
+ IF(Alexa@row = "Accepted", 1, 0)
+ IF(Charles@row = "Accepted", 1, 0)
+ IF(Kim@row = "Accepted", 1, 0)
+ IF(Ian@row = "Accepted", 1, 0)
+ IF(Eli@row = "Accepted", 1, 0)
=IF(COUNTM([Affected Owner]@row) = (IF(John@row = "Accepted", 1, 0) + IF(Alexa@row = "Accepted", 1, 0) + IF(Charles@row = "Accepted", 1, 0) + IF(Kim@row = "Accepted", 1, 0) + IF(Ian@row = "Accepted", 1, 0) + IF(Eli@row = "Accepted", 1, 0)), 1, 0)
Cheers,
Genevieve
Genevieve P.
Re: Basic functionality improvements
Thanks for voting, @Stevey C!
Product Ideas submitted using the Community ideation & vote system are reviewed on a monthly basis by the Product team. They look at the top-voted posts for each month and provide a Status update to indicate if it's on our current roadmap or not.
The Community is only one of the many listening channels that Product uses to determine roadmap items: we receive feedback in the application (the bullhorn icon), the EAP program, the feedback form, direct feedback, and more. This means that the votes in Community are not always representative of the bigger picture - a Community request with what seems to be a high number of votes does not guarantee that feature will be on the roadmap, but it does guarantee that the Product team will have extra visibility into the need for that item.
If an Idea is important to you, keep sharing it with others to get their votes and direct feedback as well.
Thanks!
Genevieve
Genevieve P.