Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!
SOLVED

Calculated Task Columns

Avatar

Level 2

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}

 

Screen Shot 2022-10-20 at 3.37.23 PM.png

 

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

ARTICLE

Screen Shot 2022-10-20 at 3.46.25 PM.png

1 Accepted Solution

Avatar

Correct answer by
Level 2

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

View solution in original post

1 Reply

Avatar

Correct answer by
Level 2

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