Skip to main content

Hello! getting lost in the sauce of nested IF formulas and looking for help.

I have a CRM in airtable that I'd like for a formula to return one of two formulas based on a single select status for that deal.

If the deal is open (any one of 7/10 statuses in the single select), I'd like for it to show the deals age based on today's date

 

 

DATETIME_DIFF( TODAY(),{Deal Created}, 'weeks')

 

 

If the deal is closed (any of 3/10 statuses in the single select) I'd like for it to show the age of the deal when it was closed:

 

 

DATETIME_DIFF({Date Closed or Lost},{Deal Created}, 'weeks')

 

 

Thanks for your help!

Could you give this a shot?

IF(

OR(

{Status} = "Closed/Lost Option 1",

{Status} = "Closed/Lost Option 2",

{Status} = "Closed/Lost Option 3"

),

DATETIME_DIFF({Date Closed or Lost},{Deal Created}, 'weeks'),

DATETIME_DIFF( TODAY(),{Deal Created}, 'weeks')

)

 

Reply


Terms & Conditions