How to auto calculate dates
This works if the contract term is 3 years then End Date but it won't work if the contract term is another number. How do I make it auto calculate if the contract term is 1, 2, 3 or 5 years?
Thanks!
Wina
Best Answer
-
Hi, @WinaHath .
Rename the column "Contract Term [Years]" to use parentheses, "Contract Term (Years)".
In your original formula, replace "3" with
[Contract Term (Years)]@row
.Your updated formula will be
=DATE(YEAR([Effective Date]@row) + [Contract Term (Years)]@row, MONTH([Effective Date]@row), DAY([Effective Date]@row))
.
Answers
-
Hi, @WinaHath .
Rename the column "Contract Term [Years]" to use parentheses, "Contract Term (Years)".
In your original formula, replace "3" with
[Contract Term (Years)]@row
.Your updated formula will be
=DATE(YEAR([Effective Date]@row) + [Contract Term (Years)]@row, MONTH([Effective Date]@row), DAY([Effective Date]@row))
. -
THANK YOU SO MUCH!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!