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
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!