Sheet Export to Excel has 1 Blank Row in the middle
Hi there,
I'm stumped on this one. I have a basic Sheet with 1944 rows. There are no blank rows. When I do a basic export to excel, one blank row gets inserted at row 1758 of the excel file. The excel file has 1946 rows (1 is blank and 1 is the header) so no info is missing. I can't see anything in the smartsheet rows that would be causing a blank. Any help would be appreciated! Thanks!
It's easy enough to go into the Excel file each time and remove a row, but it's broken my automations (sort and filter in excel breaks due the blank row).
Best Answer
-
Genevieve P. Employee AdminHey@Ryan Levitz
Is it possible that there is indeed a blank row in your Smartsheet sheet at row 1756? I would try applying a filter to the Sheet if a specific cell is blank to see what comes up.
I will note that the fact that the row doesn't have a Date from your System column is very odd - it means this row doesn't have any data at all.
Once you apply a filter to show all blank rows, I'd suggestdeletingthe first 5 rows in case one of them is in the middle of your other data. Then try exporting again!
Cheers,
Genevieve
Answers
-
Genevieve P. Employee Admin
Hey@Ryan Levitz
Is it possible that there is indeed a blank row in your Smartsheet sheet at row 1756? I would try applying a filter to the Sheet if a specific cell is blank to see what comes up.
I will note that the fact that the row doesn't have a Date from your System column is very odd - it means this row doesn't have any data at all.
Once you apply a filter to show all blank rows, I'd suggestdeletingthe first 5 rows in case one of them is in the middle of your other data. Then try exporting again!
Cheers,
Genevieve
-
Ryan Levitz ✭✭
Very strange. Filtering for blanks showed 10 rows, 1952-1961. I deleted the first 5 of those. Exported it and it all looks great. I appreciate the help!
-
Genevieve P. Employee Admin
No problem! This was definitely a strange one
Categories
<\/p>
You can just include a blurb that says that they are acknowledging by submitting within the Approval automation.<\/p>
<\/p>
You can set up an update request automation as a reminder that they need to enter their initials if they submit but didn't the first time.<\/p>
<\/p>
The last option I can think of that would truly make it required is a bit complex but possible. The first step is to create an \"approval sheet\". This sheet will have the same fields in it that you need to send in the approval request and a form created to match.<\/p>
<\/p>
You would then take the base form URL and drop it into a formula on the original sheet that allows you to basically generate a custom form on each row that will have the row data prefilled when someone clicks on the URL in that row. Since you can make form fields required, this will give you the ability to require their acknowledgement prior to them submitting their approval.<\/p>
<\/p>
Send this custom form URL through an alert and instruct the users to click the link to open the approval form.<\/p>
<\/p>
The form entry would populate the \"approval sheet\", but you can use formulas with cross sheet references to pull the appropriate data back over to your original sheet.<\/p>
<\/p>
If that last option sounds like something you would be interested in, fell free to let me know, and I will try to pull together a few links to help you get started building the formula.<\/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":300,"urlcode":"Email Notifications","name":"Email Notifications"}]},{"discussionID":108163,"type":"question","name":"Can we use IFERROR and ISBLANK in the same formula together?","excerpt":"I want help for the following formula: I want to divide two columns based on UniqueWorkstream column if it has any value. If the workstream column is blank, it should not show any value. For that I have used the formula: =I=IF(ISBLANK(UniqueWorkstream@row), \" \", [Count of Tasks Overdue(Schedule)]@row \/ [Total…","snippet":"I want help for the following formula: I want to divide two columns based on UniqueWorkstream column if it has any value. If the workstream column is blank, it should not show any…","categoryID":321,"dateInserted":"2023-07-27T06:30:22+00:00","dateUpdated":null,"dateLastComment":"2023-07-27T12:23:16+00:00","insertUserID":162321,"insertUser":{"userID":162321,"name":"sweta22","title":"Sweta Patnaik","url":"https:\/\/community.smartsheet.com\/profile\/sweta22","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-27T14:33:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-07-27T12:22:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":24,"score":null,"hot":3380901818,"url":"https:\/\/community.smartsheet.com\/discussion\/108163\/can-we-use-iferror-and-isblank-in-the-same-formula-together","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108163\/can-we-use-iferror-and-isblank-in-the-same-formula-together","format":"Rich","lastPost":{"discussionID":108163,"commentID":387493,"name":"Re: Can we use IFERROR and ISBLANK in the same formula together?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387493#Comment_387493","dateInserted":"2023-07-27T12:23:16+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-07-27T12:22:19+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\/TLJ96BBODZEA\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-27T11:46:18+00:00","dateAnswered":"2023-07-27T07:49:05+00:00","acceptedAnswers":[{"commentID":387451,"body":"
Hi @sweta22<\/a> <\/p> I hope you're well and safe!<\/p> Try something like this.<\/p> =IF(UniqueWorkstream@row <> \"//www.santa-greenland.com/community/discussion/104091/\", IFERROR([Count of Tasks Overdue(Schedule)]@row \/ [Total Tasks(Schedule)]@row, \"//www.santa-greenland.com/community/discussion/104091/\"))<\/p> Did that work\/help? <\/p> I hope that helps!<\/p> Be safe, and have a fantastic week!<\/p> Best,<\/p> Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/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":[]},{"discussionID":108095,"type":"question","name":"Data Security and Risk Management","excerpt":"I would like to know more about data security in Smartsheet. Does Smartsheet has appropriate third-party security assessment. For example, regular vulnerability or penetration tests of your data centre and systems?","snippet":"I would like to know more about data security in Smartsheet. Does Smartsheet has appropriate third-party security assessment. For example, regular vulnerability or penetration…","categoryID":321,"dateInserted":"2023-07-26T14:37:15+00:00","dateUpdated":"2023-07-26T14:43:16+00:00","dateLastComment":"2023-07-27T10:45:28+00:00","insertUserID":162627,"insertUser":{"userID":162627,"name":"Simhadri","title":"Ratnanjali","url":"https:\/\/community.smartsheet.com\/profile\/Simhadri","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-27T10:46:02+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-07-27T12:22:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":30,"score":1,"hot":3380839063,"url":"https:\/\/community.smartsheet.com\/discussion\/108095\/data-security-and-risk-management","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108095\/data-security-and-risk-management","format":"Rich","lastPost":{"discussionID":108095,"commentID":387468,"name":"Re: Data Security and Risk Management","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387468#Comment_387468","dateInserted":"2023-07-27T10:45:28+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-07-27T12:22:19+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-27T11:02:06+00:00","dateAnswered":"2023-07-27T09:07:49+00:00","acceptedAnswers":[{"commentID":387458,"body":" Hi @Simhadri<\/a> <\/p> I hope you're well and safe!<\/p> Have you explored these resources?<\/p>
