Populate date based on two other date columns

Alethea Pollack

I have a Planned Finish and a GTG Date in my sheet. I created a new date column "Replanned Finish" and I would like the date to auto-populate with the Planned Finish unless there is a GTG Date. If there is a GTG Date I would like that date to populate.

Any ideas how to build a formula to do this? I looked and I can't use a Workflow.

Thank you!!

Darren Mullen

@Alethea Pollack You can use an if statement to check if the GTG date is blank using the ISBLANK() function, if the GTG is blank, the pull in that date, otherwise, pull in the Planned Finish date.

Alethea Pollack

Thank you! In case anyone ever needs to do something similar here is the formula I used:

=IF(NOT(ISBLANK([GTG Date]@row)), [GTG Date]@row, [Planned Finish]@row)

Darren Mullen

@Alethea Pollack You can use an if statement to check if the GTG date is blank using the ISBLANK() function, if the GTG is blank, the pull in that date, otherwise, pull in the Planned Finish date.

Alethea Pollack

Thank you! In case anyone ever needs to do something similar here is the formula I used:

=IF(NOT(ISBLANK([GTG Date]@row)), [GTG Date]@row, [Planned Finish]@row)