Average days open
=AVERAGEIF([Closing Date]:[Closing Date], "", [Days ago]:[Days ago])
Im trying to average the amount of days a case is open by selecting the rows that have a blank closing day which means that they still open. but i keep getting #INVALID DATA TYPE
thank you in advance
Best Answer
-
Hi @Luis Orosco
I would suggest adding in a second criteria where a different column is not blank so that this isn't including the 10 blank rows at the bottom of the sheet.
Try something like this:
=AVG(COLLECT([Days ago]:[Days ago], [Closing Date]:[Closing Date], "", [Primary Column]:[Primary Column], <> ""))
Then, what column type are you putting the formula into? Make sure it's a Text/Number column.
Let me know if this works!
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Answers
-
Hi @Luis Orosco
I would suggest adding in a second criteria where a different column is not blank so that this isn't including the 10 blank rows at the bottom of the sheet.
Try something like this:
=AVG(COLLECT([Days ago]:[Days ago], [Closing Date]:[Closing Date], "", [Primary Column]:[Primary Column], <> ""))
Then, what column type are you putting the formula into? Make sure it's a Text/Number column.
Let me know if this works!
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
Thank you!! that worked very well! I'm very new to smartsheet. I really love the support
-
No problem at all, I'm glad I could help! 🙂
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 150 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 500 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!