Formula Fustration! completion status is not working properly

Platform discussions monday apps & integrations
,
1

I am using the following formula for a completion status column. It is returning “done late” for completion dates equal to or after the start date and before or equal to the end date. it should be returning them as done on time. What am I missing here? #frustrated

IF({Completion Date} = “”, “Working”, IF({Completion Date} < {Timeline#start}, “:white_check_mark: Done Early :white_check_mark:”, IF(AND({Completion Date} >= {Timeline#start}, {Completion Date} <= {Timeline#end}), “Done on Time :white_check_mark:”, IF({Completion Date} > {Timeline#end}, “Done Late :check_box_with_check:”, “”))))

The darn AI built this formula but it does not work.

2

@Cellblock-D

Try this:

IF({Completion Date} = "", 
  "Working", 
  IF({Completion Date} < {Timeline#Start}, 
    "Done Early", 
    IF(AND({Completion Date} >= {Timeline#Start}, {Completion Date} <= {Timeline#End}), 
      "Done on Time", 
      IF({Completion Date} > {Timeline#End}, 
        "Done Late", 
        ""
      )
    )
  )
)

The references to Timeline start and end must be capitalized, e.g., {Timeline#Start}.

Jim - The Monday Man

1 Like
3

HI Marty,

I think the start and end properties have to be uppercase and then it will work, here’s the whole formula simplied:

IF({Completion date} = “”, “Working”, IF({Completion date} < {Timeline#Start}, “Done Early”, IF(AND({Completion date} >= {Timeline#Start}, {Completion date} <= {Timeline#End}), “Done on Time”, IF({Completion date} > {Timeline#End}, “Done Late”, “”))))

4

Awesome I’ll give it a go this morning!

Respectfully,
Marty Bartram
Email: martybartram@me.com
Mobile: 910-824-0024
Office: 910-396-0295
IG: @martybartram

5

Thank you both! Worked great!