Dear community,
can two unrelated conditions live in the same formula? Do they need to connected by the same first argument?
I want "Sample Availability to read “Shop only” when there is no value in “SignOutIcon”
In writing it would be:
If SignOutI...
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 SignOutDa...
Dear Kamille,
thank you very much for your help. It all makes very much sense to me - only airtable replies that it is an invalid formula when I paste it in. I have already tried removing blanks and replacing quotation marks but without success. Any ...
Kamille_Parks:
IF(
NOT({SignOutIcon})
"Shop only",
IF(
AND({SignOutIcon}, {SignOutDate}, NOT({ReturnDate})),
"not in stock",
"available"
)
)
Thank you Kuovonne, this will definitely help me the next time I am try...
Thank you so much, kuovonne.
This worked perfectly and ended my two days of head-scratching.
It´s the first time I ever posted anything in a forum in my life - how lovely, it what such a success.
You just made my day. Thanks so much!
