Help with IFIN calculated field for tracking status changes | Community
Skip to main content
K
KristinaWa1
New Participant
February 13, 2024
Solved

Help with IFIN calculated field for tracking status changes

  • February 13, 2024
  • 1 reply
  • 779 views

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?
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by NicholeVargas

@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})

 

1 reply

N
NicholeVargasAccepted solution
Employee
February 13, 2024

@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})

 

K
KristinaWa1Author
New Participant
February 16, 2024

Thank you Nichole, yes I wanted the date when the project changed into either one of those statuses, you calculation worked.

Terms & ConditionsAccessibility statement

Loading footer...