Help with IFIN calculated field for tracking status changes

Question

Hello,I am trying to create a custom field that will track when a project moves to one of two statuses, Current (CUR) and Production (PRD). I was using a combo of ISBLANK and IFIN and below is what I have, but it not giving me any results: IF(ISBLANK({DE:Production Date Went Current}),IFIN({status},"CUR","PRD",$$NOW,""),{DE:Production Date Went Current}) Does anyone know why this is not giving me any results?

NicholeVargas · Accepted Answer

@kristinawa1 Are you wanting the track the date in which a project moved to Current AND the date in which a project moved to Production? Or do you want this set up as an OR statement where the custom field will track the first of the two? This blog offers an example to show how to track status change dates in a calculated custom field - it uses the expression ISBLANK vs IFIN.

If you want the latter option, here is what it would look like:

IF(ISBLANK({DE:Production Date Went Current}),IF({status}="CUR"||{status}="PRD",$$TODAY,{DE:Production Date Went Current}),{DE:Production Date Went Current})

Sign up

Login with SSO

Login to the community

Login with SSO