Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Date formula
jovan12971
✭✭
Hi
I'm working a construction project, and need to use a formula (or another method). To have a cell generate a remainder duartion period, based on a set completion date and duration against the current date.
I look forward to any suggestions.
Thanks
Comments
-
Assuming your end date is in a column called "Date" in row 1...
Formula:
=Today()-[Date]1
This discussion has been closed.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.6K Get Help
- 472 Global Discussions
- 200 Use Cases
- 511 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 81 Community Job Board
- 520 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives