Review Checklist

KPV_0921

New Member
Joined
Jul 3, 2024
Messages
8
Office Version
  1. 365
Platform
  1. Windows
Hello Friends,

I need help in getting my checklist in shape. I would just want this checklist that has 2 radio buttons for each line item and that would have a formula to calculate all the Yes and No. How can I upload my working file here?

The one that I have right now does not seem to work as I expected lol I can't do Yes and No selection for each line item instead I can only select 1 from everything. Thanks in advance!

1725442348947.png
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
How can something be yes and no at the same time?
Why do we see 3 buttons when you say there are only 2?
To answer your question, you can't upload files here. You can only provide a link to a file sharing site where you've placed a copy of your file and allow access to anyone with the link. Some people won't download from file shares and some will.
 
Upvote 0
Sorry let me be clear. The requirement is for a use of this checklist to be able to select Yes OR No OR N/A in each of the line item. How can I make that happen? 🫤 thanks for the info RE: Uploading of file here.
 
Upvote 0
When in Design View you will have to make a group for each row then for each group (after all are grouped or as you go), select the 1st option. In the properties sheet, change the default group name, which usually ends up being the sheet name. Right now you can only select 1 for the whole sheet because all of your buttons are grouped by sheet. Looks like you got your work cut out for you.
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,184
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top