Help

Basic Issue with Case Formula

628 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Kenny_Hunt
4 - Data Explorer
4 - Data Explorer

Hi,

Basic issue but cant find it anywhere. Currently in the CRM template there is logic to make a record overdue if the last catchup date is over 60 days.

IF(DATETIME_DIFF(TODAY(),{Last Catchup},‘days’)>60,“Overdue”)

Thats great, but I would like to express different logic based on the Tag. i.e. if the tag is ‘work’ I would need to email or call every month, but if the person is family I would want to see them face to face 60 days.

It seems like simple logic but I cant figure out the syntax, any help is appreciated.

Thanks
Kenny

1 Reply 1

Hi @Kenny_Hunt - you could use a SWITCH formula here, something like:

SWITCH(
{Tag},
'Work', IF(DATETIME_DIFF(TODAY(), {Last Catchup}, 'days') > 30, 'Overdue'),
'Family', IF(DATETIME_DIFF(TODAY(), {Last Catchup}, 'days') > 60, 'Overdue')
) 

JB