Pull in Status name/description, not the Key (3 character code), for a calculated field. | Community
Skip to main content
J
JohnMi
Level 3
April 22, 2024
Solved

Pull in Status name/description, not the Key (3 character code), for a calculated field.

  • April 22, 2024
  • 1 reply
  • 436 views

Hi,

I have a Calculated field that tracks the status changes of task. The issue is {status} pulls in the Key (the 3 character code) and we want the status name such as "In Progress", as opposed to "INP". Is there a status name field, or would I need to create some If statements to change the values?

 

Thanks!

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 lgaertner

Hello John,

 

although you can fetch an object name for a field, which stores an ID using a syntax like

{<object>}.{name}

 e.g.

{project}.{name}

 

this does not work for the status.
The only workaround would be using a nested IF statement like this:

IF(Status="INP","In Progress",IF(Status="PLN","Planning",IF(Status="CPL","Completed",Status)))

If adding new statuses to your system would mean, that you need to adjust the statement.

 

 

Regards

Lars

 

1 reply

lgaertner
lgaertnerAccepted solution
Level 9
April 22, 2024

Hello John,

 

although you can fetch an object name for a field, which stores an ID using a syntax like

{<object>}.{name}

 e.g.

{project}.{name}

 

this does not work for the status.
The only workaround would be using a nested IF statement like this:

IF(Status="INP","In Progress",IF(Status="PLN","Planning",IF(Status="CPL","Completed",Status)))

If adding new statuses to your system would mean, that you need to adjust the statement.

 

 

Regards

Lars

 

Terms & ConditionsAccessibility statement

Loading footer...