I am "trying" to create a calculated field to concat fields based on multiselect fields. I can get my statement to work if there is just one criteria. but how do I/is it possible to get the and statement to work between 2 fields. I found some examples that are kind of looking like what I want, but w...

I'm trying to pull the text from descriptive text fields into a calculated field that starts with an if statement, but I can't get the text to show I can only get it if its a text field. Any suggestions on pulling descriptive text from those fields ? Below is the if statement I started with. IF({DE:...

Thank you this was exactly what I needed!

I've managed to get it to search for the task name but I can't get the planned completion date part to work. This is the ugly code I was trying but it gives and error for planned completion dateAny help is welcome. EXISTS:A:$$EXISTSMOD=CIContainsEXISTS:A:$$OBJCODE=TASKEXISTS:A:name=Send campaign for...