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

Options
✭✭✭

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

• ✭✭✭✭
Options

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

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

• ✭✭✭✭✭✭
Options

Try this...

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

• ✭✭✭
Options

Thank you Paul, I will give that a try.

• ✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!