Skip to main content

Basic Issue with Case Formula

  • January 30, 2020
  • 1 reply
  • 13 views
K

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

    This topic has been closed for replies.

    1 reply

    JonathanBowen
    Forum|alt.badge.img+18

    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

    Terms & ConditionsAccessibility statement