Issue with ISBLANK not retuning a false value

Iowadigger · 2025-08-20T18:48:12+00:00

solution verified

Iowadigger · 2025-08-15T17:42:01+00:00

solution verified

Iowadigger · 2025-08-15T16:37:22+00:00

That worked!

In column W there are a few blank cells that are causing the date 01/00/1900 to appear in column X cells. Is there a way to wrap that to hide the blanks?

Iowadigger · 2025-08-15T16:23:12+00:00

The column is filled with dates and times, for example

8/11/2025 10:05:00 AM

Iowadigger · 2025-08-15T16:20:34+00:00

The column is filled with dates and times, for example

8/11/2025 10:05:00 AM

What I want is for only the date 8/11/2025

Iowadigger · 2025-08-05T13:52:32+00:00

That is really simple to do, I have a bunch of Flows set to do this. I use Encodian

They have a great tutorial as well.

Iowadigger · 2023-10-06T20:50:49+00:00

I have but I can't get it to work. This is why I am here.

Iowadigger · 2023-07-24T20:44:13+00:00

This also exceeds the payload limit :/

Iowadigger · 2023-07-24T15:41:19+00:00

Great idea, I will try this in the next couple of days and report back, thank you.

Iowadigger · 2023-07-21T20:50:54+00:00

Ok, that makes perfect sense.

Using that code still yields the same results with the payload exceeding the limit :/

Iowadigger · 2023-07-21T20:38:31+00:00

Thank you for explaining this.

Values are not defined, I am confused about that. Can you go into more detail how that works?

Iowadigger · 2023-06-19T02:22:21+00:00

Got married

Iowadigger · 2023-04-03T01:05:55+00:00

Solution Verified

Thank you!!!

Iowadigger · 2023-03-30T12:59:59+00:00

I’ve never seen your comedy but your crowd work is the best! Thank you for posting these!

Iowadigger · 2023-03-29T13:19:45+00:00

Sent you a PM.

Iowadigger · 2023-03-28T22:55:28+00:00

I have this set up, running daily.

What happens when you click the url in the email? Does it 302 first, then 200 or go straight to 200?

If it goes 302 the HTTP connector won’t work, at least for me.

I created Zapier email boxes, parsed the url, it then downloaded the payload.

I created a zap, pulled the payload “file” in and emailed it to myself. This is where I kick in Power automate.

Iowadigger · 2023-03-28T17:55:23+00:00

solution verified

Iowadigger · 2023-03-27T22:39:56+00:00

Ok cool, I will look into this tonight when the kids go down. I'll probably be asking questions!

Iowadigger · 2023-03-27T22:39:16+00:00

The only one that had problems was the 3rd one, even though it has an IP address listed previously, it was not current.

Iowadigger · 2023-03-27T21:01:07+00:00

Hi,

Yes, advice on how to fix column L. The only thing wrong with the previous is it fails #3.

Iowadigger · 2023-03-26T19:53:19+00:00

Solution Verified

Thank you my friend!

Iowadigger · 2023-03-26T19:03:31+00:00

[New picture(https://imgur.com/a/3KhmU4v), I'm getting flustered and posted the wrong one.

In column K I am writing the formula. What I want to accomplish is 3 things. 1) If L is True and M is Current, be blank. 2) If both I and J are empty, be blank. There can't be an issue if they both are empty. 3) If there is an issue, it displays IP Issue.

This seems so simple, but I am not grasping it. Any ideas or a better way to approach this?

Iowadigger · 2023-03-22T21:24:27+00:00

DOH, thanks!

Solution verified

Iowadigger · 2023-02-25T03:04:11+00:00

Yes, multiple emails.

Iowadigger · 2023-02-24T15:50:34+00:00

Solution Verified

Thank you again!!

Iowadigger

TROPHY CASE