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?

Are there any experienced Microsoft Project users who are now total converts to Smartsheet and can you tell me what benefits you've found please. Many thanks.

«1

Comments

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 01/13/17

    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
    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.

  • Christine Mick
    edited 01/17/17

    So if I'm understanding this, SS does not have a way to track time. If we wanted to track how much time it took our technician to work on a task, we can't have him enter start time and end time, and SS calculate this?

  • 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
    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.Laughing

    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
    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
    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
    Tim Meeks ✭✭✭✭✭✭

    @Annette,

    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
    J. Craig Williams ✭✭✭✭✭✭

    As always, I agree with Tim.


    Craig

  • Tim Meeks
    Tim Meeks ✭✭✭✭✭✭

    @Craig... LOL....thanks for the compliment....

    @Annette, would love to hear your assessment once you complete. I've not done a a parallel entry in both softwares.

  • @Tim, yes I'll let you know.

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    annette,

    Me too!

This discussion has been closed.
Hi, <\/p>

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":"

\n \n https:\/\/community.smartsheet.com\/discussion\/109474\/help-with-date-calculation-formula\n <\/a>\n<\/div>\n

Hi, <\/p>

I hope you're well and safe!<\/p>

Try something like this.<\/p>

=IF([Date Reported]@row <> \"//www.santa-greenland.com/community/discussion/6952/\", IF([Resolution Date]@row = \"//www.santa-greenland.com/community/discussion/6952/\", NETDAYS([Date Reported]@row, TODAY()), NETDAYS([Date Reported]@row, [Resolution Date]@row)))<\/p>

Did that work\/help? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic weekend!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/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"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts