Hi! I want to add a formula that does the following:
If “created on” is within the last week OR “revisit on” is today, then TRUE (i.e. check a box or write true in a text field).
“Created on” and “revisit on” are both date fields.
This way, I can bet...
Thank you so much, this formula works – thanks also for telling me where I went wrong.
Do you know why the second record doesn’t return “true”? Since it should return “true” if it was created within the last week or if the “Revisit on” date is today:...
Thank you for your reply!
Somehow I’m still getting the formatting wrong - Airtable won’t accept this formula:
IF(OR(DATETIME_DIFF({CREATED_TIME}, TODAY, ‘days’) < 7, ({Revisit on}=TODAY)), ‘True’, ‘False’)
Here’s what I tried, but the formula isn’t formatted correctly:
IF(DATETIME_DIFF({CREATED_TIME}, TODAY, ‘days’) < 7 OR({Revisit on}=TODAY), “True”, “False”)
