# Re: Combining IF AND statements (one is a function)

Solved
Jump to Solution
612 1
cancel
Showing results for
Search instead for
Did you mean:
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
18 - Pluto

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:"
)
``````
4 Replies 4
16 - Uranus

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

5 - Automation Enthusiast

Thanks Kamille.

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

18 - Pluto

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

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