# Reference two cells to populate a third cell

Options

Hi!

I have 3 cells in my Smartsheet, Date Requested, Due Date Requested and Due Date, all are a date format. Date Requested will populate automatically when another field (requested by is populated). Here's what I want to happen in the Due date field...

*If Due Date Requested is populated with a date, enter that date in the Due Date field

If Due Date Requested is blank, enter the Date Requested plus 30 days.

I am close to getting it, but something isn't working. Here's what I've tried:

=IF(NOT(ISBLANK([Due Date Requested]1)), [Due Date Requested]1), IF(ISBLANK([Due Date Requested]1)), [Date Requested]1+(30)

=IF(NOT(ISBLANK([Due Date Requested]1)), [Due Date Requested]1), IF(ISBLANK([Due Date Requested]1)), ([Date Requested]1+(30))

=IF(NOT(ISBLANK([Due Date Requested]1)), [Due Date Requested]1), IF(ISBLANK([Due Date Requested]1)), ([Date Requested]1+(30)))

Any help is appreciated.

Thank you!

• Options

Wow! I didn't even know about ISDATE. This is great and the formula works perfectly. Thank you!

• ✭✭✭✭✭✭
edited 02/13/20
Options

You are quite welcome. Glad it's working for you!

Here's a helpful sheet for formulas. It's not quite all of them, but it does give some basic examples that you can use to build more complex ones.

https://app.smartsheet.com/sheets/3Jj5MhR9fhVXC9cpVh3xVvcrHq2xRvrjcQF47hM1?view=grid

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!