Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Feb 17, 2020 12:39 PM
I want to know what is the proper formula to use this…
IF(Checkincount= 99, TRUE(), FALSE())
I’d like to have an or option meaning
IF(Checkincount= 99, TRUE(), FALSE()), OR IF(Checkincount= 199, TRUE(), FALSE()), OR IF(Checkincount= 299, TRUE(), FALSE())
I can’t seem to find the right formula to use the OR
Meaning, I want it to show if Checkincount is 99 or 199 or 299 etc…
Hope that makes sense.
Thanks
Feb 17, 2020 05:27 PM
If what you really want is for this field to show “True”, or 1
only when {Checkincount}
is equal to exactly 99, 199, 299, etc, and show “False”, or 0
otherwise, you could probably do that a little more efficiently like this:
IF(
RIGHT(
{Checkincount}&"",
2
) = "99",
TRUE(),
FALSE()
)