Welcome!

Linking checkbox to another column

We have a checkbox in our sheet titled "Use Existing". When that box is checked we would like for another column to be added so the person can provide that existing information. If the box is not marked then we don't want that extra column to appear. Is there a way to make this happen? Not sure if there is a formula for this ?

Find more posts tagged with

Comments

Mike Wilday

No, there is no way to accomplish this feat... you might consider using conditional formatting and black out the column. Then when the checkbox is checked have the background color of the cell turn white and the text turn black. This would allow the user to type in the column. it would have to always appear, but it would be untypeable with black type and black background until they check it off.

Hailey Loutsch

Okay thanks for your help!

Mike Wilday

You're welcome. You do need to know that if they are working on a report, that the conditional formatting will not apply until after the check, save and refresh the sheet. If they are working on the sheet themselves, then it should instantly turn white. Reports are "almost live." But not quite.