Reference two cells to populate a third cell

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!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!