How to create a sum column formula in Sheet Summary

Stephanie Jai

I have a formula base column that I'm trying to get the sum in Sheet Summary and I'm getting the #invalid operation error. I have some criteria for the sum I'm looking for and I did the exact formula for the [DDA Hours Used] column, so I'm not understanding why this one isn't working.

AravindGP

Hi @Stephanie Jai

I don't see anything incorrect in the formula itself. Possibilities for the error could be due to the column type selected in Sheet Summary to showcase the value or the values in DDA Processed Date. Check to ensure that DDA Processed Date is a date column and the sheet summary column holding the value is Text/Number