How do you pull form data in sights directly from a sheet?
I am trying automate pulling data entered in the form, that pulls into the sheet to then pull into a sight without using a report as the formatting is not very good, can anyone help?]
I have attached a screen shot to support above.
Thanks
Comments
-
J. Craig Williams ✭✭✭✭✭✭Harris,
See if this helps:
http://ronin-global.com/2017/01/09/smartsheet-referencing-a-cell-that-doesnt-exist-yet/
Craig
Categories
If you're looking to have the widgets themselves side by side, then you can set up multiple, individual widgets and put them next to each other.<\/p>
So \"side by side\" is better described as \"link\/icon and text are side by side!\"<\/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":[{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":533,"urlcode":"web-content-widget","name":"web content widget"}]},{"discussionID":107953,"type":"question","name":"Adding name to automated workflow message","excerpt":"I created a workflow that notifies an individual when his\/her license is about to expire. There is a notification that goes out at 30 days that also notifies the individual's manager. The workflow runs fine, however, there is no way for the manager to tell which one of his\/her staff the message was intended for AND in some…","snippet":"I created a workflow that notifies an individual when his\/her license is about to expire. There is a notification that goes out at 30 days that also notifies the individual's…","categoryID":321,"dateInserted":"2023-07-23T17:22:23+00:00","dateUpdated":null,"dateLastComment":"2023-07-23T18:58:20+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-07-23T18:56:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":114017,"lastUser":{"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-07-23T18:56:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":20,"score":null,"hot":3380272843,"url":"https:\/\/community.smartsheet.com\/discussion\/107953\/adding-name-to-automated-workflow-message","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107953\/adding-name-to-automated-workflow-message","format":"Rich","lastPost":{"discussionID":107953,"commentID":386567,"name":"Re: Adding name to automated workflow message","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386567#Comment_386567","dateInserted":"2023-07-23T18:58:20+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-07-23T18:56:42+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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-25T09:39:01+00:00","dateAnswered":"2023-07-23T18:44:43+00:00","acceptedAnswers":[{"commentID":386564,"body":"
In the subject and\/or body of any notification, you can add data from the row itself using double-curly brackets and the column name. So this might mean your message looks something like this:<\/p>
The following individual's license expires in 30 days:<\/p>
{{Contact Name}} (where \"contact name\" is the name of your column with the person's name in it)<\/p>
This merges information from the row into the body of the email notification. See screenshot for alert notification - CUSTOMIZE MESSAGE, and the instructions embedded in Smartsheet that outline how to use this feature.<\/p>
![\"Screen](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/GMRJ5CWSRP3C\/screen-shot-2023-07-23-at-2-43-09-pm.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
