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.
TODAY() Formula Not Working
I am in the process of creating a sheet that shows the duration each of my machines has been on site. I am trying to us the TODAY() formula to reference the current date, but it is not working. Essentially, I am trying to use the 'Date Delivered to Site' column that I've created, and have the 'Duration on Site' column calculate how many days the machine has been on site. Can someone please help, because I am LOSING MY MIND.
Thanks in advance!
Comments
-
Try using this formula. Replace the "#" with the corresponding row number.
=TODAY() - [Date Delivered on Site]#
This discussion has been closed.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives