2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Excel Check boxes with more than just True/False responses

Our take

Are you looking to enhance your Excel project tracker with more nuanced checkbox responses? While traditional checkboxes only toggle between TRUE and FALSE, there is a way to implement a script that allows for additional options. Imagine being able to track project statuses as "In Progress," "Complete with Exceptions," and "Complete without Exceptions." This approach not only provides tailored insights but also maintains the integrity of your Status Sheet, ensuring that everyone remains aligned and informed throughout the lifecycle of your 500 projects.

I was chatting with Gemini and it seemed to this this was possible with a script, but I could only find way to create checkboxes online...

Currently a checkbox is either checked (TRUE) or unchecked (FALSE), and clicking the box toggles between those two options, is it possible to change these two options and create a third or fourth option?

My specific use case is a project tracker, but instead of just using the checkboxes for complete or incomplete; I would like it to toggle between 1) In progress, 2) Complete with exceptions and 3) Complete without exceptions. Basically I want a bit more tailored information out of that check box, but since a lot of people use this Status Sheet I want to keep the check box logic (otherwise someone will inevitably unknowingly copy & paste data and overwrite other projects' status while rows are filtered or hidden).

For some background my team does about 500 projects and each has about 5-10 sections, so I want a nice way of tracking each project and the sections. (People have a tendency to not tell you there are exceptions lurking in the files, so I need a good way for forcing that issue to our Status Sheet).

submitted by /u/East_Direction9563
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Tagged with

#Excel alternatives for data analysis#generative AI for data analysis#financial modeling with spreadsheets#natural language processing for spreadsheets#rows.com#Excel compatibility#Excel alternatives#big data management in spreadsheets#conversational data analysis#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#Excel#checkbox#project tracker#True/False