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.
Webform names don't match to contact list when inputted on form
Comments
-
Travis Employee
Hi Mark - web forms do not have a way to look into your contacts or to link inputted names to Smartsheet users in your sheet. The best option is to fix the name in your sheet after the form is submitted.
0 -
年代tephanie Taylor ✭✭✭✭✭✭
Can you prepopulate the names in the webforms? That way they are entered to match your contact list. Or do you have too many different people using the webforms?
0 -
Travis Employee
年代tephanie - you could pre populate a contact list field with a single value but this would come in as text, not as a contact (just like if you typed it in). There is not a workaround to link an entered name to a user at this time. You would need to fix the name once it is in the sheet.
I will pass this feature suggestion along to our product team!
0 -
Thanks for all the suggestions. The fixing of the name to match pre-existing submitter is what has to be done now. It's just heavy manual process to do. What could be good is if a submitter to the webform has already used the form before that it could offer the name back to the submitter. So a vlookup when the submitter start typing their name from the smartsheet pre-existing information, this would then allow them pick the match. Is this something smartsheet could think of doing? Thanks.
0 -
Travis Employee
Mark - there aren’t any near term plans for this functionality but I did send this request to our product team for consideration in future development. Thanks Mark!
0 -
David Bauman ✭✭✭✭✭✭
I agree with Mark! This would be so helpful. In the sheet, contacts are selected from a drop down menu, but the same field in the Webform doesn't give you a drop-down option (unlike other drop-down fields which do work...) Seems like it would be an important thing to fix.
Thanks!
Dave
1 -
If you use a contact's email address instead of their name, then SmartSheet makes the connection. This is useful in webforms and when copy excel data into Smartsheet that have contact fields.
0 -
Hi Guys,
Any news on when this functionality might be added?
K
0 -
Hi Guys,
Just a thought building out on the webforms issue for contact names. Assuming that logic that smartsheet promotes collaboration, having a situation where you can be sure the right name and person is collaborating, wouldn't it make sense that you have a drop down choice of names on webform to an existing smartsheet user?
If the person is new, they get to to a basic register to get their contact name consistent? of course only on webforms where a contact name is required.
年代calability of having freeform inconsistent names and manually having to correct isn't working on a large population.
Thanks,
Mark0 -
Travis Employee
Hi everyone! We appreciate the feedback and understand your concerns. Our goal is to make Smartsheet the best and easiest way to collaborate, plan, and monitor projects and tasks and are constantly improving the product. I don't have any updates on this particular feature, but you can check out our product roadmap to see what we are currently working on:www.santa-greenland.com/product-roadmap
0 -
This is an excellent request and I will check the roadmap to see if it makes it soon!
0 -
Gordon ✭✭✭✭✭✭
I tried entering an email address into the webform contact list field per Brian Veasman's ealier suggestion, but S/S still does not seem to make the connection in the sheet to my existing Team account/contact data.
Any updates on this critical feature for us, or perhaps a creative workaround? I'm looking for a way to setup reminders and alerts for the sheet tied to a contact list field that is input via webform.
0 -
You stated that if you use a contact's email address instead of their name, then SmartSheet makes the connection. I have not found this to be true. I copy from Excel or from SQL and I have tried the contact's email address and I still have to manually type in the name from the drop down. I was curious if I need it in a certain format? I just have[email protected]Do I need quotes or anything special to get it recognize it? I noticed that if I import from Excel it recognizes it but not a copy. Thanks for any suggestions. This is quite a daily time consuming function I have to do. I have over 500 rows that I copy in each day and that is the only field I have to manually type.
0 -
Kent Vaughn ✭✭✭✭✭✭
+1 from me.
这是另一个我只是其中的一个特性find hard to believe isn't implemented. Unless I'm missing some critical detail, If I don't have the contact information then the reminders/alerts won't be able to send emails, correct? So this would imply that trying to do something as simple as an action item list via a web form means you would have to go into the sheet to enter the actual contact information. ( It might be possible to enter the email address in the Contact Field and have the contact column "link up" so to speak. But having to type in an email address for every "todo" seems terribly inefficient ).
0
Categories
I hope you're well and safe!<\/p>
Unfortunately, adding a formula using a Workflow is not possible now, but it's an excellent idea!<\/p>
Please submit this as a Product Feedback or Idea <\/strong>(If it hasn't been added already)<\/em><\/strong> when you have a moment.<\/strong><\/a><\/p> Here's a possible workaround or workarounds <\/strong><\/p> Would 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","log":{"dateUpdated":"2022-09-23 11:02:53","updateUser":{"userID":152771,"name":"Brandon Austin","url":"https:\/\/community.smartsheet.com\/profile\/Brandon%20Austin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-23T12:20:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":95773,"type":"question","name":"Contract Expiry date less than 0,30,90,180 days from todays date apply RAG","excerpt":"I have a RAG dropdown column configured, a formula is required for the RAG to be applied against the following: Expiry date 180 greater than todays date = Green Expiry date is between 180 - 90 days greater than todays date = Yellow Expiry date is between <0 - 60 days greater than todays date = Red The Expiry date is a…","categoryID":322,"dateInserted":"2022-09-22T13:48:53+00:00","dateUpdated":null,"dateLastComment":"2022-09-23T10:59:18+00:00","insertUserID":152708,"insertUser":{"userID":152708,"name":"Lee Rudd","url":"https:\/\/community.smartsheet.com\/profile\/Lee%20Rudd","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-23T10:57:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":152708,"lastUser":{"userID":152708,"name":"Lee Rudd","url":"https:\/\/community.smartsheet.com\/profile\/Lee%20Rudd","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-23T10:57:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":26,"score":null,"hot":3327786491,"url":"https:\/\/community.smartsheet.com\/discussion\/95773\/contract-expiry-date-less-than-0-30-90-180-days-from-todays-date-apply-rag","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95773\/contract-expiry-date-less-than-0-30-90-180-days-from-todays-date-apply-rag","format":"Rich","lastPost":{"discussionID":95773,"commentID":344541,"name":"Re: Contract Expiry date less than 0,30,90,180 days from todays date apply RAG","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/344541#Comment_344541","dateInserted":"2022-09-23T10:59:18+00:00","insertUserID":152708,"insertUser":{"userID":152708,"name":"Lee Rudd","url":"https:\/\/community.smartsheet.com\/profile\/Lee%20Rudd","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-23T10:57:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-23T10:59:31+00:00","dateAnswered":"2022-09-22T17:39:19+00:00","acceptedAnswers":[{"commentID":344457,"body":" hi @Lee Rudd<\/a> <\/p> This gives you what you asked for;<\/p> =IF([expiry date]@row > TODAY(179), \"Green\", IF([expiry date]@row > TODAY(89), \"Yellow\", IF([expiry date]@row < TODAY(61), \"Red\")))<\/p> But what about if it is between 60 and 90?<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-23 10:59:31","updateUser":{"userID":152708,"name":"Lee Rudd","url":"https:\/\/community.smartsheet.com\/profile\/Lee%20Rudd","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-23T10:57:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":95777,"type":"question","name":"How to overrule a 0 multiplication formula returning 0 as an answer?","excerpt":"Hi all, haven't been able to find anything on this by searching so I'm posting. I'm hoping it is a simple fix as the formula seems very simple! I am attempting to calculate accident frequency rates at my company. I fully understand that anything multiplied by zero returns zero. However, if there have been no accidents I…","categoryID":322,"dateInserted":"2022-09-22T14:02:04+00:00","dateUpdated":null,"dateLastComment":"2022-09-23T07:52:12+00:00","insertUserID":145999,"insertUser":{"userID":145999,"name":"Mick Tim","url":"https:\/\/community.smartsheet.com\/profile\/Mick%20Tim","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-23T07:44:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-09-23T12:25:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":31,"score":null,"hot":3327777856,"url":"https:\/\/community.smartsheet.com\/discussion\/95777\/how-to-overrule-a-0-multiplication-formula-returning-0-as-an-answer","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95777\/how-to-overrule-a-0-multiplication-formula-returning-0-as-an-answer","format":"Rich","tagIDs":[219,254,281,285,319],"lastPost":{"discussionID":95777,"commentID":344532,"name":"Re: How to overrule a 0 multiplication formula returning 0 as an answer?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/344532#Comment_344532","dateInserted":"2022-09-23T07:52:12+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-09-23T12:25:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-23T07:45:59+00:00","dateAnswered":"2022-09-23T07:39:52+00:00","acceptedAnswers":[{"commentID":344527,"body":" Hi @Mick Tim<\/a> <\/p> I hope you're well and safe!<\/p> To add to Darren's excellent advice\/answer.<\/p> Try something like this.<\/p> =IF(OR([Jul Accidents]@row = 0, [Jul Accidents]@row = \"//www.santa-greenland.com/community/discussion/comment/3725/\"), \"No Accidents\", IF([Jul Accidents]@row = 0, July@row, SUM([Jul Accidents]@row * 200000 \/ July@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","log":{"dateUpdated":"2022-09-23 07:45:59","updateUser":{"userID":145999,"name":"Mick Tim","url":"https:\/\/community.smartsheet.com\/profile\/Mick%20Tim","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-23T07:44:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"},{"tagID":319,"urlcode":"functionality","name":"functionality"}]}],"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">