Hi Anthony, I know I have done this before, but can't find the exact right code... It is something like IF(LEN(STRING(MONTH(Entry Date),0))>1,STRING(MONTH(Entry Date),0),CONCAT("0",STRING(MONTH($$TODAY),0))) Jane Stavinoha

CONCAT("ABC",RIGHT(YEAR(Entry Date),2),"0",MONTH(Entry Date),"-",Reference Number) Jane Stavinoha

Does anyone know if it is possible to use a TypeAhead field in a calculated custom field? IF(ISBLANK({DE:Team Typeahead}),{DE:Project_Requestor Home Team},{DE:Team Typeahead}) Jane Stavinoha

Thanks Melinda...no joy :-( Jane Stavinoha Federal National Mortgage Association (Fannie Mae)

Jane Stavinoha Federal National Mortgage Association (Fannie Mae)

One suggestion from a learned friend, still not working... IF(!ISBLANK({DE:Project_Requestor}),{DE:Project_Requestor},IF(!ISBLANK({DE:Requestor TypeAhead.Name}),{DE:Requestor TypeAhead.Name},"No Requestor")) Jane Stavinoha Federal National Mortgage Association (Fannie Mae)

Hello! I know I have done this before but for some reason not working now... I have a Type Ahead field on the Project Object, with the purpose of overwriting any data copied from original request for the field Primary Contact. Normally, if Primary Contact exists, then both Primary Contact NAME and P...

Hi Narayan! Going a bit back in time here...but can I use this text method on a Request-based report? Maybe there is something wrong with ability to use listmethod across objects? displayname=Active Milestonelistdelimiter=‍listmethod=nested(tasks).liststextmode=truetype=iteratevalueexpression=TR...