=COUNT({Approval Status}) prevent reporting lines

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>>?

Find more posts tagged with

Accepted answers

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")

All comments

Paul Newcome

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.