Formula to count number of Days and not counting Status
Hi everyone. I hope everyone is doing well. I was wondering if I could please get some help. I have a tracker named eAPP, I am trying to count the number of Days since Assigned for 0 to -12 days but exclude in the count if the Current Status is "Completed". I have tried so many formulas, but nothing is working. Thanks. Brian
Best Answers
-
Hi @Peppey
Apologies updated formula
If(Contains("Action Complete",[Current Status]@row),"",Today()-[Days since assigned]@row)
Thanks
Paul
-
Perfect thank you so much
Answers
-
Hi @Peppey
Without seeing sheet specifics I would use something like this:
If(Status@row = "Completed","",Today()-Assigned@row)
Assumption that status column contains where the completed is updated and the assigned column is where the date would be and that column is formatted as a date.
Hope that helps
Thanks
Paul
-
Hello @Peppey - I guessed at your exact column names:
=IF([Current Status]@row = "Complete", "", TODAY() - [Assigned Date]@row)
I hope that is helpful!
-
Thank you both sir! I apologize I should have been more specific. There is an autocalculate column int he tracker and need the count the autocalculate days showing the numbers. For example, in the autocalculate column in the tracker there are number such as 0, -12, -28, etc. I need to count the number of 0 to -12 from this column (named Days since assigned).
-
Could you please post a snip of that column? It would help to understand the data a little better
-
Yes of course. See below
-
Hi @Peppey
Apologies updated formula
If(Contains("Action Complete",[Current Status]@row),"",Today()-[Days since assigned]@row)
Thanks
Paul
-
Perfect thank you so much
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.4K Get Help
- 447 Global Discussions
- 144 Industry Talk
- 479 Announcements
- 5.1K Ideas & Feature Requests
- 85 Brandfolder
- 151 Just for fun
- 72 Community Job Board
- 490 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 302 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!