Summary Sheet Formulas Corrupting when Copied

Pauline J
Pauline J ✭✭✭✭✭
edited 12/14/23 in Formulas and Functions


I am replicating (File Save As) sheets - and I have about 300 to do, with Summary Sheet fields that contain formulas.

The original formula counts the number of items in a specific column:

=COUNTIFS([Compliance Status]1:[Compliance Status]22, "Compliant")

But when it is copied to another sheet (that is identical in structure) the field shows #BLOCKED. When selecting the summary field it shows the formula as:

=COUNTIFS([Compliance Status]1:#REF, "Compliant")

Why is it not bringing over the complete formula?

(I thought I posted this yesterday but it appears as though it didn't go through)

Thanks in advance!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!