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.
Sheets with Formulas & Web Forms
Whats the best way to handle a sheet (with formulas) populated by a web form?
Right now, each Web Form populates at the end of the sheet, where the formulas stop, how can I eliminate that from happening?
Comments
-
J. Craig Williams ✭✭✭✭✭✭Laura,
You need to make sure the formulas exist in the two rows above the row added by the WebForm.
Craig
-
Laura ✭✭✭✭✭✭
Craig,
I changed the webform to populate to the top of the sheet and the formulas are working. When its set to the bottom of the sheet it skips several rows (with the formulas) and enters the information without the formulas. What could be the cause of this?
-
J. Craig Williams ✭✭✭✭✭✭
Sometimes a row appears to be empty, but is not.
Try deleting all the rows you think are empty and trying again.
Craig
-
Laura ✭✭✭✭✭✭
I cleared all the cells - it still did it.
I deleted several rows - it still did it.
-
Laura ✭✭✭✭✭✭
Does the web form keep up with the # of entries and assign them to the appropriate row?
I'm not seeing a real significance to the # of places being skipped. Its different each time.
-
Richard Rymill SBP ✭✭✭✭✭✭Laura
Craigs instructions are spot on and this shouldnt be happening?
Send an email to[email protected]and see what they say, I cannot recreate the same result?
Regards
RichardR ( i work with Craig)
-
Laura ✭✭✭✭✭✭
Thanks, I'll do that!
I'm not sure if there's something set that is causing this that i'm not aware of (I've made a copy of someones sheet and added 2 web forms).
Adding results to the top does not cause the issue, only the bottom.
-
J. Craig Williams ✭✭✭✭✭✭
Laura,
Sorry for the delay in getting back to you. I'm curious what support has to say.
Craig
-
Laura ✭✭✭✭✭✭
Sorry I'm just now seeing this Craig.
他们不确定。我救了the sheet as new, cleared out everything and the problem didn't return. So my issue of why it was doing it on the other sheet is still unknown. If my workload slows down anytime soon, I'll try to look deeper into trying to discover the cause. There has to be a reason!
Categories
Try IF([payment voucher]@row=0,Sum([Parking Revenue Regular]@row:[Private boat parking revenue]@row),\"//m.santa-greenland.com/community/discussion/8526/\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":106894,"type":"question","name":"How to Count a value in a drop down \/ multi-selection list?","excerpt":"Hi, I'm wanting to count the total amount time this value \"VAVE\" is being assigned to a drop down column. I'm using a summary sheet to collect this data using formulas. So in the request type column(drop down list) I want the total in this sheet. I also want a total by the Brand. I keep getting an incorrect number, like 48…","categoryID":321,"dateInserted":"2023-06-26T15:09:07+00:00","dateUpdated":"2023-06-26T15:09:27+00:00","dateLastComment":"2023-06-26T20:54:24+00:00","insertUserID":162246,"insertUser":{"userID":162246,"name":"Shawn_K2","url":"https:\/\/community.smartsheet.com\/profile\/Shawn_K2","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nPFlXyflhuI!uj8vZ9JIm_o!1axowkoO9t8","dateLastActive":"2023-06-26T20:56:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":162246,"lastUserID":116407,"lastUser":{"userID":116407,"name":"Darren Mullen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Darren%20Mullen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9WIC1TB7AJQT\/nP1GU5H4ITA1P.png","dateLastActive":"2023-06-27T00:05:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":53,"score":null,"hot":3375609211,"url":"https:\/\/community.smartsheet.com\/discussion\/106894\/how-to-count-a-value-in-a-drop-down-multi-selection-list","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106894\/how-to-count-a-value-in-a-drop-down-multi-selection-list","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106894,"commentID":382446,"name":"Re: How to Count a value in a drop down \/ multi-selection list?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382446#Comment_382446","dateInserted":"2023-06-26T20:54:24+00:00","insertUserID":116407,"insertUser":{"userID":116407,"name":"Darren Mullen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Darren%20Mullen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9WIC1TB7AJQT\/nP1GU5H4ITA1P.png","dateLastActive":"2023-06-27T00:05:24+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\/LKT88AUTSMAT\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-26T16:54:33+00:00","dateAnswered":"2023-06-26T16:44:18+00:00","acceptedAnswers":[{"commentID":382355,"body":"
