Best Of
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.
Re: November Question of the Month 💭 Join the conversation and receive a badge
Just one? Oh... decisions, decisions.... 😀
Datashuttle - HUGE time savings getting data into my sheets.
DataMesh - one of those "Why do I need it?" that turned into "How did I live without it??" features
Formula Help - makes formulas easy with the syntax and prompts right on the screen
And yes, I can't ignore Dashboards.... because those started my Smartsheet obsession 😃
MCorbin
Re: Multiple Line Entries with one Form Submission
I hope you're well and safe!
I developed a solution using two forms (or the same form by using conditional logic) that can be used to submit the main information and then the other information on a new row for each submission after the first.
Would that help/work?
I hope that helps!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Andrée Starå
Re: Automation copy row into the same file
I will answer myself in order that anyone who see this knows what happened. In the main sheet I have a column with column property "# Auto number", then I am assuming that the automation cannot take that information and translate to other sheet than the column property is other. Since the moment that I change the property column to text, the automated flow starts to work again.
Raul Cabrera