Help

Formula Help - Project Completed On-Time, or Late [Solved]

1307 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Blake_Frimoth
4 - Data Explorer
4 - Data Explorer

Hi There,

I’m trying to create a formula for a column that will populate the text, “Complete - On-time” if the entry in the ‘Completion Date’ field is equal to or sooner than the ‘Due Date’ field. The formula will also populate the text, “Complete - Late” if the ‘Completion Date’ Field is later than the ‘Due Date’ Field.

image

Does anyone know what this formula would look like? Thanks in advance.

1 Reply 1
Blake_Frimoth
4 - Data Explorer
4 - Data Explorer

Nevermind, figured it out!

IF({Completion Date}>={Due Date},“Completed - On Time”, “Completed - Late”)