Formula Help Please


#1

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 :slight_smile:

Thanks for the help in advance


#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.


#3

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