Date Formulas
I am looking to set up a Date function.
I have multiple dates on a sheet, I need to set a column or multiple columns up with a formula to automatically calculate.
Example
1 column has a Start date (date column property)
I want another column to calculate 21 days ahead when that will bill, and so on for each 21 days..
Do I make the bill date column a Date property?
What is the formula I use, I have searched but can only find =Date2 =21 which doesn't work because I have multiple dates on a line I need the formula to grab a specific column and count forward.
Thank you for your help and suggestions in advance
Michelle Lambert
Best Answer
-
Yes, make the Bill date column a Date-type column. Then you can just use
=[Contract Start Date]@row + 21
Or if the Day Value may change from row to row, you can use
=[Contract Start Date]@row + [Day Value]@row
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
-
Are you able to provide a screenshot for reference?
-
I am looking to add 21 days from the contract Start Date to the first Cycle date column.
-
Yes, make the Bill date column a Date-type column. Then you can just use
=[Contract Start Date]@row + 21
Or if the Day Value may change from row to row, you can use
=[Contract Start Date]@row + [Day Value]@row
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
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 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!