Formula to store progress

[Jose_C]

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

[Kamille_Parks · Accepted solution]

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?

[Jose_C]

Many thanks! I solved with your help!!