Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Combining IF AND statements (one is a function)

Topic Labels: Formulas
Solved
Jump to Solution
279 4
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi, having issues combining two different IF statements for contracts:

IF(Phase=“ :inbox_tray: Lead”,“ :bell: ”)
IF(DATETIME_DIFF(TODAY(),{Last Contact},‘days’) >= 7, “ :bell: ”)

They both work separately but want to be able to combine them so that IF a contract is in Lead phase AND the last contact date was 7or more days ago, then follow up ( :bell: ).

Every time I use the (AND) function, following the example here, it doesn’t work.

Is it because the Phase field is a function?

1 Solution

Accepted Solutions

It looks like you are missing a closing parenthesis for your AND. Try this. You will have to replace the emoji as they did not copy/paste for me.

IF(
    AND(
        {Phase} = ":inbox_tray: Lead", 
        DATETIME_DIFF(
            TODAY(),
            {Last Contact},
            'days'
        ) >= 7
    ),
    ":bell:"
)

See Solution in Thread

4 Replies 4

Post your latest attempt so we can dissect what’s wrong about it.

Thanks Kamille.

IF(AND({Phase} = “ :inbox_tray: Lead”, DATETIME_DIFF(TODAY(),{Last Contact},‘days’) >= 7,“ :bell: ”)

It looks like you are missing a closing parenthesis for your AND. Try this. You will have to replace the emoji as they did not copy/paste for me.

IF(
    AND(
        {Phase} = ":inbox_tray: Lead", 
        DATETIME_DIFF(
            TODAY(),
            {Last Contact},
            'days'
        ) >= 7
    ),
    ":bell:"
)

Wow this was driving me crazy for days. Thank you!!