Calculated Task Columns | Community
Skip to main content
J
JoshJa
New Participant
October 20, 2022
Solved

Calculated Task Columns

  • October 20, 2022
  • 1 reply
  • 664 views

I have been working on some Text mode inputs to find the difference between the "Total # of deliverables" & "total # of deliverables completed". {Green Square in image}

 

My goal is to report on the project status for the "# of remaining deliverables" {Yellow Square in Image}

 

 

I have found the article with the function I am trying to include what am i missing from a text mode perspective? 

ARTICLE

    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 JoshJa

    Here is the solve that we discovered internally with my team.

     

    displayname=# of Deliverables Remaining
    textmode=true
    valueexpression=SUB({DE:Total # of Deliverables}, {DE:# of Deliverables Completed})
    valueformat=HTML

     

    CALLOUT:

    DE: for custom column names

    Type fields exactly as shown 

    SUB = Difference between fields

    1 reply

    J
    JoshJaAuthorAccepted solution
    New Participant
    October 24, 2022

    Here is the solve that we discovered internally with my team.

     

    displayname=# of Deliverables Remaining
    textmode=true
    valueexpression=SUB({DE:Total # of Deliverables}, {DE:# of Deliverables Completed})
    valueformat=HTML

     

    CALLOUT:

    DE: for custom column names

    Type fields exactly as shown 

    SUB = Difference between fields

    Terms & ConditionsAccessibility statement

    Loading footer...