Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Combining IF AND statements (one is a function)

Topic Labels: Formulas
Solved
Jump to Solution
1687 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Grace822
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

Grace822
5 - Automation Enthusiast
5 - Automation Enthusiast

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:"
)
Grace822
5 - Automation Enthusiast
5 - Automation Enthusiast

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