Sheet Summary - Countif - #Invalid Operation
JDen
✭✭✭✭
Hi all,
Ok I am going crazy, hope someone can tell me where I am going wrong:
- I keep getting #Invalid Operation on a sheet summary Countif Formual based column "Days to Obtain PO Range" - This column had a formula in it
- I have a second column called "Test" - this column has the same formula as the above
Why am I getting a result for the TEST column and getting a #Invalid Operation for the "Days to Obtain PO Range" column? The only difference is the longer name of the first column.
Tags:
Best Answer
-
Do you have that error anywhere within the range you are evaluating?
Answers
-
Do you have that error anywhere within the range you are evaluating?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!