Hello Everyone,
New to Airtable and enjoying it so far. I couldn’t find help on this and I am guessing there’s a better way to do this. Appreciate your help in advance.
I want to followup in 10 days if a checkbox is checked, or 30 days if it isn’t. Here is an elaboration of the condition followed by the formula that gives an error:
If the checkbox {A} is checked, {B} < 10 days “Looks Good” else “Needs Check In!”. However, if the checkbox is not checked, {B} < 30 days “Looks Good” else “Needs Check In!”
Interesting… when I copied and pasted your formula into Airtable, it didn’t work.
But when I retyped it from scratch, it worked. I’ve seen this happen before — there might be an invisible character or a curly quote or an extra space or something that is throwing off Airtable.
As far as I can tell, the formula below (which now works for me in Airtable) is identical to your formula above. Maybe I’m missing something, and they’re actually different. Lol.
One change that I did make was that I removed the " =1" part because that wasn’t necessary. Also, if your field names are only one word, you don’t need the curly brackets {} around them, but I left those in for now.
Try copying and pasting this into Airtable and see if it works. Or try retyping it from scratch.
Hope this helps! If this solves this dilemma for you, could you please mark this comment as the solution to your question? This will help other people who have a similar question.