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
May 13, 2017 10:36 AM
Any time I have a field that is a formula then any IF function that bases it’s action off the number returned by the first formula is an error.
I’ve tried adding the value tag around it… still not working.
It would be something like, IF ({number column}<1, ‘0’, ‘1’) which will work, but If that formula is recorded under ‘{column 2}’ and I then say, IF’{column 2} = ‘1’, ‘yes’, ‘no’) will always be an error.
How can I fix this??
May 13, 2017 01:11 PM
Watch your use of quotation marks, as I suspect you’re attempting to compare string and numeric values. For instance, your example works fine when stated this way: