Counting formula just based on Status
Answers
-
Hello, I"m trying to come up with a formula that will start counting when status changes to "Overdue" and stop counting when status changes to "Complete" (or when date completed is not blank). Is this possible without referencing a date column?
Thanks for your help,
Julie
-
You'll need to reference a date if you plan to count the number of days the item has been "Overdue".
NETDAYS(
due_date, TODAY() ) will return the number of days that has elapsed since the item's due date.A date is not needed if you simply want to count the number of items that are "Overdue".
COUNTIF( Status:Status, Status@row="Overdue")
will return the number of items that have "Overdue" in the Status column. -
Toufong,
Thank you so much for responding so quickly. Can you tell me is it possible to modify the formula
NETDAYS(
due_date, TODAY() )to also stop counting when completion date is not blank?
thanks for your help.
-
I'm currently trying this formula, but am receiving INVALID DATA TYPE
=NETDAYS([Due Date]:[Due Date], TODAY())
The Due Date Column is a "Date" column. Anything obvious I'm missing? Thank you.
Help Article Resources
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
Check out the Formula Handbook template!