Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.
Benefits over Microsoft Project?
Comments
-
J. Craig Williams ✭✭✭✭✭✭
Annette,
Define "total".
There are features I miss about MS Project.
However, no one is paying me at the moment to manage a project in MS Project (or Wrike or Primavera or ...) so I don't miss it THAT much.
MS Project is hard to master. Many of my peers at where I used to be salaried had not - it was a glorified Gantt chart creator - no resources, no real dependencies, no WBS. For them.
If you looking for an apples-to-apples comparison, then realize that Smartsheet is more than a PM tool. If you ONLY looking for a PM tool, then MS Project is fantastic.
But ... it also depends on what you project problems are.
You should look at sites like this:
http://project-management.softwareinsider.com/compare/3-82/Microsoft-Project-vs-Smartsheet
or this:
https://comparisons.financesonline.com/smartsheet-vs-microsoft-project
to see a better comparison of features sets than I can provide in a short amount of time.
For me, Smartsheet is all about the collaboration and communication. In a project, that is critical to success.
If I had to run a project that was time based (finish at 10am, start next at 10:01am) I would use something else. If I had detailed dependencies and constraints, and not just a few simple finish-to-start tasks, I would use something else. If I was worried about losing access to the Internet, I would use something else.
But ... for most of my small projects, Smartsheet does the job, with less cost and less aggravation than MS Project.
Another thing to think about is cross project dependencies (MS Project does this in the enterprise version, Smartsheet can do this, in some cases, but may pose a who-can-see-what problem)
Both MS Project and Smartsheet are tools. Not every tool is the right one for every task. I used to have 4 file comparison progams on my desktop - two of which I used daily or more often. The other two just did one or two things that the others didn't or did them so much better that I was loathe to lose that functionality.
It really depends, for me, on the project, the project team as to which project management tool I would want to use.
I hope that helps. I got interrupted and lost my train of thought while typing this.
Craig
-
Tim Meeks ✭✭✭✭✭✭
i concur. If you are needing a very robust PM tool go with Project. If you need a lite version of Project with an easier learning curve and the ability to do Reports, and Webforms and collaboration, go with Smartsheet.
-
Thanks for your comments. I find Project extremely easy and intuitive but I'm an ex-trainer so possibly have an advantage. J Craig Williams you said for 'small' projects that SmartSheet does the job. I'm taking by that comment that you wouldn't use it, to say, put in a new EPR to a hospital trust?
-
J. Craig Williams ✭✭✭✭✭✭
Annette,
I don't know what "a new EPR to a hospital trust" means.
The ony EPR I have knowledge of is the enhanced pressured water reactor. Probably not what you are talking about.
However, by "small" I mean a project or projects that are unlikely to reach any of the limitations of Smartsheet - rows (5000) or cells (200k)
Also, I mean that most of MY projects recently have been small - timelines in weeks or months at the most and task counts in the hundreds at the extreme, but usually in the dozens.
Hope this clarifies a bit.
Craig -
J. Craig Williams ✭✭✭✭✭✭
annette,
Other threads reminded me that Smartsheet does not do multiple resources per task in the way some people would like and certainly not like MS Project does.
Craig
-
The multiple resources issue is VERY interesting - thanks for that.
Ha ha no, an enhanced pressured water reactor isn't what I was referring to. An EPR is an electronic patient record or, to expand, a patient administration system affecting thousands of users throughout each discipline e.g. cardiology, outpatients, theatres, burns and plastics, A&E etc etc etc
-
J. Craig Williams ✭✭✭✭✭✭
If you are only concerned with the rollout project, then Smartsheet has been used for complex projects and it is certainly worth considering.
As I tried to explain, I don't believe there is a one size fits all solution.
(I also think 75 solutions are too many, but that's a different issue)
If the EPR will reside in Smartsheet, then my main concern would likely be scalability.
Craig
-
Thanks for your input - very valuable information in there!
-
Tim Meeks ✭✭✭✭✭✭
Use MS Project if you are going to track a task and want to put the total duration on one task line and then add multiple resources at difference percentage allocations,
如果你可以将这个任务分成multiple tasks and putting the hours for that subtask on each line with only one resource on each task to measure resource allocaton, then you can use Smartsheet.
Smartsheet is easier to colloborate, update, and run automated reports,
It can even track big projects and will allow multiple users to update without having to have a MS Project licenses for other editors or print PDFs of an MS Project and email like you have to do if using Project.
Depends on your proirities.
Hope that helps.
Tim
-
That helps a lot Tim, Thank you. I think what I'll do is put my current project on there and run concurrently to see what their respective strengths/ weaknesses are.
-
J. Craig Williams ✭✭✭✭✭✭
As always, I agree with Tim.
Craig -
@Tim, yes I'll let you know.
-
J. Craig Williams ✭✭✭✭✭✭
annette,
Me too!
Categories
Instead of applying the formula to \"Multiselect Text String\" row, did you tried with \"Multiselect Values\" row?<\/p>
=IF(HAS([Multiselect Values]@row, [Component ID]@row), \"MATCH\", \"NO MATCH\")<\/p>
Thank you,<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":109493,"type":"question","name":"I am having trouble using \"And\", \"OR\" & \"Countif(s)\" to build a formula.","excerpt":"Hello, I am attempting to come up with a sheet summary formula that counts cells if they meet at least one of 3 different statuses in the same column, AND also meet one of 5 different statuses in a separate column. So using the screenshot I've provided as an example (although it doesn't have 5 different statuses in the…","snippet":"Hello, I am attempting to come up with a sheet summary formula that counts cells if they meet at least one of 3 different statuses in the same column, AND also meet one of 5…","categoryID":322,"dateInserted":"2023-08-25T20:03:21+00:00","dateUpdated":null,"dateLastComment":"2023-08-26T00:34:49+00:00","insertUserID":165710,"insertUser":{"userID":165710,"name":"SmarsheetNewb","url":"https:\/\/community.smartsheet.com\/profile\/SmarsheetNewb","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-26T00:33:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-26T01:04:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":23,"score":null,"hot":3386005690,"url":"https:\/\/community.smartsheet.com\/discussion\/109493\/i-am-having-trouble-using-and-or-countif-s-to-build-a-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109493\/i-am-having-trouble-using-and-or-countif-s-to-build-a-formula","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":109493,"commentID":392692,"name":"Re: I am having trouble using \"And\", \"OR\" & \"Countif(s)\" to build a formula.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392692#Comment_392692","dateInserted":"2023-08-26T00:34:49+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-26T01:04:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-26T00:33:25+00:00","dateAnswered":"2023-08-25T20:44:12+00:00","acceptedAnswers":[{"commentID":392662,"body":"
Try this:<\/p>
=COUNTIFS([Item Number]:[Item Number], OR(@cell = \"C001\", @cell = \"COO2\", @cell = \"COO3\", @cell = \"COO4\"), [Status]:[Status], OR(@cell = \"Green\", @cell = \"Yellow\", @cell = \"Red\"))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}]},{"discussionID":109474,"type":"question","name":"Help with date calculation formula","excerpt":"Hello, I'm trying to find a formula that will help me calculate how long an intake took to resolve. The rows I need to be calculated are Date Reported & Resolution Date. If the resolution date is blank I want it to use the current date in the calculation to see how long this issue has gone unresolved. Any help is much…","snippet":"Hello, I'm trying to find a formula that will help me calculate how long an intake took to resolve. The rows I need to be calculated are Date Reported & Resolution Date. If the…","categoryID":322,"dateInserted":"2023-08-25T16:29:39+00:00","dateUpdated":"2023-08-25T16:29:59+00:00","dateLastComment":"2023-08-25T23:01:30+00:00","insertUserID":165688,"insertUser":{"userID":165688,"name":"Nwest","title":"Systems Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Nwest","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ukHVZ18ImX4!BcjWAe8S9SY!l7iQo_PZHOx","dateLastActive":"2023-08-25T17:22:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":165688,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":23,"score":null,"hot":3385987269,"url":"https:\/\/community.smartsheet.com\/discussion\/109474\/help-with-date-calculation-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109474\/help-with-date-calculation-formula","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":109474,"commentID":392687,"name":"Re: Help with date calculation formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392687#Comment_392687","dateInserted":"2023-08-25T23:01:30+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-25T17:04:22+00:00","dateAnswered":"2023-08-25T16:36:59+00:00","acceptedAnswers":[{"commentID":392622,"body":"