Reference two cells to populate a third cell

Stephanie Stewart

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!

Jeff Reisman

Try this one. You only need one IF. Using ISDATE is cleaner than IF NOT ISBLANK. I prefer using @row instead of row numbers as well, it's easier to replicate from row to row.

=IF(ISDATE([Due Date Requested]@row)), [Due Date Requested]@row, [Date Requested]@row + 30)

Jeff Reisman

Try this one. You only need one IF. Using ISDATE is cleaner than IF NOT ISBLANK. I prefer using @row instead of row numbers as well, it's easier to replicate from row to row.

=IF(ISDATE([Due Date Requested]@row)), [Due Date Requested]@row, [Date Requested]@row + 30)

Stephanie Stewart

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

Jeff Reisman

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