Can someone help me create % complete by using date and checkboxes?

The previous calculation I used to calculate % complete is by strictly referencing if a date is in a cell. I would like to use a combination of Date and checkboxes to determine % complete.

Previous working formula, using only dates: ((COUNTIF(ISDATE([Field work % Complete]@row), "1") * (1.8) + COUNTIF(ISDATE([Engineered Footprint % Complete]@row), "1") * (1.8) + COUNTIF(ISDATE([Received DCID's]@row), "1") * (0.6) + COUNTIF(ISDATE([Design Returned with DCID's/BOM]@row), "1") * (0.6) + COUNTIF(ISDATE([Splice Schematic/FAT % Complete]@row), "1") * (0.6) + COUNTIF(ISDATE([Final Design Completed and Returned]@row), "1") * (0.6)) / (6))

New formula: struggling to make the checkbox work: I thought I could use the same method, count if and add the "1". I tried this: =(COUNTIF(ISDATE(RFC@row), "1") + (COUNTIF(ISBOOLEAN([checkbox@row], "1"))))

The first part with date works, but can anyone help me understand how to count a checkbox (if checked)? If all things =1, I can go back and include the correct % multiplier to weight my fields properly. Is this possible?

You are always great help, Thank you for your suggestions!

Laura

Find more posts tagged with

Accepted answers

All comments

Michele Thomas

Hi @1_UTOPIAlk

On first glance it looks like you might have too many parenthesis.

Your Formula

=(COUNTIF(ISDATE(RFC@row), "1") + (COUNTIF(ISBOOLEAN([checkbox@row], "1"))))

Try this instead (not sure if will work)

=COUNTIF(ISDATE(RFC@row, "1") + (COUNTIF(ISBOOLEAN([checkbox@row], "1"))

Paul Newcome

Try this...

=COUNTIF(RFC@row, ISDATE(@cell)) + COUNTIF(checkbox@row, "1")

1_UTOPIAlk

Thank you Paul, I will give that a try.

1_UTOPIAlk

Thank you Paul, one more question, If my "checkbox" row is not titled "checkbox" will this work the same way?

Paul Newcome

You would need to replace checkbox with your actual column name.

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, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.