How do I update the Status from a date field column of another sheet

bobbyf

One sheet (sheet 1) a specific row contains a column/date field and I want to update a specific rows status field on another sheet (sheet 2) to status of Complete if a date is present in the source date field from Sheet 1.

Mike TV

@bobbyf

Is there a point of reference that exists on both sheets which you can use to help find which specific row the date is on that you want to look at? If so, you need to add a column to sheet 2 which INDEX MATCHES and references that data to bring in the date field into sheet 2. Then you can write a simple =IF(ISDATE( formula to change the other column on sheet 2 to "Complete" if a date is present.