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
-
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)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
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)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Wow! I didn't even know about ISDATE. This is great and the formula works perfectly. Thank you!
-
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
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!