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
Answers

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

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

Thank you Paul, I will give that a try.

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

You would need to replace checkbox with your actual column name.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!