I am trying to set up a search with formula fields that return a different date value depending on the record type. I am VERY new to this...
For example, I will have one field where if the 'type' is set to A, B, C, D, E or F, the field will calculate the record date - 30 days.
Then another field where if 'type' is set to G, H, I, J, K or L the field will calculate the record date - 70 days.
I can get this working when I use the text values of the types but I have too many options for this and therefore too many characters for the formula field. Besides which, I would prefer to use internal ID's for the List/Record values as it is a neater solution.
I cannot seem to get this to work though.
Here is a snippet of my formula:
CASE WHEN {custrecordevent_type_2.id}='1' THEN {custrecordevent_date}-70 ENDI don't get an error message with the above, I just get NOTHING.A formula I have that is working is:CASE WHEN {custrecordevent_type_2}='Briefing Session' THEN {custrecordevent_date}-70Am I doing something wrong?? I feel like I can't be too far off as I have followed the help documentation around referencing ID's in formula (the whole one line of it....) and it seems like it should be ridiculously straight forward!!Hope this post isn't too convoluted - been staring at the computer too long :h_a_w: