Best Of
Calculating Duration based on Effort and Resource Allocation %
Why has product development ignored the need of real project managers to be able to calculate durations based on task effort and resource allocation percentages?
This is one of the most basic needs of a project management tool and SS's response that 70% of PMs say this functionality is not needed is fatuous at best. These "less formal" project managers are not project managers.
Currently I need to build my schedules in the program my organization retired in order to begin using SS and then move that info into SS once my schedule is baked so that I am not spending countless hours doing those calculations myself, especially for my lengthy projects that can last multiple years.
Unfortunately, I am not in a position to decide to cancel my organization's subscription, but implementing SS has made my job exponentially more difficult.
PMs have been begging for this for at least the last 5 years and so far SS has completely ignored this request. Frankly, it's insulting.
Brock Savage
Re: Licenses and True-up confusion
Thank you, not really helpful at this stage as there is an additional charge for Premium Apps (not mentioned). I will seek another solution outside of Smartsheet. This must be chaos for numerous users and I hope customer feedback is being listened to. I don't believe there is much more you can help with other than reversing this ridiculous decision.
Re: Create Formula in Sheet Summary field to pull only Month from another Sheet Summary Date Field
Hi @MariaG
Thats fine, if we add another IF using ISBLANK at the front of the formula we can achieve that.
=IF(ISBLANK([Projected completion date]#), "Undecided", IF(MONTH([Projected completion date]#) = 1, "Jan", IF(MONTH([Projected completion date]#) = 2, "Feb", IF(MONTH([Projected completion date]#) = 3, "Mar", IF(MONTH([Projected completion date]#) = 4, "Apr", IF(MONTH([Projected completion date]#) = 5, "May", IF(MONTH([Projected completion date]#) = 6, "Jun", IF(MONTH([Projected completion date]#) = 7, "Jul", IF(MONTH([Projected completion date]#) = 8, "Aug", IF(MONTH([Projected completion date]#) = 9, "Sep", IF(MONTH([Projected completion date]#) = 10, "Oct", IF(MONTH([Projected completion date]#) = 11, "Nov", IF(MONTH([Projected completion date]#) = 12, "Dec", "Error")))))))))))))
Hope that helps
Paul McGuinness
Central Operations Manager at Care UK
If you found this comment useful, please let me know by clicking one of the buttons below: Awesome, Insightful, Upvote, or Accepted Answer. Your feedback will assist others looking for the same information and also help me out.
Paul McGuinness
Importing Excel Sheet to Update Existing Smartsheet
Hello,
I am trying to be able to create an Excel spreadsheet with corresponding header fields. For example, headers in Excel would be "Order #" and in Smartsheet it would also be "Order #" so that whatever is under those header fields would auto-populate into Smartsheet.
Whenever I try to import an Excel sheet it creates a whole new sheet, but I am wanting to add new information to my "Open Orders" Smartsheet multiple times a day.
Thanks for the help.
clairehunter
Re: Formula needed to fill a cell if a word is contained as part of another cell
Hey @SSParks
HAS is an exact match. Sorry, I wasn't paying attention that the screenshot was truncated. CONTAINS would catch a portion of the word
Kelly
Kelly Moore
Re: Dashboard Charts - Secondary Axis, additional data points, target line
We would also love to see these features added to the charts. The ability to add a goal line or to mix different types of charts. It would also be great to be able to select which datapoints you combine into a stacked bar chart while still being able to have one that is not. Anything to increase the functionality of the charts would be fantastic.
RebTrachs
Re: Adding Column Descriptions to Reports
Absolutely agree. This seems like very basic functionality to add which would have very meaningful impact.
nbuikema12
Re: Adding Column Descriptions to Reports
This wouldn't work when you have more than one sheet as the source of the report. But for single-sheet reports, it makes total sense.
how do I change my email address because I have no access to the current/dead email.
how do I change my email address because I have no access to the current/dead email.
212004739
Re: NEW! Modern forms submission experience with accessibility enhancements
I've experienced the dropdown field selection issue myself this morning. Trying to select a staff member from a single select drop down > started typing staff member name and hit return instead of grabbing my mouse to select > field in form stayed blank, would not reset to display dropdown list again > had to close out and reopen the form to reset and display the dropdown list again.
Sarah Donnelly