Populate date based on two other date columns
I have a Planned Finish and a GTG Date in my sheet. I created a new date column "Replanned Finish" and I would like the date to auto-populate with the Planned Finish unless there is a GTG Date. If there is a GTG Date I would like that date to populate.
Any ideas how to build a formula to do this? I looked and I can't use a Workflow.
Thank you!!
Best Answers
-
@Alethea Pollack You can use an if statement to check if the GTG date is blank using the ISBLANK() function, if the GTG is blank, the pull in that date, otherwise, pull in the Planned Finish date.
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
Thank you! In case anyone ever needs to do something similar here is the formula I used:
=IF(NOT(ISBLANK([GTG Date]@row)), [GTG Date]@row, [Planned Finish]@row)
Answers
-
@Alethea Pollack You can use an if statement to check if the GTG date is blank using the ISBLANK() function, if the GTG is blank, the pull in that date, otherwise, pull in the Planned Finish date.
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
Thank you! In case anyone ever needs to do something similar here is the formula I used:
=IF(NOT(ISBLANK([GTG Date]@row)), [GTG Date]@row, [Planned Finish]@row)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!