Number of days open
Can anyone tell me why im getting an incorrect argument set error with the formula below? Im trying to determine how many days a case has remained open since it has been assigned, but want to ensure i dont include those that have a disposition date entered
=IF(AND(ISDATE([Date Assigned]@row,ISBLANK([Disposition Date]@row)),TODAY() - [Date Assigned]@row, "")
Answers
-
Not sure if this will work for you but I would use the disposition date as my primary if statement. Here is an example hopefully it works ok for you just make sure the columns are set to Date format that can cause issues sometimes.
=IF([Disposition Date]@row = "", TODAY() - [Date assigned]@row, "Has Disposition Date")
-
Thank you Cory! with a few minor adjustments it worked perfectly :)
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives