Add Comment Section to a form
Hello,
Is there a way to add the comments section to a form? Or a formula to move / copy text from a comments column into the comments section?
Thanks!
Matt L.
Best Answer
-
Andrée Starå ✭✭✭✭✭✭Hi Matt,
Unfortunately, it's not possible at the moment, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment to have your vote added
As a workaround, the third-party service, Zapier, could be an excellent option for this scenario. Is that an option for you?
I hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @WORK BOLD
✅Did my post help answer your question or solve your problem? Please help the Community bymarking it as the accepted answer. It will make it easier for others to find a solution or help to answer!
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.
Answers
-
Andrée Starå ✭✭✭✭✭✭
Hi Matt,
Unfortunately, it's not possible at the moment, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment to have your vote added
As a workaround, the third-party service, Zapier, could be an excellent option for this scenario. Is that an option for you?
I hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @WORK BOLD
✅Did my post help answer your question or solve your problem? Please help the Community bymarking it as the accepted answer. It will make it easier for others to find a solution or help to answer!
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.
-
Matt Lanterman ✭✭✭✭✭
Hi Andre,
Thank you for the response and confirmation. I submitted an enhancement request as well.
I don't think Zapier would assist in this scenario as far as i can tell, thank you for the reference. It looks like there may be other functions they offer that could assist in other projects I am working on.
Have a great day,
Matt
-
Andrée Starå ✭✭✭✭✭✭
Excellent!
Happy to help!
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.
-
Agreed about this feature - it's great that comments can be added through the "request an update" feature, but wish it was available in a form, without having to add a Comment column and then copy the data out. Adds way too many steps to my projects.
-
Waleed ✭✭✭I came to this post as was searching for the same , this feature is important
-
Dylan J ✭✭
Need this also. It's a limiting factor.
-
Need this also.
-
Also please.
-
Agree. This'd be a very helpful function.
-
Eliz ✭Agree. I need my Comments to be easily visible in my Dashboards and Reports, just like Excel allows the Show/Hide feature for Notes/Comments.
-
JCardinal ✭✭✭✭
@Matt LantermanI'm not seeing your enhancement request to upvote. Do you happen to have a link?
I did come across this one, if anyone else is interested in upvoting:https://community.smartsheet.com/discussion/100259/form-fields-to-include-comments
Joanna Cardinal(she, her, hers)
Categories
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":57,"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":[]}">
