This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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!
