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
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!