Blank rows at bottom of sheet
I have 12 rows at the bottom of a sheet that I have deleted but they instantly come back. These are messing up my calculation sheets. How do I get rid of them? Why are they there anyway?
Answers
-
Hello. There is always 10 blank lines in a sheet - I can't find the article that says this but I know it is true. I have adjusted my formulas to ignore a row if a column is blank. For example, if the primary column is blank, don't count that row.
Hope this helps.
Peggy
-
I need to use the columns for vlookups and this doesn't work for me. Is there any way to do this?
-
-
Thank you for the screenshot. What column in the above screenshot do you have your VLOOKUP formula in? Column 2?
Peggy
-
If Column 2 contains your VLOOKUP formula, I would add this to the beginning:
=IF(ISBLANK([Primary Column]@row), "", "VLOOKUP(…
This will process the VLOOKUP as long as the Primary Column has something in it.
Hope it helps.
Peggy
-
THe 13 no assigned should only be 1, the 12 blanks at bottom of sheet skew the data. Yes column 2
-
Thank you Peggy. This is my formula, Where do I put the beginning formula portions?
=COUNTIF({Little Sheet Range 1}, "PERSON NAME")
-
Actually I have another concern. If my formula says ISBLANK at rows 25-37, once those rows get data from the form that populates it, I would have to go back and change the formula to move down each time? It would seem that would be true. Am I wrong?
-
Could you provide a screenshot of your sheet that is in your formula above, Little Sheet Range 1 please?
Thanks
Peggy
-
I'm assuming that the Little Sheet Range 1 is the Assigned To column.
Try deleting the formula you have entered; save your sheet and then re-enter this formula into Column2 of the below sheet:
=COUNTIF({Little Sheet Range 1 Assigned To}, [Primary Column]@row)
Make sure that the Assigned To column stays highlighted when selecting the range (I've had issues with this changing on me before).
My test sheet had 31 blank rows and it didn't count them in the formula. I would make Column2 a column formula column as well.
Hope this helps.
Peggy
-
Sure would like to have a TEAMS/Zoom convo with you about this. I'm just not seeing how this works.
-
Happy to have a Zoom call. Let me know what time works for you and your email and I'll send an invite.
Peggy
-
Great. I am available now if you are?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives