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
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!