Joshi_Gottlieb - profile

Joshi_Gottlieb · May 25, 2020

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...

Joshi_Gottlieb · May 25, 2020

This works, thank you sooo much!

Joshi_Gottlieb · May 25, 2020

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:...

Joshi_Gottlieb · May 25, 2020

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’)

Joshi_Gottlieb · May 25, 2020

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”)

User Statistics

User Activity

IF Formula with dates and "or" clause

Re: IF Formula with dates and "or" clause

Re: IF Formula with dates and "or" clause

Re: IF Formula with dates and "or" clause

Re: IF Formula with dates and "or" clause