Welcome to the Smartsheet Forum Archives


这个论坛的帖子不再监视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.

Webforms for help requests - best practices

We have a webform created that our customers can fill out to submit help requests. What is the best way to disseminate this webform and make it available for them to fill out? I don't want to have to email it to them, but at the moment I don't have a space on a webpage to embed the link/form. Would that be the best way to go, or are there other options to drive traffic to the webform?

Thanks!
Jeremy

Comments

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

    Jeremy,

    Put yourself in your customer/clients shoes (if they wear shoes).

    Where are they when they find themselves in need of help?

    Are they using a software product or app? The Help menu might be a good place.

    Are they away from their computer? Tablet or smart phone an option?

    From my experience, if it is hard or something that needs to be done "back at the office", you'll lose 80% of the feedback because it will never get written.

    Craig

  • Tim Meeks
    Tim Meeks ✭✭✭✭✭✭

    Jeremy,

    I concur with Craig. I would also ask "How are they contacting you today?" I assume by phone and email?

    If so, what you may have to start doing is communicating with them when they contact you and letting them know about the form.

    But even if you tell them, you have to get the webform URL to the method by which they access your site, etc. If you are not able to put this on a webpage, email or text may be your best workaround as the webform URL is not an easy to remember address.

    Hope this helps.

    Tim

  • JamesR
    JamesR ✭✭✭✭✭✭
    edited 01/14/16

    Jeremy,

    There are only two ways to get your customer to the Form:

    Email Link

    Embeded Link/Form on a Web page

    I would go for Web Page in a customer Portal or on yur Main Company website as standard and the perhaps a marketting campain to get people to the relevent page and info.

    If using e-mail then again if it is part of a marketing campaign that may work or you could always have the link as part of your signiture block in your mail.

    I hope this helps.

    JamesR

  • Craig, Tim, & James --

    Thanks for the helpful feedback. This helps confirm for me that this webform won't be as effective as I want it to be without an easy way for customers to get to it, specifically a web presence (it's really a no-brainer -- I just need to put in more time and involve more people now). I do like the signature block idea, and we may try that route in the meantime. Thanks again.

    Jeremy

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

    I really like the email signature block idea. A lot.

    Thanks James!

    Craig

  • Richard Rymill SBP
    Richard Rymill SBP ✭✭✭✭✭✭
    edited 01/14/16

    Another idea that might work... one of our Health and Safety clients has printed notices that include a QR Code that when used by a mobile, takes users straight to the Smartsheet Form to complete an accident report on their smartphone. Easy solution in the right location. That might help as part of a range of routes to your form along with suggesting your users save the link to their Desktop, be that phone, tablet or Pc. for when they need it.

    Regards

    RichardR

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

    That is a neat tip, Richard.

    Craig

  • Tim Meeks
    Tim Meeks ✭✭✭✭✭✭

    I concur Craig.. That is a neat tip Richard shared. At my state agency, we are still floaing around paperforms. QR Codes seem light years away....SealedLaughing

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 01/15/16

    不是光年,你可以试试abama.:)

    But I know the feeling. I recently applied to a huge multi-national engineering firm and had to fill out a four page paper application form. The cost savings for moving even that to Smartsheet is not insignificant.

    There are currently 800+ job opening world wide. Over half (450+) of those in the US.

    Let's assume that the US HQ / HR does not do the hiring overseas and use 400 for back of the Smartsheet forum for the calcs.

    Let's assume an average of 10 apps per job make it past the initial screening. Some more, some less, 10 is OK.

    4000 paper applications.

    3 months to fill the job.

    For such a large corp this may be just maintenance and not growth.

    16000 per year.

    About half an hour to fill out the form, probably half that to have someone type it into a computer. I assume they do that.:)

    4000 hours. Two persons, full time.

    To do something that the applicant should have done originally.

    That does not take into account errors in translating horrible handwriting (like mine).

    And this could be fixed with a few Smartsheets and a nice front end (or series of Webforms).

    At 30k salary, even if I am off by an order of magnitude, we're still looking at 6k cost per year.

    Maybe I should call their HR guy...

    Craig

  • Great feedback, all. Thanks! Yes, QR codes seem light years away, but I hear they're fairly easy to generate. I'm no expert, but this may be an option.

This discussion has been closed.
Try this:<\/p>

=IF(COUNT(CHILDREN()) = 0, IF(OR(Done@row = 1, [N\/A]@row = 1), 1, 0), AVG(CHILDREN()))<\/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":108195,"type":"question","name":"COUNTIF Function Not Working Correctly","excerpt":"Hello, I have a COUNTIF function I am using to count all cells that are 'Blank' in a column. We should have one result, but the formula is showing as zero. Any thoughts on this one? =COUNTIF([Account Dashboard]:[Account Dashboard], \" \")","snippet":"Hello, I have a COUNTIF function I am using to count all cells that are 'Blank' in a column. We should have one result, but the formula is showing as zero. Any thoughts on this…","categoryID":322,"dateInserted":"2023-07-27T16:41:32+00:00","dateUpdated":null,"dateLastComment":"2023-07-27T19:11:08+00:00","insertUserID":164192,"insertUser":{"userID":164192,"name":"ewitt19205","url":"https:\/\/community.smartsheet.com\/profile\/ewitt19205","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!mo_vH-5dWnI!5OcveUI6Zjo!UtWovaSRry_","dateLastActive":"2023-07-27T19:07:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":164192,"lastUser":{"userID":164192,"name":"ewitt19205","url":"https:\/\/community.smartsheet.com\/profile\/ewitt19205","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!mo_vH-5dWnI!5OcveUI6Zjo!UtWovaSRry_","dateLastActive":"2023-07-27T19:07:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":26,"score":null,"hot":3380962360,"url":"https:\/\/community.smartsheet.com\/discussion\/108195\/countif-function-not-working-correctly","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108195\/countif-function-not-working-correctly","format":"Rich","lastPost":{"discussionID":108195,"commentID":387638,"name":"Re: COUNTIF Function Not Working Correctly","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387638#Comment_387638","dateInserted":"2023-07-27T19:11:08+00:00","insertUserID":164192,"insertUser":{"userID":164192,"name":"ewitt19205","url":"https:\/\/community.smartsheet.com\/profile\/ewitt19205","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!mo_vH-5dWnI!5OcveUI6Zjo!UtWovaSRry_","dateLastActive":"2023-07-27T19:07:23+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-07-27T19:10:56+00:00","dateAnswered":"2023-07-27T16:47:29+00:00","acceptedAnswers":[{"commentID":387588,"body":"

Hi @ewitt19205<\/a> <\/p>

Try removing the space between the quotes. You are counting all cells with 1 space in the cell. Blanks are counted with the quotes together.<\/p>

When counting blanks though, its also good to use a COUNTIFS and compare the blank off another column that always has a value. Like Countifs when the Project name is not blank (<>\"//www.santa-greenland.com/community/discussion/3920/\") and the Account Dashboard is blank (\"//www.santa-greenland.com/community/discussion/3920/\").<\/p>

I hope that helps.<\/p>

Thanks,<\/p>

Matt<\/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":108186,"type":"question","name":"Index\/Collect does not work with < symbol","excerpt":"Hi there, I am using the INDEX COLLECT formulas to get a value if a number is between two ranges. The issue is that I'm getting an #INVALID VALUE error in the following formula: =INDEX(COLLECT({TotalRiskFactor}, {RangeStart}, >=[Risk Score]@row, {RangeEnd}, <=[Risk Score]@row), 1) The problem is with the \"<\" symbol in the…","snippet":"Hi there, I am using the INDEX COLLECT formulas to get a value if a number is between two ranges. The issue is that I'm getting an #INVALID VALUE error in the following formula:…","categoryID":322,"dateInserted":"2023-07-27T14:55:04+00:00","dateUpdated":null,"dateLastComment":"2023-07-27T18:38:27+00:00","insertUserID":122906,"insertUser":{"userID":122906,"name":"Cesar Perez","url":"https:\/\/community.smartsheet.com\/profile\/Cesar%20Perez","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2uFV_3dM1no!ndnWXxsFlTw!JCwGNa_KQWy","dateLastActive":"2023-07-27T19:31:15+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-07-27T19:59:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":35,"score":null,"hot":3380955211,"url":"https:\/\/community.smartsheet.com\/discussion\/108186\/index-collect-does-not-work-with-symbol","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108186\/index-collect-does-not-work-with-symbol","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":108186,"commentID":387609,"name":"Re: Index\/Collect does not work with < symbol","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387609#Comment_387609","dateInserted":"2023-07-27T18:38:27+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-07-27T19:59:27+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/JURDPT6GMX1Y\/formula.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Formula.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-27T15:36:00+00:00","dateAnswered":"2023-07-27T15:02:42+00:00","acceptedAnswers":[{"commentID":387556,"body":"

The issue is with your arguments overall. Using the Score of 40 (as in your examples)...<\/p>


<\/p>

The score start range has to be 40 or greater, but the range end has to be less than or equal to 40.<\/p>


<\/p>

Try reversing it so that the start is less than the score and the end is greater than the score.<\/p>


<\/p>

Take a look at the second piece in your destination file. The formula is not throwing an error, but it is also not pulling the correct value in. It should be pulling in Moderate because 40 is between 35 and 54, but it is pulling in Moderate-High because that is the first entry where the Range Start is greater than 40.<\/p>"},{"commentID":387563,"body":"

You have your greater than and less than backwards. Your formula is saying to looking for the start date to be greater than 40 and the 35 is less than 40.<\/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