Summary Field that Averages Field Entries that are Less than Zero
I have a calculated field for the time over or under a deadline date. I want to create a summary field that summarizes the number of days overdue for projects completed after their deadlines.
Right now I'm trying =averageif([field name]:[field name],<0,[field name]:[field name])
I get an "Invalid Operation" error when I do this. Can someone give me some advice on a better approach?
Thanks!
Answers
-
Hello @megbarclayllx
What are the column properties for "Field Name"?
Are you using another function/helper column for the number of days overdue?
-
It's a text/number field. It's a formula that's calculating the number of days overdue.
-
Also hello and thank you!!
-
-
Sure thing. Here it is:
-
Do you have that error present in any of the cells within the column being referenced? If so, you will need to wrap your existing formula in an IFERROR statement.
=IFERROR(original_formula, "")
-
Hi there! thanks for that tip!
I'm getting the error when I try to program the sheet summary filed. Thank you!
-
Right. But of that error is present in even a single cell that is being referenced, it will pull through.
It is possible your AVERAGEIF is just fine, but the formula you are using to populate the referenced colum is throwing an error somewhere which in turn is causing the issue in your sheet summary field.
-
I see. thanks. I'll try it!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!