Count days how many days have past and once completed stop counting.
I am trying to figure out how to counts the days from "doc date" to today, but when the completion date is entered it stops counting and remains there. Here is what I have so far..
=IF([Completion Date]@row<>, TODAY()-[Document Date]@row, [Completion Date]@row-[Document Date]@row)
I am getting error #UNPARSEAB with this formula.
Thanks for the help!
Answers
-
You almost had it.
You need a value for Completion Date not to equal. I have put in "" which means it isn't empty.
I have also switched around the data to return.
If it is true (i.e. there is a completion date) the value will be days between Completion Date and Doc Date.
If false (i.e. there is no completion date) the value is the days between TODAY and Doc Date.
=IF([Completion Date]@row <> "", [Completion Date]@row - [Document Date]@row, TODAY() - [Document Date]@row)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!