Sheet Summary Formula > COUNTIF for column using formula


Hello, I maintain a large document tracker. It has one "Pending" column that uses a massive formula (pasted below for reference) to search the tracker for missing information, and if it identifies any, the column is flagged. I'd like to create a summary formula to count the number of pending documents. I'm trying =COUNTIF(Pending:Pending, 1) but it keeps returning #INVALID OPERATION. Do you know, is my crazy formula the issue, or something else? Thanks for your help!

Massive formula:

=IF(OR(CONTAINS("TBD", Lead@row), CONTAINS("TBD", [Due Date]@row), CONTAINS("TBD", [Submission Date]@row), CONTAINS("TBD", [Redact Status]@row), CONTAINS("TBD", [Other Information]@row), CONTAINS("TBD", [Regulatory Team Notes]@row), Escalation@row = 1, [Escalation Notes]@row <> "", OR([Submission Status]@row = "Submitted, pending Follow-up", [Submission Status]@row = "Pending Request", [Submission Status]@row = "#INVALID OPERATION"), AND(OR([Submission Status]@row = "Submitted", [Submission Status]@row = "Submitted, pending Follow-up"), OR([Redact Review]@row = "Yes", [Redact Review]@row = "Yes"), [Redact Submission Date]@row = "", [Redact Status]@row = ""), AND(OR([Submission Status]@row = "Submitted?", [Submission Status]@row = "Requested?"), [Due Date]@row < TODAY()), [Copy of Submission]@row = "Pending upload"), 1)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!