# Comparing Dates

edited 06/14/23

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!

Tags:

• ✭✭✭✭✭✭

Try this formula

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

I hope this works.

Best Regards

Smartsheet CoE, Ignatiuz Software, Exton, PA

• ✭✭✭✭✭✭

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

Ipshita Mukherjee

• ✭✭✭✭✭✭

Hi @dmartsheetuser

I hope you're well and safe!

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!