Hi all,
I've been doomscrolling through various forums to figure out what's going wrong here, but I can't figure out where.
I'm trying to filter so that I only get the rows returned in column 'datestamp' that are empty, see below:
With OData filter this should be something like 'datestamp eq null' but it keeps throwing an error.
Thanks for looking into this.
Hi Marvin,
How do I create the formula when the column name has a space between two words?
For example: `Serial Number eq null`. I have an Excel file with a table that includes a column named `Serial Number`. I need to filter and return all cells in this column that are empty.
Many thanks,
Russ
Hi @Anonymous
Have you tried using the formula provided by @MarvinBangert ?
If your problem have been solved by @MarvinBangert 's solution, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!
Best Regards.
Hey @Anonymous
did you try this formula?
datestamp eq ''
Does this help you? Otherwise please give me some more information.
Best regards
Marvin
If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.
Blog: Cloudkumpel
Michael E. Gernaey
566
Super User 2025 Season 1
David_MA
516
Super User 2025 Season 1
stampcoin
492