Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Formula to store progress

Topic Labels: Formulas
Solved
Jump to Solution
206 2
cancel
Showing results for 
Search instead for 
Did you mean: 

I have a formula to store progress on a time period.

CONCATENATE(ROUND({closed tasks}/{Total tasks}*100,0),“%”)
There is another field called “deadline”
What i am trying to solve is to avoid an update of the formula after deadline date, in order to “snapshot” how was the progresssion until deadline date.

I tried with an IF NOW() > deadline but then the field is blank and nothing is saved.

Some idea?

Many thanks in advance

1 Solution

Accepted Solutions

Are Closed Tasks and Total Tasks Rollup/Count fields for linked records? Are you trying to say "only count the tasks that were completed before the deadline? If you’re using linked records then you could do that pretty easily with conditional rollups/counts.

Also you are concatenating a percent sign onto a number, resulting in a string. Is that what you want, or would you prefer the result to be a number that is formatted as a percentage?

See Solution in Thread

2 Replies 2

Are Closed Tasks and Total Tasks Rollup/Count fields for linked records? Are you trying to say "only count the tasks that were completed before the deadline? If you’re using linked records then you could do that pretty easily with conditional rollups/counts.

Also you are concatenating a percent sign onto a number, resulting in a string. Is that what you want, or would you prefer the result to be a number that is formatted as a percentage?

Many thanks! I solved with your help!!