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.

Can you create a form that will populate a specific row and column of a sheet?

robert white ✭

05/08/15 edited 12/09/19 inArchived 2015 Posts

I want to gather the status on specific projects by sending a form. I would like that status to populate a specific row/column of a sheet.

Tags:

0 ·

Comments

Travis Employee

05/08/15

Hi Robert - Web forms cannot update existing rows but check out my response to a similar question which includes a couple workarounds you might consider using:https://community.smartsheet.com/discussion/tracking-time-spent-tasks-web-forms

0 · Share on Facebook Share on Twitter
PPS Solutions ✭✭✭✭✭

05/08/15

Hi Robert, as Travis suggests in his links, a good way of achieving this is setting up a task report which the users can update the data directly from.

Pete

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

You would set up conditions so that it will only send when Category is \"Project Name\" or Category is \"Objective\", so on and so forth then set up a \"custom message and only select the Category (if needed to provide context) and Description columns.<\/p>

<\/p>

\n \n $\"image.png\"$ <\/img><\/a>\n <\/div>\n<\/div>\n

<\/p>

\n \n $\"image.png\"$ <\/img><\/a>\n <\/div>\n<\/div>\n

<\/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":334,"urlcode":"automations","name":"Automations"}]},{"discussionID":109419,"type":"question","name":"Error When Importing Google Sheet","excerpt":"I was able to import this sheet successfully once as a test. Now when I try to import I get the attached error that states that the Excel file is invalid, but I didn't select to import and excel file! Any help would be appreciated!","snippet":"I was able to import this sheet successfully once as a test. Now when I try to import I get the attached error that states that the Excel file is invalid, but I didn't select to…","categoryID":321,"dateInserted":"2023-08-24T17:09:06+00:00","dateUpdated":null,"dateLastComment":"2023-08-24T20:30:09+00:00","insertUserID":165633,"insertUser":{"userID":165633,"name":"BudGarrison","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/BudGarrison","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-24T20:29:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":165633,"lastUser":{"userID":165633,"name":"BudGarrison","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/BudGarrison","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-24T20:29:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":28,"score":null,"hot":3385807155,"url":"https:\/\/community.smartsheet.com\/discussion\/109419\/error-when-importing-google-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109419\/error-when-importing-google-sheet","format":"Rich","tagIDs":[219,445],"lastPost":{"discussionID":109419,"commentID":392484,"name":"Re: Error When Importing Google Sheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392484#Comment_392484","dateInserted":"2023-08-24T20:30:09+00:00","insertUserID":165633,"insertUser":{"userID":165633,"name":"BudGarrison","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/BudGarrison","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-24T20:29:18+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/A73RHH8WRAUW\/capture-jpg.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.JPG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-24T20:30:03+00:00","dateAnswered":"2023-08-24T20:09:35+00:00","acceptedAnswers":[{"commentID":392473,"body":"

Is there any data in the source file?<\/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":219,"urlcode":"sheets","name":"Sheets"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"}]},{"discussionID":109378,"type":"question","name":"How do I change the font (size and type) in a pie chart?","excerpt":"Hello, As per the attached screen shot, I am trying to change the size of the font (%ages) in the pie chart but unable to do so? I changed the font in the legend but not sure if it is possible to change it in the actual percentages? Please advise. Thanks","snippet":"Hello, As per the attached screen shot, I am trying to change the size of the font (%ages) in the pie chart but unable to do so? I changed the font in the legend but not sure if…","categoryID":321,"dateInserted":"2023-08-24T06:25:39+00:00","dateUpdated":null,"dateLastComment":"2023-08-25T05:29:52+00:00","insertUserID":158545,"insertUser":{"userID":158545,"name":"Safiya B","url":"https:\/\/community.smartsheet.com\/profile\/Safiya%20B","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T05:28:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":158545,"lastUser":{"userID":158545,"name":"Safiya B","url":"https:\/\/community.smartsheet.com\/profile\/Safiya%20B","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T05:28:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":24,"score":null,"hot":3385800931,"url":"https:\/\/community.smartsheet.com\/discussion\/109378\/how-do-i-change-the-font-size-and-type-in-a-pie-chart","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109378\/how-do-i-change-the-font-size-and-type-in-a-pie-chart","format":"Rich","lastPost":{"discussionID":109378,"commentID":392520,"name":"Re: How do I change the font (size and type) in a pie chart?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392520#Comment_392520","dateInserted":"2023-08-25T05:29:52+00:00","insertUserID":158545,"insertUser":{"userID":158545,"name":"Safiya B","url":"https:\/\/community.smartsheet.com\/profile\/Safiya%20B","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T05:28:53+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-08-25T05:28:50+00:00","dateAnswered":"2023-08-24T09:55:27+00:00","acceptedAnswers":[{"commentID":392270,"body":"

@Safiya B<\/a> <\/p>

Sadly you are unable to change the label font and size. Have you tried changing to a Semicircle pie at all? That sometimes sorts out labelling issues!<\/p>

Kind regards<\/p>

Debbie<\/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&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":[]}">