=COUNT({Approval Status}) prevent reporting lines

Craig Beattie

Hi All

I am using on of the templates cost tracking.

On one of the intake submitted sheets it has 2 lines saying <<Do Not Delete>>

This is fine although it is showing up on the cost metrics as 2 submitted jobs, is there a way to prevent this or do i delete the lines that say <<Do Not Delete>>?

Paul Newcome

Are there any (possibly hidden) columns that have formulas in them? If the template is pre-column formula, you used to have to keep two rows in the template so that the built in auto-fill feature would grab the formulas as new rows were added.

If there are formulas, converting them to column formulas should allow you to delete those two rows.

If you would rather leave them in, you can change from a COUNT to a COUNTIFS and exclude any rows that are "<<Do Not Delete>>" like so:

=COUNTIFS({Range}, @cell <> "Do Not Delete")

Paul Newcome

Are there any (possibly hidden) columns that have formulas in them? If the template is pre-column formula, you used to have to keep two rows in the template so that the built in auto-fill feature would grab the formulas as new rows were added.

If there are formulas, converting them to column formulas should allow you to delete those two rows.

If you would rather leave them in, you can change from a COUNT to a COUNTIFS and exclude any rows that are "<<Do Not Delete>>" like so:

=COUNTIFS({Range}, @cell <> "Do Not Delete")

Craig Beattie

@Paul Newcome That did the job thank you.

Paul Newcome

Happy to help. 👍️