Help

Re: Formula Help Please

851 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Mike_Coghill
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi There,

I have custom built a CRM and have it set up to flag an account if we havent talked to them in a certain time period( 30 Days) as we grow though we are finding that this should probably be different by customer.
So i was going to add to each account an interaction timeframe ie 30 Days, 45 Days etc and then want to flag based on the timeframe in that account.
Anyone know how to make this formula? I can prob figure out but you guys are so much better at it :slightly_smiling_face:

Thanks for the help in advance

2 Replies 2

It depends on your base structure. How do you log the last time talked? Anyway, you have DATETIME_DIFF to calculate time between 2 dates.

Jeri_Vespoli
6 - Interface Innovator
6 - Interface Innovator

If(DATETIME_DIFF (TODAY(),{Date Last Contacted},‘days’)>{Interaction Timeframe}, ‘Contact!’,’ ')