How do I engage a smartsheet expert to help build my PMO requirements in New Zealand?

Ben Smith
Ben Smith
edited 06/16/22 inSmartsheet Basics

With the current shutdown my business has experienced unprecedented demand and getting time to get my smartsheet application up and fully functional is not happening. Given the current economic climate is there experts out there prepared to work for reward?

Being based in New Zealand remember cost will be an issue.

Tags:

Answers

  • [Deleted User]
    [Deleted User] ✭✭✭
    edited 04/03/20

    @Ben SmithWe have an existing post and thread geared at connecting Smartsheet customer experts with other Smartsheet customers to assist during this difficult time. Please take a look and considering posting this request there. :)


    Hi Smartsheet Community! I am Tasha Bishop, and I lead the Customer Success organization at Smartsheet. Though we are all facing unprecedented challenges in this new reality in light of the COVID-19 pandemic, I have been touched by how these difficult times have also brought out the best in people. Several members of my team have been contacted by their customers with an offer to give back to the community at large by putting their talents and Smartsheet skills to good use. This could take the form of building out a process workflow, template, or other COVID-related content in Smartsheet, or even brainstorming or providing inspiration to help healthcare organizations, hospitals, or non-profits ideate on how to tackle the problems they are currently facing. We know that the people and organizations who are on the front lines battling this unprecedented disease need some extra support right now.<\/p>

    If you have a skill to offer that you think could benefit those on the front lines fighting COVID-19 during this time, please share it here. And conversely, if you are an organization working to address the COVID-19 pandemic, please post your needs or requests for help here. We hope that by starting this conversation and providing a platform for our customers to connect with each other, together as a community we can scale our reach and help limit the spread of the virus. When we band together as a community to support those who need it most, we’re all better for it.<\/p>

    And finally, a simple request to make this “matching game” more effective: If you are seeking help, please start the title of your request with "SEEKING HELP." If you are offering assistance, please either reply to a SEEKING HELP post or start a new discussion starting with "OFFERING ASSISTANCE."<\/p>","bodyRaw":"[{\"insert\":\"Hi Smartsheet Community! I am Tasha Bishop, and I lead the Customer Success organization at Smartsheet. Though we are all facing unprecedented challenges in this new reality in light of the COVID-19 pandemic, I have been touched by how these difficult times have also brought out the best in people. Several members of my team have been contacted by their customers with an offer to give back to the community at large by putting their talents and Smartsheet skills to good use. This could take the form of building out a process workflow, template, or other COVID-related content in Smartsheet, or even brainstorming or providing inspiration to help healthcare organizations, hospitals, or non-profits ideate on how to tackle the problems they are currently facing. We know that the people and organizations who are on the front lines battling this unprecedented disease need some extra support right now.\\n\\nIf you have a skill to offer that you think could benefit those on the front lines fighting COVID-19 during this time, please share it here. And conversely, if you are an organization working to address the COVID-19 pandemic, please post your needs or requests for help here. We hope that by starting this conversation and providing a platform for our customers to connect with each other, together as a community we can scale our reach and help limit the spread of the virus. When we band together as a community to support those who need it most, we’re all better for it.\\n\\nAnd finally, a simple request to make this “matching game” more effective: If you are seeking help, please start the title of your request with \\\"SEEKING HELP.\\\" If you are offering assistance, please either reply to a SEEKING HELP post or start a new discussion starting with \\\"OFFERING ASSISTANCE.\\\"\\n\"}]","format":"rich","dateInserted":"2020-03-26T20:55:02+00:00","insertUser":{"userID":119872,"name":"Tasha Bishop","url":"https:\/\/community.smartsheet.com\/profile\/Tasha%20Bishop","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!XWDCX4qeDfY!7BjB--reSaY!rwhYt2nhl7j","dateLastActive":"2020-10-08T17:53:31+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/66956\/do-you-need-help-or-want-to-help-others-with-challenges-your-organization-is-facing-with-covid-19","embedType":"quote","name":"Do you need help or want to help others with challenges your organization is facing with COVID-19?"}"> https://community.smartsheet.com/discussion/66956/do-you-need-help-or-want-to-help-others-with-challenges-your-organization-is-facing-with-covid-19


  • @Stephanie Bauderthanks that was a great discussion and I am amazed by the level of support you have over there. I was hoping to get somebody who wanted some more permanent part-time work in New Zealand or Aussie as I realise the stress your communities must be under at the moment.

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi Ben,

    @Ben Smith

    I'd be happy to schedule a free discovery call to discuss your needs and how I might be able to help. How does that sound?

    Please e-mail me at[email protected]and we will take it from there.

    Be safe and have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @WORK BOLD

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Hi Ben,

    @Ben Smith

    First of all thanks for your post and for actively engaging with the the Smartsheet community.

    I lead Smartsheet's APAC business and am based in Sydney. If you would like to email me ([email protected]) and include Alex Di Blasio ([email protected]) who manages our APAC Customer Success organisation, we will happily see what we can do to help through our local resources, partners and communities.

    Stay safe and look forward to hearing from you.

    Cheers,

    Nigel

  • Hi Ben,

    I just came across this thread and think we may be able to help. We are@6STEP | RohannSmartsheet Platinum Partners based in Melbourne. We specialise in Project and Programme Management. We may have a few tools out of the box which may give you a good starting point.

    Please feel free to get in touch:[email protected]


    Cheers

    Rohann Chapman

I understand. Unfortunately, there is no other option that I see. One thing to make it easier for you to add the name is to have a helper column in the source sheet with a formula to identify duplicates. If there is a record with no duplicate (i.e., a new name added), you can get notified through a workflow and use that to add the name to your metric sheet.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":106975,"type":"question","name":"Case sensitivity when using data mesh","excerpt":"I set up a Data Mesh that is working quite well. Nurses enter their credential information and we use DataMesh to add other human resources information of record - including manager's email. The DataMesh is keying of of the common field of User ID. We noticed that for many of the nurses the match didn't work and also…","snippet":"I set up a Data Mesh that is working quite well. Nurses enter their credential information and we use DataMesh to add other human resources information of record - including…","categoryID":343,"dateInserted":"2023-06-27T19:39:23+00:00","dateUpdated":null,"dateLastComment":"2023-06-28T12:22:00+00:00","insertUserID":114017,"insertUser":{"userID":114017,"name":"Jacqueline Ennis","url":"https:\/\/community.smartsheet.com\/profile\/Jacqueline%20Ennis","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxZA0IOt6rrnETj3_ATzn0g7JjbJTEyOyIfrNKKb=s96-c","dateLastActive":"2023-06-27T20:08:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-28T13:21:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":33,"score":null,"hot":3375851483,"url":"https:\/\/community.smartsheet.com\/discussion\/106975\/case-sensitivity-when-using-data-mesh","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106975\/case-sensitivity-when-using-data-mesh","format":"Rich","lastPost":{"discussionID":106975,"commentID":382796,"name":"Re: Case sensitivity when using data mesh","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382796#Comment_382796","dateInserted":"2023-06-28T12:22:00+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-28T13:21:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-27T20:09:23+00:00","dateAnswered":"2023-06-27T20:09:03+00:00","acceptedAnswers":[{"commentID":382691,"body":"

Perfect. Thank you so much!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":106962,"type":"question","name":"Issue with cross-sheet =INDEX(MATCH()) formulas","excerpt":"I am consistently coming across an error where my cross-sheet referenced =INDEX(MATCH()) formulas are pulling the incorrect information. I am fairly certain my syntax is correct and that this is a bug. This is happening across multiple sheets I have. I have included one example, but note that I have found this to happen…","snippet":"I am consistently coming across an error where my cross-sheet referenced =INDEX(MATCH()) formulas are pulling the incorrect information. I am fairly certain my syntax is correct…","categoryID":321,"dateInserted":"2023-06-27T15:24:54+00:00","dateUpdated":null,"dateLastComment":"2023-06-28T13:34:44+00:00","insertUserID":162821,"insertUser":{"userID":162821,"name":"egardner","title":"IT Project Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/egardner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4VRPFNVQ0MWG\/n8WTXSBZQZI0N.JPG","dateLastActive":"2023-06-28T13:32:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162821,"lastUser":{"userID":162821,"name":"egardner","title":"IT Project Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/egardner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4VRPFNVQ0MWG\/n8WTXSBZQZI0N.JPG","dateLastActive":"2023-06-28T13:32:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":54,"score":null,"hot":3375841778,"url":"https:\/\/community.smartsheet.com\/discussion\/106962\/issue-with-cross-sheet-index-match-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106962\/issue-with-cross-sheet-index-match-formulas","format":"Rich","lastPost":{"discussionID":106962,"commentID":382828,"name":"Re: Issue with cross-sheet =INDEX(MATCH()) formulas","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382828#Comment_382828","dateInserted":"2023-06-28T13:34:44+00:00","insertUserID":162821,"insertUser":{"userID":162821,"name":"egardner","title":"IT Project Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/egardner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4VRPFNVQ0MWG\/n8WTXSBZQZI0N.JPG","dateLastActive":"2023-06-28T13:32:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/I4UKI5HYCYIO\/formula-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Formula.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-28T13:34:39+00:00","dateAnswered":"2023-06-28T13:01:09+00:00","acceptedAnswers":[{"commentID":382813,"body":"

The problem is with a misplaced parenthesis. That zero at the end is technically part of the INDEX function, but you want it as part of the MATCH function to denote an exact match.<\/p>


<\/p>

You have:<\/p>

INDEX(.........MATCH(...........), 0)<\/strong><\/p>


<\/p>

You want:<\/p>

INDEX(.........MATCH(..........., 0))<\/strong><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=341&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&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":5421,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Using Smartsheet