Is there a way to simulate radio buttons in a Web Excel spreadsheet?
I have a desktop Excel app where I use radio buttons in multiple rows. While Google sheets doesn't have radio buttons, I was able to 'simulate' this same behavior by using checkboxes in three cells and google script code. I can't seem to find a way to do this in Web Excel. Is there any way in Web Excel to make it so that in each row I have three cells that can be clicked, and only one of them can be 'on' at once? I realize Web Excel doesn't have controls like radio buttons or checkboxes (that I can find), but could I make it so that any time one of the three cells in a row is clicked, it will 'toggle' between an 'X' and a blank value, and set the other two cells in that row to blank values?