Date Formula Help
I need a formula that will count the day that a row is "Open" but stop counting the days once its "Closed" both instances need to display the count.
Here is a formula I was trying to use. Thanks
=IF([Date Closed]@row > 0, ([Date Closed]@row - [Date Opened]@row), TODAY() - [Date Opened]@row)
Best Answer
-
How about rather than using the logic for date closed being today or before today, we just use the fact there is a date closed.
=IF([Date Closed]@row <> "", [Date Closed]@row - [Date Open]@row, TODAY() - [Date Open]@row)
If the [Date Closed] is populated the calculation is [Date Closed]-[Date Open]
If there is no [Date Closed] then the calculation is TODAY() - [Date Open]@row
Would that work for you?
Answers
-
Would this work for you?
=IF([Date Closed]@row <= TODAY(), [Date Closed]@row - [Date Open]@row, TODAY() - [Date Open]@row)
-
its not displaying the days if closed isnt filled in. I still need it to show the days if its not closed but stop counting if it is closed and still show the days. does that make sense?
-
How about rather than using the logic for date closed being today or before today, we just use the fact there is a date closed.
=IF([Date Closed]@row <> "", [Date Closed]@row - [Date Open]@row, TODAY() - [Date Open]@row)
If the [Date Closed] is populated the calculation is [Date Closed]-[Date Open]
If there is no [Date Closed] then the calculation is TODAY() - [Date Open]@row
Would that work for you?
-
KPH This looks correct as long as the days stop calculating once closed which looks like they should.
-
Yes, If the [Date Closed] is populated the calculation is [Date Closed]-[Date Open]
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives