
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 28, 2022 11:55 AM
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?
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 28, 2022 05:19 PM
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:"
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 28, 2022 02:20 PM
Post your latest attempt so we can dissect what’s wrong about it.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 28, 2022 04:38 PM
Thanks Kamille.
IF(AND({Phase} = “ :inbox_tray: Lead”, DATETIME_DIFF(TODAY(),{Last Contact},‘days’) >= 7,“ :bell: ”)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 28, 2022 05:19 PM
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:"
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 28, 2022 07:05 PM
Wow this was driving me crazy for days. Thank you!!
