Comparing Dates

dsmartsheetuser

Hi,

I have a Planned Date and Actual Date and Final Date column. I need formula where Final Date column, has Actual Date, but when Actual Date is blank Final Date should have Planned Date.

Planned Date | Actual Date |

Any help is much appreciated!

Thank you!

Amit Wadhwani

Hi @dsmartsheetuser

Try this formula

=IF(ISBLANK([Actual Date]@row), [Planned Date]@row, [Actual Date]@row)

I hope this works.

Ipshita

Hello @dsmartsheetuser

You will need to use a =IF(ISBLANK) formula in this case where if Actual Date is blank then the formula returns Planned Date. Try and let me know if this works.

Hope this helps,

Cheers!

Ipshita

Andrée Starå

Hi @dmartsheetuser

I hope you're well and safe!

To add to Amit's excellent advice/answer.

Here's another version of the formula. (I prefer this one because it's shorter)

=IF([Actual Date]@row = "", [Planned Date]@row, [Actual Date]@row)

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!