Calculated field that displays text | Community
Skip to main content
P
Pat_Paterson
Level 4
October 25, 2022
Solved

Calculated field that displays text

  • October 25, 2022
  • 1 reply
  • 1017 views

Hi All, 

 

I'm trying to create a calculated field on a document form that displays the following text when the number present falls into one of the following 3 ranges:

 

< 0 = "Late"

=0 = "On Time"

>0 = "Early"

The field will pull the numerical data from another custom field on the form.

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 GrahamJarrett

similar concept i did for a client used the following formula...

 

IF({status}="PLD","1. Trending Early",IF({actualCompletionDate} = "",IF(WEEKDAYDIFF({DE:Final Approved Deliverable Due Date}, {projectedCompletionDate})<0,"1. Trending Early",IF(WEEKDAYDIFF({DE:Final Approved Deliverable Due Date}, {projectedCompletionDate})<0,"3. Trending Behind","5. Trending Late")),IF(WEEKDAYDIFF({DE:Final Approved Deliverable Due Date}, {actualCompletionDate})<0,"2. Early",IF(WEEKDAYDIFF({plannedCompletionDate}, {actualCompletionDate}) <0,"4. Behind","6. Late"))))

1 reply

GrahamJarrett
GrahamJarrettAccepted solution
Level 4
October 26, 2022

similar concept i did for a client used the following formula...

 

IF({status}="PLD","1. Trending Early",IF({actualCompletionDate} = "",IF(WEEKDAYDIFF({DE:Final Approved Deliverable Due Date}, {projectedCompletionDate})<0,"1. Trending Early",IF(WEEKDAYDIFF({DE:Final Approved Deliverable Due Date}, {projectedCompletionDate})<0,"3. Trending Behind","5. Trending Late")),IF(WEEKDAYDIFF({DE:Final Approved Deliverable Due Date}, {actualCompletionDate})<0,"2. Early",IF(WEEKDAYDIFF({plannedCompletionDate}, {actualCompletionDate}) <0,"4. Behind","6. Late"))))
    P
    Pat_PatersonAuthor
    Level 4
    October 26, 2022

    Thanks Jarrett!  Is your formula tied to a task/project status?  How would I go about tying it to a custom field?

    GrahamJarrett
    GrahamJarrett
    Level 4
    October 26, 2022

    you would replace the status in the { } with the custom field {DE:Custom Field Name}

     

    IF({DE:Custom Field Name} < 0,"Late",IF({DE: Custom Field Name} = 0, "On Time","Early"))

      Terms & ConditionsAccessibility statement

      Loading footer...