Hi there,
I have accomplished a few formulas through my airtable base but I have trouble with this one:
In a library, I want to return “not in stock” for items that are signed out and have not yet been returned.
In writing this would be:
If SignOutDate contains a value and ReturnDate contains no value, return “not in stock”, otherwise “available”
IF(
AND(
{SignOutDate}<>””,{ReturnDate}=BLANK()
),
”notinstock”,”available”
)
As I am new to the AND/IF business, I might have severe problems in here already? If not, could it be that the date fields are the problem, they are set as ISO?
Any help highly appreciated.
Best, Sisi