Hi, having issues combining two different IF statements for contracts:
IF(Phase=“ 
Lead”,“ 
”)
IF(DATETIME_DIFF(TODAY(),{Last Contact},‘days’) >= 7, “ ”)
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 ( ).
Every time I use the (AND) function, following the example here, it doesn’t work.
Is it because the Phase field is a function?
Post your latest attempt so we can dissect what’s wrong about it.
Thanks Kamille.
IF(AND({Phase} = “ Lead”, DATETIME_DIFF(TODAY(),{Last Contact},‘days’) >= 7,“ ”)
Thanks Kamille.
IF(AND({Phase} = “ Lead”, DATETIME_DIFF(TODAY(),{Last Contact},‘days’) >= 7,“ ”)
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} = " Lead",
DATETIME_DIFF(
TODAY(),
{Last Contact},
'days'
) >= 7
),
""
)
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} = " Lead",
DATETIME_DIFF(
TODAY(),
{Last Contact},
'days'
) >= 7
),
""
)
Wow this was driving me crazy for days. Thank you!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.