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

[Karl_Spratt]

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. 

[MarqueeCrew · Accepted solution]

@Karl_Spratt ,

Please try:

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

That should do the trick.

Cheers,

Mark

[Karl_Spratt]

Thanks Mark that worked a treat.. Cheers Karl