Populate date based on two other date columns

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!!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!