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?
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.
Comments
-
Travis EmployeeHi 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
-
PPS Solutions ✭✭✭✭✭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
Categories
<\/p>
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/5CGCP8G537D4\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n<\/p>
<\/p>
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/285T2OEAKI5B\/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":"
