Fill a column with a value based on the date of another column

GGSF

I have a "Status" column where users can select "Completed" from a drop down list. There is another column called "Due Date" that already has value plus a third column called "Timeliness".

What I would like is...when a user select Completed on the Status column, it will enter "Late" in the "Timeliness" column if the current date (e.g. when users marked it as completed) is later than the date set on the "Due Date" column.

Mike TV

@GGSF

After creating the Date Completed column, set up an Automation as follows:

Timeliness column formula:

=IF(AND(Status@row = "Completed", [Date Completed]@row <= [Due Date]@row), "On Time", "Late")

Mike TV

@GGSF

After creating the Date Completed column, set up an Automation as follows:

Timeliness column formula:

=IF(AND(Status@row = "Completed", [Date Completed]@row <= [Due Date]@row), "On Time", "Late")

GGSF

Thanks!! Got it to work exactly!!