Formula - If a Date is in the cell - bring backed Shippped

Question

Hi Community,

Need some help please trying to add a  formula column to a workflow to  say if the re is a date  tell me its shipped, otherwise say not shipped ( for cells with no date)

Formula I was thinking was

Replace([PGI Date], >"", 'shipped', 'not shipped'))

Can someone please advise the correct logic.

TIA

Karl.

Alteryx.PNG

MarqueeCrew · Accepted Answer

@Karl_Spratt ,

Please try:

IIF(isEmpty([PGI Date]), "not shipped", "Shipped")

That should do the trick.

Cheers,

Mark