Checking if a cell has absolutely nothing in it
I have a sheet where I have needed to suppress any errors with ISERROR function. The formulas are showing blank now because division by zero errors are suppressed. The formulas will show data when data is entered in other cells. The issue is when someone adds a row to the sheet, I want to make it apparent that they forgot to copy these formulas into the new row by doing a check.
I created a column called "VALID ROW ?" with this formula =IF(OR(ISBLANK([VALUE / HOUR]7) = 1, ISBLANK([PICK NEXT]7 = 1)), "No", "Yes"), but that won't work because it's checking if the cells are blank, not empty. Is there a function that checks if a cell is completely empty, including not only blanks, but formulas that are returning blanks?
Thank you!
Comments

the isblank formula should work even when a formula is returning a blank. I'm not 100% sure what is going on, but try to take off the =1 on the criteria.
=if(or(isblank({CellRef1}),isblank({CellRef2})),1,0)

L@123 is correct. If that still does not do the trick, you could change your original formula to display something instead of nothing and use conditional formatting to change the color of the text to match the color of the cell based on if that particular text is there or not. I usually just use "." for this.
This will give the cell something to count as, but will appear as blank.
You could then adjust your IF statement (I'll use my example above for this one) to something like this...
=IF(OR([VALUE / HOUR]7 = ".", [PICK NEXT]7 = ".", "No", "Yes")
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 352 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 443 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!