Get date progression with formula

Platform discussions
,
1

Hi
I’m trying to calculate the current progress of a task based on a timeline column.
But when that timeline is not defined i’m getting “one parameter is not valid” regardless the conditions.
This is my formula:

IF({Deadline#Start} <> “”,
ROUND(IF(WORKDAYS({Deadline#End}, today())=0,
WORKDAYS({Deadline#End}, {Deadline#Start}),
WORKDAYS( today(), {Deadline#Start})) / WORKDAYS({Deadline#End}, {Deadline#Start})*100,2),0)

Is there any way to override when the value of Deadline is not defined?

1 Like
2

Hey Fernando,

Can you please share a screenshot of your set up (including the column involved in the formula)? I am trying to replicate this on my end and running into an error, so want to confirm I have a correct understanding of the column structure - thanks :slight_smile:

3

image
image394×664 23.9 KB

image

You can see the 5th row in the image, where the timeline field is not defines, the formula produces the error “one parameter is not valid”.
I’m trying to get a 0 in that case

4

@BiancaT were you able to see the reply?

5

So sorry for the delay fernando! I have our formula team working on this at the moment. I will update you as soon as I hear back :pray:

8

Hey @fdmenendez

Thanks for your patience!

Let me know if this helps:


ROUND(IF(WORKDAYS({Deadline#End}, TODAY())=0,
WORKDAYS({Deadline#End}, {Deadline#Start}),
MULTIPLY(IF({Deadline}<>"",DIVIDE(WORKDAYS(TODAY(), {Deadline#Start}), WORKDAYS({Deadline#End}, {Deadline#Start})),0),100)),2)