Sheet Summary - Countif - #Invalid Operation

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.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!