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

Is it Possible to create 2 checkboxes in one cell

I'm kinda rustic in excel so it may sound like a stupid. I am updating the daily equipment log for work. Everyday, we have to count the equipment and write how many we have, one for the morning shift and the other for night shift (shown in Column C & D).

However some people suggested if we are able to have 2 checkboxes in one cell instead when we have the total amount and when we do not have it we can also write it in the same cell.

For example, in Column C we have a total of 16, so the morning shift counts 16 and they check it off, however night shift counts only 14 so they would have to write it down.

So it would look like ✓ | 14/16 or ✓ | ✓.

I don't want Windings 2, I would actually like the checkboxes. It also has to be in one cell.

https://preview.redd.it/s1e2sbceaklg1.png?width=3094&format=png&auto=webp&s=9527c394017f84d1d75c69ec409d6daec84fe0a4

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

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#rows.com
#checkboxes
#one cell
#equipment log
#Excel
#morning shift
#night shift
#count
#total amount
#Windings 2
#daily
#
#write it down
#Column C
#Column D
#total of 16