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!

Find more posts tagged with

Accepted answers

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)

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.